DSXchange

Hello,

We moved our current project to another etl box and now I am getting the following error (oci) when I try to run a job:

ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - The specified module could not be found.

I re-installed Oracle9i in the server but I still get the same error.

FYI: I am loging in to Datastage as Administrator and the oracle client is 32-bit (as we are on windows NT!). Can't think of any other problem

Can anybody help me out? Any suggestion?

TIA

When you installed the Oracle client, did you do it as Administrator and make it available to all users?

Yes kenneth. We did that. Thinking of installing windows again. And then, oracle? But before that want to check out some other solution.

I think that may be you need to add the ORA home directory in your ..DSEngine/dsenv file.

Check the difference between your servers.

Thanks. Oracle is installed in the same directory as it was earlier.

ml wrote:I think that may be you need to add the ORA home directory in your ..DSEngine/dsenv file.

Only valid advice for UNIX servers, I'm afraid. No such thing on Windows.

Can you tnsping or do anything as the specific DataStage user? It seems the error message is a permissions issue to access the Oracle installation directories for the client software.

chulett wrote:Only valid advice for UNIX servers, I'm afraid. No such thing on Windows.

ops sorry.. i'm living in the unix world... Windows should have the path for this Library (oraoci9.dll) defined in some place, right?... did you try reboot? this always help.

Thank you very much for all your suggestion. I know I have tried all my options. Thought of solving this issue today but need to catch my flight now. We will reboot the DS server next week when we are in and let you guys know.

Ken, yesterday, I was able to tnsping yesterday. I will let you know.

Thanks a bunch!