I would to know what we have to change in Datastage after migrating on a server the Oracle version from 9 to 10.g .
We use ORAOCI 9 stage.
Do we have to modify ODBC connection on Datastage server ?
Same question if we have to change AIX version.
Thank you by advance for your answers
Oracle migration 9 to 10.g
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 11
- Joined: Mon Aug 17, 2009 9:42 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
The question about the 'metadata repository' was asked in case you were asking about upgrading the internal XMETA metadata repository from 9i to 10g but seeing how that's not possible (only 10g is supported) it just confused things.
So, out of curiosity are all external Oracle databases you currently connect to via OCI in your jobs changing to 10g or only some of them? Meaning will you be connecting to a mixture of versions or just 10g? Worst case you may need to upgrade the client installed on the DataStage server from 9i to 10g as well, but more than likely you won't have to do anything.
So, out of curiosity are all external Oracle databases you currently connect to via OCI in your jobs changing to 10g or only some of them? Meaning will you be connecting to a mixture of versions or just 10g? Worst case you may need to upgrade the client installed on the DataStage server from 9i to 10g as well, but more than likely you won't have to do anything.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 11
- Joined: Mon Aug 17, 2009 9:42 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: