Oracle 10g upgrade problem

cdas · Post by **cdas** » Thu Mar 30, 2006 9:14 am

We have upgraded our database to from oracle 9i to oracle 10g so

I am getting this error when trying to access Oracle using OCI stage.

ds_loadlibrary: error in dlopen of oraoci8.so - ld.so.1: uvsh: fatal: /orahome9/app/oracle/product/10.2.0/db_1/lib/libclntsh.so: wrong ELF class: ELFCLASS64

Do we need to set any parameter?

chulett · Post by **chulett** » Thu Mar 30, 2006 9:19 am

Sounds like you've put the 64bit Oracle library in your shared library path in the dsenv file. Change it to the 32bit library (usually lib32 instead of just lib), then stop and restart DataStage.

cdas · Post by **cdas** » Thu Mar 30, 2006 9:56 am

chulett wrote:Sounds like you've put the 64bit Oracle library in your shared library path in the dsenv file. Change it to the 32bit library (usually lib32 instead of just lib), then stop and restart DataStage.

Thanks for your help. Its working fine now...