Problem accessing Oracle 9i stage in DS7.5

vijay.subramani · Post by **vijay.subramani** » Thu Sep 30, 2004 12:11 pm

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.

kcbland · Post by **kcbland** » Thu Sep 30, 2004 12:33 pm

Have you configured the dsenv file?

tonystark622 · Post by **tonystark622** » Thu Sep 30, 2004 2:05 pm

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

tonystark622 · Post by **tonystark622** » Thu Sep 30, 2004 2:07 pm

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

vijay.subramani · Post by **vijay.subramani** » Fri Oct 01, 2004 8:57 am

kcbland wrote:Have you configured the dsenv file?

We have configured the dsenv file for Oracle.

vijay.subramani · Post by **vijay.subramani** » Fri Oct 01, 2004 9:01 am

Thank Tony, let me check that out.

Eric · Post by **Eric** » Mon Oct 04, 2004 4:49 am

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.

vijay.subramani · Post by **vijay.subramani** » Mon Oct 04, 2004 5:34 am

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.