DataStage with Oracle client 10 G - Plugin

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

Post by kcbland »

Welcome aboard. Next time, please post in the Server forum.

Put the ORACLE_HOME value in your dsenv file and make sure you're pointing to the 32bit Oracle 9i client libraries and use the OCI stage, not the OCI8.

OCI is the Oracle 9i plugin, there's no 10g plugin.

Be sure to stop/start the engine to make the environment change effective on the engine.
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
sobral
Participant
Posts: 13
Joined: Mon Nov 07, 2005 10:15 am

solved

Post by sobral »

hi kcbland

I think that you solved the problem.
I change my enviroments to $ORACLE_HOME/lib32
The directory $ORACLE_HOME/lib32 is for 32 bits plataform.
The directory $ORACLE_HOME/lib is for 64 bits plataform.

Thanks a lot
arunverma
Participant
Posts: 90
Joined: Tue Apr 20, 2004 8:20 am
Location: MUMBAI
Contact:

Re: solved

Post by arunverma »

Hi ,

I am having the same problem DS 7.1 on Unix with 10G client , I am not able to connect , pl help


Regards

Arun .
Arun Verma
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Please re-read my above post and if that doesn't work post another response.
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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

And if that doesn't work try reverting to the 9i client.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply