Page 1 of 1
OCI Stage error - dsloadlibrary
Posted: Thu Nov 17, 2005 4:09 am
by 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
Posted: Thu Nov 17, 2005 8:01 am
by 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?
Posted: Fri Nov 18, 2005 10:03 am
by 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