ds_loadlibrary Error in using Oracle 9i stage in DataStage7

[Vijay Kumar]

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

[roy]

Hi,
do you have a 64 bit oracel version? (DS needs a 32 bit client)
as I remember a while back there was an issue using ora 9 libraries and work around was to use the ora 8 libraries.

Search this forum I bet you'll find something usufull.

IHTH,

[chulett]

As noted by Roy - change the section of the SHLIB_PATH that references your Oracle Home to look like this:

Code: Select all

$ORACLE_HOME/lib32:$ORACLE_HOME/lib

You need to make sure the 32bit libraries come first. I'm not even sure you need the second 'lib' statement, and 'rdbms/lib' is not something I've needed on HP/UX yet. We're running the same O/S and this is what ours looks like.

Give that a shot. Don't forget to stop and restart DataStage after you make the change.