libclntsh.so.10.1: cannot open shared object file

[udayk_2007]

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

[chulett]

So where, above the line you posted, is ORACLE_HOME set?

[PaulVL]

Also, has the job ever run before or is this the first time you've tried this job?

From the command line after sourcing dsenv.. echo $ORACLE_HOME.

Did your Oracle team update their client without telling you? (path change perhaps).