Page 1 of 1
Problem accessing Oracle 9i stage in DS7.5
Posted: Thu Sep 30, 2004 12:11 pm
by vijay.subramani
We had installed DS 7x , Oracle 9i client in the solaris box. While trying to use Oracle OCI stage, it gives the following error: ds_loadlibrary: error in dlopen of oraoci9.so - ld.so.1: dsapi_slave: fatal: /opt/udb/u01/oracle/product/9.2.0/lib/libclntsh.so: wrong ELF class: ELFCLASS64 . ODBC stage using Oracle works fine. Any input would be greatly appreciated.
Thanks.
Posted: Thu Sep 30, 2004 12:33 pm
by kcbland
Have you configured the dsenv file?
Posted: Thu Sep 30, 2004 2:05 pm
by tonystark622
In earlier versions of DataStage the Oracle lib32 directory had to be in the path before the lib directory. I don't know if this is an issue with 7.5 or not.
Tony
Posted: Thu Sep 30, 2004 2:07 pm
by tonystark622
In earlier versions of DataStage the Oracle lib32 directory had to be in the path before the lib directory. I don't know if this is an issue with 7.5 or not.
Tony
Posted: Fri Oct 01, 2004 8:57 am
by vijay.subramani
kcbland wrote:Have you configured the dsenv file?
We have configured the dsenv file for Oracle.
Posted: Fri Oct 01, 2004 9:01 am
by vijay.subramani
Thank Tony, let me check that out.
Posted: Mon Oct 04, 2004 4:49 am
by Eric
I have seen this, the oracle 'ELF' error is due to loading the 64bit oracle libraries. DataStage must use the oracle 32 bit libraries.
tonystark622 has the right answer.
Posted: Mon Oct 04, 2004 5:34 am
by vijay.subramani
Eric wrote:I have seen this, the oracle 'ELF' error is due to loading the 64bit oracle libraries. DataStage must use the oracle 32 bit libraries.
tonystark622 has the right answer.
Thanks Eric. That's right, 64-bit was causing the problem. Its now working fine with 32-bit. Thanks all for your help.