Oracle Library
Moderators: chulett, rschirm, roy
Oracle Library
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.
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.
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,
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
Code: Select all
$DSHOME/bin/uv -admin -stop ; sleep 30 ; $DSHOME/bin/uv -admin -start
IHTH,
Last edited by roy on Wed Aug 24, 2005 6:50 am, edited 1 time in total.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers