1 Reply Latest reply: May 19, 2014 8:03 AM by GregV RSS

    ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied


      Experts: Can someone please help me figure out what am I missing here? It used to work perfectly on 11g but stopped working on 12c.


      This is the job that fails:




        DBMS_SCHEDULER.create_program (

          program_name        => 'executable_prog',

          program_type        => 'EXECUTABLE',

          program_action      => '/u01/app/oracle/admin/naratest/dpdump/test.sh',

          number_of_arguments => 0,

          enabled             => TRUE,

          comments            => 'Shell Script through oracle');




      I confirmed the permissions on these files are good:


      [oracle@oracle01 ~]$ ls -l $ORACLE_HOME/rdbms/admin/externaljob.ora

      -rw-r-----. 1 root oinstall 1534 Dec 21  2005 /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/externaljob.ora


      [oracle@oracle01 ~]$ ls -l $ORACLE_HOME/bin/extjob

      -rwsr-x---. 1 root oinstall 1603590 Feb 25 16:33 /u01/app/oracle/product/12.1.0/dbhome_1/bin/extjob


      Per Oracle doc ORA-27369: Job of Type Executable Failed with Exit Code: Permission Denied (Doc ID 754641.1)


      Looks like i need to set but I don't see the oracle "file".


      You need to modify the permissions of the file as the "root" user.


      # ls -l oracle

      -rwxr-x--x 1 oracle dba 5273192 Feb 25 07:04 oracle



      Now change the permissions so the file is "setuid" and "setgid"


      # chmod 6751 oracle

      -rwsr-s--x 1 oracle dba 5273192 Feb 25 07:04 oracle