Error when using the Oracle Enterprise stage in DS 8.7

[marcelo_almeida]

Hello everybody,

I am having problems using the Oracle Enterprise stage to read a database oracle.11 64-bit. I saw some people had some errors like, but I could not find an answer to correct this error.

With the stage "Oracle Connector" everything is working fine.

I'm getting this error message: "main_program: Error loading "orchoracle": Could not load "orchoracle": libclntsh.so.10.1: cannot open shared object file: No such file or directory."

The oracle is on the same machine that DataStage 8.7.
The operating system is Red Hat 5 64-bit

The content of my dsenv is:

Code: Select all

# Oracle

     ORACLE_BASE = / u01/app/oracle;
     export ORACLE_BASE

     ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/xe;
     export ORACLE_HOME

     PATH = $ PATH: $ APT_ORCHHOME / bin: $ ORACLE_HOME / bin;
     export PATH

     ORACLE_SID = XE;
     export ORACLE_SID

 # End Oracle

# Inclusion of the home of the oracle LD_LIBRARY_PATH

 LD_LIBRARY_PATH = $ ORACLE_HOME / lib: $ ORACLE_HOME / rdbms / lib: $ LD_LIBRARY_PATH
 export LD_LIBRARY_PATH

 # End Inclusion in the home of the oracle LD_LIBRARY_PATH

Note: It is also experiencing a similar error when I use the stage Oracle OCI in Server jobs.


Thank you!