Page 1 of 1
10g problem
Posted: Wed Jul 14, 2004 11:10 am
by babbu9
Hi
I am trying to use Oracle 1og database with datastage 7. I am having difficulties in retrieving date using odbc or native oracle drivers. Any suggestions? (I only have 8i,9i,OCI drivers installed)
Posted: Wed Jul 14, 2004 1:10 pm
by ketfos
Hi,
Can you specify what errors/messages you encounter while trying to retreive the data?
Ketfos
Posted: Wed Jul 14, 2004 1:46 pm
by babbu9
ketfos wrote:Hi,
Can you specify what errors/messages you encounter while trying to retreive the data?
Ketfos
The error says that Oracle client and networking components have not been found and need to be installed. These components are present in7.3 version and later.
Posted: Wed Jul 14, 2004 3:48 pm
by ketfos
Hi,
Is Oracle 10g supported in DataStage 7.1?
This may be a reason for the error message.
Ketfos
Posted: Wed Jul 14, 2004 4:03 pm
by chulett
I doubt it.
Don't remember that even being mentioned as part of 7.5.
Have you tried pointing DataStage's $ORACLE_HOME environment variable to a 9i client and then using the 9i client via an OCI9 stage to access the 10g database? Does that work?
It's an old trick I've used before when 9i was brand new. We used an 8i client and an OCI8 stage to talk to our 9i databases for awhile.
Posted: Wed Jul 14, 2004 4:18 pm
by ketfos
In "What's New for DataStage 7[1].5 PDF Document under
Database Management Update It mentions of support of Oracel 10g
But the other trick you have mentioned has worked for me alsofor Oracle 9i.
Ketfos
Posted: Wed Jul 14, 2004 4:31 pm
by chulett
So it does! Does that mean we get an
OCI10 stage?
Guess not... to quote: "The Oracle OCI 9i server-side plug-in has been renamed to 'Oracle OCI' as it nows support Oracle 10g."
Info needed
Posted: Thu Jul 15, 2004 2:31 pm
by babbu9
chulett wrote:I doubt it.
Don't remember that even being mentioned as part of 7.5.
Have you tried pointing DataStage's $ORACLE_HOME environment variable to a 9i client and then using the 9i client via an OCI9 stage to access the 10g database? Does that work?
It's an old trick I've used before when 9i was brand new. We used an 8i client and an OCI8 stage to talk to our 9i databases for awhile.
Can you please inform in detail about how to do that.