Error in oracle database connection

vintipa · Post by **vintipa** » Mon Nov 24, 2008 2:58 am

hi,
We are not able to establish connectivity to oracle database from datastage.

We have installed DS 7.5.1 A Enterprise Edition in both our development and production environments.

We are using server option for creation of jobs and not parallel jobs option.

Datastage is installed in one server and Oracle database is in another server.

We have installed oracle client in the server where datastage is installed.

We have updated TNSNAMES.ORA file with connectivity details to above mentioned oracle database.

We were able to establish connection to oracle database through SQLPLUS from the server where datastage is installed.

But when we are trying to connect to same database through datastage using Oracle OCI stage, we are getting below error.

ds_loadlibrary: error in dlopen

ArndW · Post by **ArndW** » Mon Nov 24, 2008 4:55 am

You probably need to correct your dsenv file. Read the ORACLE chapter in the IBM Information Server Planning, Installation, and Configuration Guide to get the details of what additions you need to make to the dsenv file.