DSXchange

We are getting the following error from the server job using Oracle 9i stage :

ds_loadlibrary: error in dlopen of oraoci9.so - ld.so.1: uvsh: fatal: libclntsh.so.9.0: open failed: No such file or directory


Does it mean there is a problem with the plug in installation?
Any ideas?

Thanks
Sankar

Yes, it means you haven't properly configured DataStage to support the OCI stages. Read the Configuration Guide for the steps needed, they involve changes to your dsenv file to set an ORACLE_HOME and include the Oracle libraries in your appropriate LIB_PATH environment variable.

Once done, you'll need to stop and restart DataStage for the changes to take effect.