Page 1 of 1

changing Oracle client and impact on Datastage

Posted: Thu May 26, 2011 7:28 pm
by bicap
Hi,

Currently we are connectiong to Oracle 11g database via Datastsge 7.5.x version. Our oracle client version installed in 10g.

Now we want to replace oracle 10g client with 11g client. Do we need to change anything from Datastage side for this.

Posted: Thu May 26, 2011 8:05 pm
by PaulVL
As part of the DataStage install you get the connectivity guides (PDF). Review the Oracle guide to ensure any settings between those release levels are addressed.

You will have to examine your dsenv to ensure that you are sourcing the correct Oracle libraries for the new release.