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