Hello Friends
I am getting this error while running the job from director
>##E IIS-DSEE-TOSH-00205 13:52:28(006) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 13:52:28(007) <main_program> Error loading "orchoracle": Could not load "orchoracle": libclntsh.so.10.1: cannot open shared object file: No such file or directory.
>##E IIS-DSEE-TOSH-00384 13:52:28(008) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E IIS-DSEE-TCOS-00029 13:52:28(009) <main_program> Creation of a step finished with status = FAILED.
I checked the LD_LIBRARY_PATH from the director.
LD_LIBRARY_PATH=/opt/IBM/InformationServer/Server/Projects/dstage1/RT_BP1.O:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSParallel:/opt/IBM/InformationServer/Server/PXEngine/user_lib:/opt/IBM/InformationServer/Server/PXEngine/lib:/opt/IBM/InformationServer/Server/Projects/dstage1/buildop:/lib:/usr/lib64:/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86_64:/opt/IBM/InformationServer/Server/StagingArea/Mothballed/DRS/Server/linux64:/usr/lib:.
It looks like,ORACLE_HOME value is not getting the value, which is causing the value to be \lib instead of /opt/oracle/product/11.2.0/client_1/lib.
For reference, entry in dsenv file for LD_LIBRARY_PATH is as below
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/lib64:`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponent
s/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/linux-all-x
86_64:`dirname $DSHOME`/StagingArea/Mothballed/DRS/Server/linux64
Please can you help/suggest
libclntsh.so.10.1: cannot open shared object file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am