Error in oracle database connection
Posted: 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
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