Page 1 of 1

DS 8.1 to 9.1 upgrade and Oracle 10g to 11g Exadata upgrade

Posted: Thu Jun 19, 2014 9:19 am
by DatastageCoEUser
We are in the process of upgrading DS 8.1 to 9.1 and Oracle 10g to 11g exadata. After the upgrades, in 9.1, will the Oracle stages which used to read/write from Oracle 10g remain compatible with exadata ?
Will there be a need to do any code change or will DS take care of it internally ?

Posted: Thu Jun 19, 2014 9:44 am
by chulett

Re: DS 8.1 to 9.1 upgrade and Oracle 10g to 11g Exadata upgr

Posted: Thu Jun 19, 2014 9:47 am
by Shamanth_vk
Based on my experience during DS version upgrade from 8.1 to 8.5. We had to make some minor changes. Its always advised to test all the scenarios to make sure its working as expected.

I am not sure about 8.1 to 9.1.

Posted: Thu Jun 19, 2014 9:57 am
by chulett
8.1 is old enough that you will probably run into changes that affect your jobs, typically where code was tightened up. You may also find things that no longer work as you expect which typically means you've been relying on a bug that has since been fixed. As noted, an extensive test will be required to shake these out.

Posted: Thu Jun 19, 2014 10:58 am
by PaulVL
With Oracle, you want to keep an eye on the order in which you have the Oracle lib directories in your path.

Oracle has an "osh" executable. So... make sure the PATH is set up correctly (your 8.1 is currently set up correctly since it was there too).