various reasons for ORA-27369: job of type EXECUTABLE failed with exit code

Last updated on AUGUST 10, 2016

Applies to:

Symptoms

You are calling an external sh script with Scheduler job, for example,

BEGIN
dbms_scheduler.create_job(job_name => 'myjob005',
job_type => 'executable',
job_action => '/home/java/pdf/ToPDF.sh');
end;

Run this scheduler job fails with errors like

ORA-27369: job of type EXECUTABLE failed with exit code: Value too large to be stored in data type

ORA-27369: job of type EXECUTABLE failed with exit code: Not owner

.....

However, '/home/java/pdf/ToPDF.sh'  runs successfully if called from OS.

Cause