ORA-27370, ORA-27300, ORA-27302 FAILED at sjsec 6a Errors Reported When Running External Job
(Doc ID 1059981.1)
Last updated on FEBRUARY 02, 2022
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.
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 worker 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |