DBMS_SCHEDULER External Job Fail With ORA-27301/ORA-27302 at: sjsec 6a
(Doc ID 1074922.1)
Last updated on JULY 08, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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 secondary 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