ds_loadlibrary Error in using Oracle 9i stage in DataStage7
Posted: Fri Nov 26, 2004 5:06 am
Hi,
Hi Iam usign DataStage 7.0 version on Unix : HP-UX 11
The following the error message that I am getting when I try to view data of an Oracle 9i Stage
ds_loadlibrary -error in dl open - Dynamic error
I have configured the Oracle Home in the dsenv file.
ORACLE_HOME=/opt/oracle/9.2.0.4.0/
ORAHOME=/opt/oracle/9.2.0.4.0/
export ORACLE_HOME ORAHOME
SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC/hotspot:$DSHOME/java/jre/lib/PA_RISC:/opt/oracle/9.2.0.4.0/lib:$SHLIB_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
export SHLIB_PATH
I am able to view the Tables under the given data source to build the query. The same data source is also working fine with the ODBC Stage.
Are there any other setting to be done
Any help to overcome this hurdle is really Appreciable. Thanks in advance.
Thanks
Vijay
Hi Iam usign DataStage 7.0 version on Unix : HP-UX 11
The following the error message that I am getting when I try to view data of an Oracle 9i Stage
ds_loadlibrary -error in dl open - Dynamic error
I have configured the Oracle Home in the dsenv file.
ORACLE_HOME=/opt/oracle/9.2.0.4.0/
ORAHOME=/opt/oracle/9.2.0.4.0/
export ORACLE_HOME ORAHOME
SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC/hotspot:$DSHOME/java/jre/lib/PA_RISC:/opt/oracle/9.2.0.4.0/lib:$SHLIB_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
export SHLIB_PATH
I am able to view the Tables under the given data source to build the query. The same data source is also working fine with the ODBC Stage.
Are there any other setting to be done
Any help to overcome this hurdle is really Appreciable. Thanks in advance.
Thanks
Vijay