Page 1 of 1
Oracle stage throwing library failure: open failed
Posted: Mon Apr 20, 2009 11:11 am
by devilsmentor
Hi,
When I try to execute a server job. I am getting the below error
ds_loadlibrary: error in dlopen of /dstage/Ascential/DataStage/DSEngine/lib/oraoci9.so - ld.so.1: dsapi_slave: fatal: libclntsh.so: open failed: No such file or directory
I checked the ODBC stage and the "view data" works fine. But for all oracle stages I see this error when i try to "view data" or run the job. Can anyone please help?
Re: Oracle stage throwing libaray failure error
Posted: Mon Apr 20, 2009 12:01 pm
by devilsmentor
devilsmentor wrote:Hi,
When I try to execute a server job. I am getting the below error
ds_loadlibrary: error in dlopen of /dstage/Ascential/DataStage/DSEngine/lib/oraoci9.so - ld.so.1: dsapi_slave: fatal: libclntsh.so: open failed: No such file or directory
I checked the ODBC stage and the "view data" works fine. But for all oracle stages I see this error when i try to "view data" or run the job. Can anyone please help?
I can post more info if needed.
Posted: Mon Apr 20, 2009 2:23 pm
by chulett
Has the OCI stage ever worked? Meaning, did it work before and is broken now, or is this the first time you are attempting to use it?
Posted: Mon Apr 20, 2009 2:35 pm
by devilsmentor
This is the first time we are running it. Also, I have searched forum and found a post but the issue was with 32 bit or 64 oracle binary files. I checked the path and it seems we are using 32 bit path only. Dont know what else to do.
Posted: Mon Apr 20, 2009 4:06 pm
by chulett
So, what have you done to prepare the way? Installed Oracle client? Edited your dsenv file? That should do it. Post the relevant section of your dsenv file if you're unsure you've done it right.
Posted: Mon Apr 20, 2009 7:33 pm
by devilsmentor
Craig,
Thanks for your response. I have checked the dsenv file and it is exactly the same we have from production, and of course the parameters were changed for login credentials. And the LD_LIBRARY_PATH has lib32 prior to lib as suggested in few previous posts (links posted below). The issue appears to happen only in DR ! Could it be that my DS admin user need to be in the oracle user group ? Currently it is not. However, the ODBC stage is retrieving data fine.
viewtopic.php?t=89313&highlight=ds_load ... oraoci9.so
viewtopic.php?t=93712&highlight=dsapi_s ... bclntsh.so:
Thanks again,
Yousuf.
Posted: Mon Apr 20, 2009 11:15 pm
by chulett
ODBC may or may not be relevant - if you are using the wired (thin) drivers, for example, it working means nothing. However, if you are using the thick (client-based) drivers for ODBC, that's another story.
Posted: Wed Apr 29, 2009 2:52 pm
by devilsmentor
chulett wrote:ODBC may or may not be relevant - if you are using the wired (thin) drivers, for example, it working means nothing. However, if you are using the thick (client-based) drivers for ODBC, that's another ...
Hmmm ... but coming to Oracle drivers we have two (oraoci9.so and oraoci9enu.so). When we register the plugin oraoci9enu.so is the only one that lets us do that ! i even had the stage exported from production to DR but still the issue persists. Eventually we had DS re-installed and fortunately now we are good to go. But it always wonders me what could have happened the first time
Posted: Wed Apr 29, 2009 4:34 pm
by chulett
So... is your problem resolved now? And it took a complete reinstallation of DataStage to resolve it?
