ORA-27370, ORA-27300, ORA-27302 FAILED at sjsec 6a Errors Reported When Running External Job (Doc ID 1059981.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2016***

Symptoms


Database version 10.2.0.4

External jobs not running using DBMS_SCHEDULER
getting ORA-27300, ORA-27301 and ORA-27302 errors:

ORA-12012: error on auto execute of job 18353
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:getting external job pid failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sjsec 6a

- DB has been started as Oracle software owner

- Following permission for the files:

$ ls -lrt $ORACLE_HOME/bin/extjob*

ls -lrt $ORACLE_HOME/bin/extjob*

-rwxr-x--- 1 oracle dba 1158136 Oct 25 2008 /optware/oracle/10.2.0.4/db/bin/extjoboO
-rwxr-x--- 1 oracle dba 1158136 Oct 25 2008 /optware/oracle/10.2.0.4/db/bin/extjobO
-rwxr-xr-x 1 oracle dba 30976 Sep 15 10:21 /optware/oracle/10.2.0.4/db/bin/extjobo
-rwsr-x--- 1 root dba 30968 Sep 15 10:21 /optware/oracle/10.2.0.4/db/bin/extjob

- entry in externaljob.ora :

run_user and run_group was set to nobody

Changes

No changes

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