oraoci8.so Load error on Sunfire Sun 5.8

[rbahadur]

I have installed the datastage for Unix on the Sunfire box and also I have installed Oracle 817 client on the server. I am able to connect to my Oracle Database through SQLPlus but I get the following message when I try connecting to my database through my ETL job.

ds_loadlibrary: error in dlopen of oraoci8.so - ld.so.1: dsapi_slave: fatal: libclntsh.so: open failed: No such file or directory

I checked the libraries using ivtestlib file and I got the following output :-

$ ivtestlib libclntsh.so
Load of libclntsh.so successful, qehandle is 0xFF250490
$ ivtestlib oraoci8.so
Load of oraoci8.so failed: ld.so.1: ivtestlib: fatal: oraoci8.so: open failed: No such file or directory
$ ivtestlib ld.so.1
Load of ld.so.1 successful, qehandle is 0xFF250420
$

What should I do to resolve this error message.

Please reply ASAP since our projects are getting delayed due to this.

Thanks
Regards


Ravinder Bahadur
OCP DBA
DB2 Certified User
DB2 DBA

[uneumann]

Build the oracle clint lib for datastage describt in readme.txt on the cd.

Add ORCALE_HOME in the dsenv file and append the SHLIB with $ORACLE_HOME/lib.