Oracle module could not be found

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
LogicDude
Participant
Posts: 22
Joined: Tue Aug 30, 2005 5:08 pm
Location: CA

Oracle module could not be found

Post by LogicDude »

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
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post by kcbland »

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

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Top
LogicDude
Participant
Posts: 22
Joined: Tue Aug 30, 2005 5:08 pm
Location: CA

Post by LogicDude »

Yes kenneth. We did that. Thinking of installing windows again. And then, oracle? But before that want to check out some other solution. :?:
Top
ml
Participant
Posts: 82
Joined: Wed Jun 09, 2004 1:03 pm
Location: Argentina

Post by ml »

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

Check the difference between your servers.
Top
LogicDude
Participant
Posts: 22
Joined: Tue Aug 30, 2005 5:08 pm
Location: CA

Post by LogicDude »

Thanks. Oracle is installed in the same directory as it was earlier.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post by kcbland »

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.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Top
ml
Participant
Posts: 82
Joined: Wed Jun 09, 2004 1:03 pm
Location: Argentina

Post by ml »

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.
Top
LogicDude
Participant
Posts: 22
Joined: Tue Aug 30, 2005 5:08 pm
Location: CA

Post by LogicDude »

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!
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”