Recently I have installed Oracle on to Redhat Linux. When they loaded there DBMS_SCHEDULER jobs, the external jobs would not run, they would just hang at the SQL prompt when we tried to run them manually.
Once you quit your session, you get
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:getting external job pid failed with
status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sjsec 6a
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1
What I did to resolve this error was to edit the file listed below
$ORACLE_HOME/rdbms/admin/externaljob.ora
and I changed the nobody nobody to oracle and oinstall (oinstall being my primary group for the oracle user)
Once I made the change, I ran the job manually and it works perfectly.
SQL> exec dbms_scheduler.run_job(job_name=>'PRE_EOD_CHECKS');
PL/SQL procedure successfully completed.
I am always interested in your thoughts so if you have any comments or feedback then please feel free to add any comments, or you can mail me here.
