Oracle Scheduler job fails with: ORA-27369: job of type EXECUTABLE failed with exit code: 274662
It's Standard version - Oracle Database 11g Release 11.2.0.3.0 - 64bit Production.
Linux CentOS 6.3
Any shell script fails with above error, but I can run it manually.
For example:
$ cat scripts/test.sh
#!/bin/bash
ls -l >> /tmp/ls.log
After manually running, I can see /tmp/ls.log as expected.
$ ls -l /tmp/ls.log
-rw-r--r--. 1 oracle oinstall 1001 Feb 21 10:56 /tmp/ls.log
BUT Under scheduler...
SQL> EXEC DBMS_SCHEDULER.CREATE_JOB(job_name=>'Test',JOB_TYPE=>'EXECUTABLE',JOB_ACTION=>'/home/oracle/test.sh');
PL/SQL procedure successfully completed.
SQL> exec DBMS_SCHEDULER.RUN_JOB('Test');
BEGIN DBMS_SCHEDULER.RUN_JOB('Test'); END;
0