Page 1 of 1
Unable to find library 'libclntsh.so.10.1'
Posted: Thu Aug 21, 2008 6:26 am
by manuel.gomez
Hello guys,
We have just installed Ds v8 on a Itanium HP-UX machine, and everything works ok but oracle connectivity. This is the error we are being returned:
Code: Select all
##I IIS-DSEE-TFCN-00001 14:18:54(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4706
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 14:18:54(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 14:18:54(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 14:18:54(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 14:18:55(000) <main_program> Parameter specified but not used in flow: _APT_ORCHHOME
##W IIS-DSEE-TOSH-00049 14:18:55(001) <main_program> Parameter specified but not used in flow: _PATH
##W IIS-DSEE-TOSH-00049 14:18:55(002) <main_program> Parameter specified but not used in flow: _LD_LIBRARY_PATH
##W IIS-DSEE-TOSH-00049 14:18:55(003) <main_program> Parameter specified but not used in flow: _ORACLE_SID
##W IIS-DSEE-TOSH-00049 14:18:55(004) <main_program> Parameter specified but not used in flow: _ORACLE_HOME
>##E IIS-DSEE-TOSH-00205 14:18:55(005) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 14:18:55(006) <main_program> Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'..
>##E IIS-DSEE-TOSH-00384 14:18:55(007) <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 14:18:55(008) <main_program> Creation of a step finished with status = FAILED.
I have been surfing the forum for almost two hours, but I could fix the issue. I found a user called lstsaur that answers many times to very similar errors saying "search orchoracle and find the steps I published to solve it". I searched for his posts, but I could not find the solution, and I have read all of them!!!!!
We tried this that we found it on a post
After following the suggestions provided in this post, I created a new link to the existing libclntsh.so.10.1 library, named libclntsh.so.9.0.
Code:
$ pwd
/oracle/v1020/lib
$ ln -s libclntsh.so.10.1 libclntsh.so.9.0
$ ls -l libclntsh.so*
lrwxrwxrwx 1 oracle dba 17 Feb 4 14:14 libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-x 1 oracle dba 18762364 Feb 4 14:14 libclntsh.so.10.1
lrwxrwxrwx 1 oracle dba 17 Apr 25 13:30 libclntsh.so.9.0 -> libclntsh.so.10.1
I can also confirm that creating this link under $DSHOME/lib (versus $ORACLE_HOME/lib) also resolved my issue.
for example:
Code:
$ pwd
/vend/IBM/InformationServer/Server/DSEngine/lib
$ ln -s $ORACLE_HOME/lib/libclntsh.so.10.1 libclntsh.so.9.0
But it did not help neither
I added to my job these variables:
Code: Select all
APT_ORCHOME:/oradata/OWBDIB/is/Server/PXEngine
PATH: /oradata/OWBDIB/is/Server/PXEngine/bin:/app/oracle/product/10.2.0/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/aCC/bin:.
LD_LIBRARY_PATH: /app/oracle/product/10.2.0/lib:/usr/lib
ORACLE_SID: OWBBD
ORACLE_HOME: /app/oracle/product/10.2.0
So, I am totally desperated honestly, we are having a lot of pressures to have this fixed
Any help will be so much appreciated.....
Posted: Thu Aug 21, 2008 7:05 am
by chulett
I'm curious, if you are under pressure for a fix have you not asked your support provider for help?
I had a similar issue with Server on Itanium, when I get in the office I'll see if I can find their answer in my archives.
Posted: Thu Aug 21, 2008 7:39 am
by manuel.gomez
chulett wrote:I'm curious, if you are under pressure for a fix have you not asked your support provider for help?
Its a long story, but not, I am afraid we cannot claim for support
It will be fantastic if you send us your notes
Posted: Thu Aug 21, 2008 7:57 am
by chulett
Performing without a net, eh? Or I guess we be the net.
I'll see what I can find.
Posted: Thu Aug 21, 2008 9:19 pm
by keshav0307
Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'.
do you have the orchoracle softlink in your $DSHOME/../PXEngine/lib or $APT_ORCHOME/lib path
Posted: Fri Aug 22, 2008 1:47 am
by manuel.gomez
keshav0307 wrote:Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'.
do you have the orchoracle softlink in your $DSHOME/../PXEngine/lib or $APT_ORCHOME/lib path
I dont know from where and where to I do have to create the softlink
Posted: Fri Aug 22, 2008 1:50 am
by keshav0307
do you have any file or link for orchoracle at $APT_ORCHOME/lib
Posted: Tue Oct 14, 2008 7:18 am
by coface
manuel.gomez wrote:keshav0307 wrote:Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'.
do you have the orchoracle softlink in your $DSHOME/../PXEngine/lib or $APT_ORCHOME/lib path
I dont know from where and where to I do have to create the softlink
If you are using an oracle 9i environment, try to add the following softlink to your DSEngine/lib directory: libclntsh.so.10.1 -> [path to your oracle 9i installation]/lib/libclntsh.so.9.0
If you are using an oracle 10g environment, 1st check your PATH and LD_LIBRARY_PATH environment variables if they contain correct entries for your 10g installation. 2nd try to add a similar softlink like the one previously mentioned but pointing to your 10g-installation path/lib/libclntsh.so.10.1.
In out case it solved the "library not found" error.
Re: Unable to find library 'libclntsh.so.10.1'
Posted: Thu Jan 22, 2009 10:29 pm
by jatinrheen
Hi,
Check the access to the Oracle directory . I faced the same issue and I just did a chmod on the oracle directory .
Regards
Jatinder
manuel.gomez wrote:Hello guys,
We have just installed Ds v8 on a Itanium HP-UX machine, and everything works ok but oracle connectivity. This is the error we are being returned:
Code: Select all
##I IIS-DSEE-TFCN-00001 14:18:54(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4706
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 14:18:54(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 14:18:54(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 14:18:54(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 14:18:55(000) <main_program> Parameter specified but not used in flow: _APT_ORCHHOME
##W IIS-DSEE-TOSH-00049 14:18:55(001) <main_program> Parameter specified but not used in flow: _PATH
##W IIS-DSEE-TOSH-00049 14:18:55(002) <main_program> Parameter specified but not used in flow: _LD_LIBRARY_PATH
##W IIS-DSEE-TOSH-00049 14:18:55(003) <main_program> Parameter specified but not used in flow: _ORACLE_SID
##W IIS-DSEE-TOSH-00049 14:18:55(004) <main_program> Parameter specified but not used in flow: _ORACLE_HOME
>##E IIS-DSEE-TOSH-00205 14:18:55(005) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 14:18:55(006) <main_program> Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'..
>##E IIS-DSEE-TOSH-00384 14:18:55(007) <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 14:18:55(008) <main_program> Creation of a step finished with status = FAILED.
I have been surfing the forum for almost two hours, but I could fix the issue. I found a user called lstsaur that answers many times to very similar errors saying "search orchoracle and find the steps I published to solve it". I searched for his posts, but I could not find the solution, and I have read all of them!!!!!
We tried this that we found it on a post
After following the suggestions provided in this post, I created a new link to the existing libclntsh.so.10.1 library, named libclntsh.so.9.0.
Code:
$ pwd
/oracle/v1020/lib
$ ln -s libclntsh.so.10.1 libclntsh.so.9.0
$ ls -l libclntsh.so*
lrwxrwxrwx 1 oracle dba 17 Feb 4 14:14 libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-x 1 oracle dba 18762364 Feb 4 14:14 libclntsh.so.10.1
lrwxrwxrwx 1 oracle dba 17 Apr 25 13:30 libclntsh.so.9.0 -> libclntsh.so.10.1
I can also confirm that creating this link under $DSHOME/lib (versus $ORACLE_HOME/lib) also resolved my issue.
for example:
Code:
$ pwd
/vend/IBM/InformationServer/Server/DSEngine/lib
$ ln -s $ORACLE_HOME/lib/libclntsh.so.10.1 libclntsh.so.9.0
But it did not help neither
I added to my job these variables:
Code: Select all
APT_ORCHOME:/oradata/OWBDIB/is/Server/PXEngine
PATH: /oradata/OWBDIB/is/Server/PXEngine/bin:/app/oracle/product/10.2.0/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/aCC/bin:.
LD_LIBRARY_PATH: /app/oracle/product/10.2.0/lib:/usr/lib
ORACLE_SID: OWBBD
ORACLE_HOME: /app/oracle/product/10.2.0
So, I am totally desperated honestly, we are having a lot of pressures to have this fixed
Any help will be so much appreciated.....