OCI Stage error - dsloadlibrary

[sankarsadasivan]

We installed Datastage 5 on the unix mahcine and imported few jobs (which were running fine in another machine)

We get the following error, on all the jobs using OCI stage


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

We suspect this is due to the installation.

Any ideas?

Many thanks,
sankar

[chulett]

I suspect so, too.

Did you go through the configuration steps required for the Oracle plug-ins, specifically the changes needed in the dsenv file? Do you have an Oracle client installed on this new server?

[sankarsadasivan]

Thanks for your response.

Yes, we missed few of the installation steps mentioned in the guide.

Fyi, We did the following and it is now working fine.

1) Installaed Oracle 8i Client
2) Installed Oracle 8i Enterprise Server 8.1.7.4_32 client libraries
3) Included the following varriables in the dsenv file

ORACLE_HOME=/opt/oracle/product/8.1.7.4_32; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH;export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$dshome/../branded_odbc/lib:$dshome/lib:/.dslibs
LD_LIBRARY_PATH=$dshome/../branded_odbc/lib:$dshome/lib:/.dslibs
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=/.dslibs:$dshome/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH

Thanks Again
Sankar