Hi,
I am running dbms_scheduler with job_type => 'executable'.
Its failed on :
ORA-27369: job of type EXECUTABLE failed with exit code: Key has expired
STANDARD_ERROR="sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory"
The shell script is as followed:
cat poc_type1.sh
#!/bin/ksh
export ORACLE_HOME=/software/oracle/DB10gR2
export ORACLE_SID=pudwh
export LD_LIBRARY_PATH=/software/oracle/DB10gR2/lib:/usr/lib
export PATH=/software/oracle/DB10gR2/bin:/software/oracle/DB10gR2/OPatch:/usr/ccs/bin:/usr/local/coreutils/bin/:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:.:/software/oracle/dba/scripts/bin:/usr/sbin:/software/oracle/dba/scripts/PERL/bin:/software/oracle/dba/scripts/sh:/software/oracle/dba/scripts:/usr/contrib/bin:/sbin:/usr/omni/bin:/usr/local/bin/:/software/oracle/DB10gR2/jdk/bin
env | sort -o /tmp/capture.env
sqlplus myuser/mypasswd@pudwh @/software/oracle/PATCHES/POC_AD0FFFKMZ6QQ0.sql
and /tmp/capture.env shows :
$ cat capture.env
A__z="*SHLVL
LD_LIBRARY_PATH=/software/oracle/DB10gR2/lib:/usr/lib
ORACLE_HOME=/software/oracle/DB10gR2
ORACLE_SID=pudwh
PATH=/software/oracle/DB10gR2/bin:/software/oracle/DB10gR2/OPatch:/usr/ccs/bin:/usr/local/coreutils/bin/:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:.:/software/oracle/dba/scripts/bin:/usr/sbin:/software/oracle/dba/scripts/PERL/bin:/software/oracle/dba/scripts/sh:/software/oracle/dba/scripts:/usr/contrib/bin:/sbin:/usr/omni/bin:/usr/local/bin/:/software/oracle/DB10gR2/jdk/bin
PWD=/
SHLVL=1
_=*13911*/bin/env
{code}
Please advice
Thanks