If as an Oracle DBA you want to generate a file within oracle and ftp it to an ftp server using an oracle scheduler_job .You probably might run into an error like this below
ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied
The solution is easy.
- On the unix oracle server run the following as oracle
ls -l $ORACLE_HOME/rdbms/admin/externaljob.ora
The result should return something similar to this depending on your file tree layout
–rw-r—– 1 root oinstall 1536 Apr 16 17:23 /u01/app/oracle/product/11.2-EE/rdbms/admin/externaljob.ora
- As you can see the file by default is read only for oracle,so let’s sudo su – and edit it
sudo su –
vi /u01/app/oracle/product/11.2-EE/rdbms/admin/externaljob.ora
change the run_user from nobody to oracle and change the run_group from nobody to oinstall as show below and save it
run_user = oracle
run_group = oinstall
- Then you are done.The job should run now