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