DBMS_SCHEDULER External Job Fail With ORA-27301/ORA-27302 at: sjsec 6a
Last updated on DECEMBER 08, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms