Wednesday, September 25, 2013

ORA-27369 job of type EXECUTABLE failed : Permission denied

This error is raised when from the DB scheduler you try to execute an executable created on the O/S Level.
In order to fix this error you can do the following :

Unix like O/S

- From 10.2.0.3 and up (11gR2 validated) you just need to edit the file $ORACLE_HOME/rdbms/admin/externaljob.ora and put the user oracle instead of nobody. 

Usually this must be done as root user.

e.g 

run_user = oracle
run_group = oinstall

#run_user = nobody

#run_group = nobody


- In prior releases there is no $ORACLE_HOME/rdbms/admin/externaljob.ora and you need to change the owner of the extjob executable from nobody to oracle 

Windows O/S

Change the user that the external jobs extjob Windows service runs as



No comments:

Post a Comment