DBMS_SCHEDULER External Job Fail With ORA-27301/ORA-27302 at: sjsec 6a

(Doc ID 1074922.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Database - Enterprise Edition - Version and later
Linux x86-64
***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

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