My Oracle Support Banner

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
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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.