DSXchange

I am getting flowing error when trying to access remote datastage though OCI plugin.

ORA-12537: TNS:connection closed

Its never happen sql promt. I am getting this error every 10.20 min. Some time its work fine.

I am trying to access remote database using 10/12 OCI pluging in same job.

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...

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 ne...