Sunday, December 20, 2009

Error "ORA-27369: job of type EXECUTABLE failed with exit code: Not owner" When Using dbms_scheduler


Applies to: 
Oracle Server - Enterprise Edition - Version: 10.1.0.3.0
This problem can occur on any platform.






Symptoms
When trying to call a shell script from dbms_scheduler as follows:
BEGIN
dbms_scheduler.create_job(job_name => ‘myjob’,
job_type => ‘executable’,
job_action =>
‘/usr/users/oracle/admin/bin/test.bash’,
enabled => TRUE,
auto_drop => TRUE);
END;
/
exec dbms_scheduler.run_job(’myjob’);
The following errors are occurring in the alert.log file:
Errors in file /dev_app/oracle/admin/DEV/bdump/dev_j000_1194159.trc:
ORA-12012: error on auto execute of job 11212220
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner CauseSetup of the $ORACLE_HOME/bin/extjob directory was incorrectly setup for an invalid user.
Solution
Change the owner of the $ORACLE_HOME/bin/extjob directory to the owner being used.

No comments: