OCI9i Stage error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sankarsadasivan
Premium Member
Premium Member
Posts: 39
Joined: Tue Dec 23, 2003 3:47 am
Location: India

OCI9i Stage error

Post by sankarsadasivan »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply