This content has been marked as final. Show 2 replies
Please see this post
Guide to External Jobs on 10g with dbms_scheduler e.g. scripts,batch files
In particular check that permissions on $ORACLE_HOME/rdbms/admin/externaljob.ora and $ORACLE_HOME/bin/extjob are correct
Also note that your script will not run because you need to set ORACLE_HOME, ORACLE_SID and PATH so that sqlplus can be found and will run.
Hope this helps,
I need your help.
I am using Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
Trying to execute a shell script using DBMS_SCHEDULER
I getting following errors.
I did not find the extjob in the $ORACLE_HOME
ORA-27369: job of type EXECUTABLE failed with exit code: 274662
STANDARD_ERROR="Oracle Scheduler error: Config file is not owned by root or is writable by group or other or extjob is not setuid and owned by root"
Previously I was getting the following error
ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
Any suggestions from you are much appreciated.