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:
BEGINThe following errors are occurring in the alert.log file:
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’);
Errors in file /dev_app/oracle/admin/DEV/bdump/dev_j000_1194159.trc:Solution
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.
Change the owner of the $ORACLE_HOME/bin/extjob directory to the owner being used.
No comments:
Post a Comment