DataStage 7.5 compatible with Oracle 11g R2 using ORAOCI9

avskumar · Post by **avskumar** » Wed Feb 23, 2011 11:12 pm

We have jobs developed in DataStage7.5 using ORAOCI9 to connect to Oracle 9i database. Now, we are upgrading Oracle from 9i to 11g R2.

I would like to know whether DataStage7.5 and ORAOCI9 are compatible with Oracle 11g R2 or is there any work arounds?

Thanks

chulett · Post by **chulett** » Thu Feb 24, 2011 12:57 am

I would think it should work but you'll need to try it to see what issues, if any, you face. Stick with using your 9i Oracle client with the OCI9 stage to connect to the 11g instance.