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

    Kevin_K

      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:

       

      BEGIN

       

        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');

         

      END;   

       

      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

      Thanks