DSXchange

Where does DataStage store oracle directory locations (ie home, lib, etc). I got the following error:

ds_loadlibrary: error in dlopen of oraoci8.so - ld.so.1: uvsh: fatal: /oracle/app/oracle/product/9.2.0/lib/libclntsh.so: I/O error

The file libclntsh.so is not in the 9.2.0 directory however there is a 9.2.0.6 directory when we patched that has the file. I'd like to tell datastage to look in that lib directory.

It seems to me, the Oracle library path is missing in DSENV file. Oracle libraries can be found in the folder, where Oracle client is installed in DS server.

HTWH.

Regards
Saravanan

Hi,
you need to get your Oracle environment variables configured in the dsenv file along with the LD_LIBRARY_PATH or SHLIB_PATH depending on your OS (usually if you set the Oracle paths the library paths are fine since they consist of them)
To make your changes apply you will then need to stop and start the dsrpcd service (syntax is in your manuals, usually with dsadmin user and dsenv loaded its Be aware no one is connected when you "bounce" the dsrpcd service or you might need to wait till network connections time out as well as deal with locks, running processes and such.

IHTH,

Have you been using Oracle stages up to this point and are now using a new stage (like OracBulk) or have you yet to get any Oracle stages working?

On a UNIX server, it is configured in the dsenv file. There should be a Plug-In Configuration Guide which should walk you through the changes needed. Basically, ORACLE_HOME needs to be defined there and $ORACLE_HOME/lib needs to be added to your $SHLIB_PATH or equivalent.

BTW, It (the 'Shared Library' Path) has different names on different operating systems and you don't mention yours. Also, on some platforms you have to point to the 32bit libraries ($ORACLE_HOME/lib32) as the native ones are 64bit and most likely will not work with DataStage. Searching the forum will turn up a ton of posts on this subject.

Once you've done that properly, stop and restart DataStage.

Thanks for the responses. This server has been running successfully for 4 years. Apparently, this file got removed from Ora_Home/lib.

Operating system is Sun Solaris (Unix was the only choice in my first post).

Where are the DSENV file and the $SHLIB_PATH file located?

DSENV file is located in $DSHOME/DSEngine folder. SHLIB_PATH is one of the variable in the DSENV file.

HTWH.

Regards
Saravanan

Thanks.

You are welcome.

Regards
Saravanan