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

(Doc ID 1561664.1)

Last updated on AUGUST 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms