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

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
DatastageCoEUser
Premium Member
Premium Member
Posts: 36
Joined: Mon Mar 03, 2014 3:09 am

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

Post 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 ?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

-craig

"You can never have too many knives" -- Logan Nine Fingers
Shamanth_vk
Premium Member
Premium Member
Posts: 9
Joined: Sat Jul 14, 2007 10:47 am

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

Post 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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post 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).
Post Reply