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 10.2.0.4 and later
Linux x86-64
***Checked for relevance on 07-Dec-2016***

Symptoms

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.

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