Oracle migration 9 to 10.g

Flyerman_2 · Post by **Flyerman_2** » Fri Sep 04, 2009 6:13 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Sep 04, 2009 7:06 am

What is in the "upgrade" database ?

Data or metadata repository or any others?

Flyerman_2 · Post by **Flyerman_2** » Fri Sep 04, 2009 7:27 am

I m not sure to well understand your question.

Only the oracle version will change. datas, connexions will stay the same.

i don't understand why you are talking about data or metadata repository. For me they don't have to change.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Sep 04, 2009 7:29 am

In that case you will not have anything to change.

chulett · Post by **chulett** » Fri Sep 04, 2009 9:24 am

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.

Flyerman_2 · Post by **Flyerman_2** » Fri Sep 04, 2009 9:30 am

only some of them.

Thanks for your answer

ray.wurlod · Post by **ray.wurlod** » Fri Sep 04, 2009 2:47 pm

XMETA has a minimum version of Oracle 10g anyway, so that would be OK.