Error while using Oracle OCI stage

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
vinodlakshmanan
Participant
Posts: 82
Joined: Wed Jul 14, 2004 7:21 am
Location: India

Error while using Oracle OCI stage

Post by vinodlakshmanan »

I get the following error when trying to view data in my Oracle 9i OCI stage:
ds_loadlibrary: error in dlopen - Dynamic Error
What could be the problem?
Integrity is what you do when no one is watching
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You haven't properly configured DataStage to support the OCI stages. Follow the steps outlined in the Plugin Configuration Guide or the OCI reference, both available in your Docs directory as pdf files.

If you think you've already done that, let us know what steps you did do and we'll see about getting it straightened out. Make sure you mention which UNIX O/S you are running as it can make a difference.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Did you check whether you have the execute permission to the libraries installed by DataStage?
Post Reply