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:
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
I do see an "oracle" binay in that location, but I'm on 22.214.171.124.
The note you're mentioning is not listed as valid for 12c, so it doesn't probably apply. You could open an SR.