DBMS_SCHEDULER External Job Fail With ORA-27301/ORA-27302 at: sjsec 6a
(Doc ID 1074922.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
***Checked for relevance on 07-Dec-2016***
Through dbms_scheduler, Unix shell scripts are being called but fail with error message:
ORA-12012: error on auto execute of job 100613
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
When the external job is run via strace/truss that extjob could not find libclntsh.so.10.1
The OS "ldd $ORACLE_HOME/bin/extjob" command returns correct $ORACLE_HOME/lib location for libclntsh and the permission on the file are correct.
Setting "LD_LIBRARY_PATH" to point to "$ORACLE_HOME/lib" where the library actually resides in the environment or in the external job shell script does not resolve problem either.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document