Thanks for the question, Robert.
Asked: February 07, 2018 - 2:27 pm UTC
Last updated: February 08, 2018 - 3:48 am UTC
Version: 11g
Viewed 1000+ times
You Asked
Hello,
I have this job (EXECUTABLE) that exec a bash script.
Here's a resume of what it does
connect to a FTP server, get a file, call a pkg via sqlplus using the files as external table in order to import data.
The job fails with 'ORA-27369: job of type EXECUTABLE failed with exit code: Bad address' although the script runs correctly. The script itself logs into a file during the entire execution and exits correctly doing all of its stuff.
The strange thing is that sometimes the job exits successfully so I cannot understand.
The script:
-rwxrwxrwx 1 oracle oinstall 21253 7 feb 13:00 script.sh
Status
FAILED
ERROR#
14
Additional info of job
ORA-27369: job of type EXECUTABLE failed with exit code: Bad address
Let me know if you need anything else
Thank you,
Robert
and Connor said...
Two MOS notes you should check, because there's a few potential causes here
ORA-27369: job of type EXECUTABLE failed with exit code: 274667 (Doc ID 1300215.1)
DBMS_SCHEDULER FAILS WITH ORA-27369 WHEN JOB TYPE IS EXECUTABLE (Doc ID 279866.1)
Both have workaround's and/or patches.
Is this answer out of date? If it is, please let us know via a Comment