Unable to find library 'libclntsh.so.10.1'

manuel.gomez · Post by **manuel.gomez** » Thu Aug 21, 2008 6:26 am

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.....

chulett · Post by **chulett** » Thu Aug 21, 2008 7:05 am

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.

manuel.gomez · Post by **manuel.gomez** » Thu Aug 21, 2008 7:39 am

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

chulett · Post by **chulett** » Thu Aug 21, 2008 7:57 am

Performing without a net, eh? Or I guess we be the net.

I'll see what I can find.

keshav0307 · Post by **keshav0307** » Thu Aug 21, 2008 9:19 pm

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

manuel.gomez · Post by **manuel.gomez** » Fri Aug 22, 2008 1:47 am

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

keshav0307 · Post by **keshav0307** » Fri Aug 22, 2008 1:50 am

do you have any file or link for orchoracle at $APT_ORCHOME/lib

coface · Post by **coface** » Tue Oct 14, 2008 7:18 am

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.

jatinrheen · Post by **jatinrheen** » Thu Jan 22, 2009 10:29 pm

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.....

DSXchange

Unable to find library 'libclntsh.so.10.1'

Unable to find library 'libclntsh.so.10.1'

Re: Unable to find library 'libclntsh.so.10.1'