DB migration from Oracle 9 to Oracle 11

[valentina2]

Hi all,
for security issue one fo our db targets will migrate from Oracle 9 to Oracle 11 . Now the connection is through OCI8 stages. I do not have Oracle 9 plug in installed. Does anybody knows if I have to change my OCI8 in OCI Load Stage? Any other suggestion?

Thanks

Valentina

[chulett]

Welcome. :D

What 7.x version? I'm guessing an early one if you have OCI8 stages. You'd need to upgrade to at least 7.5.1a to get a version of the OCI stage certified for Oracle 10g, 11 isn't officially supported but should work fine I would hope. Clients are 'forwards compatible' so older ones can connect to newer instances, however the reverse isn't really true from what I've seen.

Do you have an 11 instance you can try connecting to? First test would be to try connecting via what I assume your existing setup is - the OCI8 stage leveraging an 8i client on the DataStage server - and see how that goes.

Another suggestion would be to ask the same question of your official support provider, let us know what they say / suggest.

[valentina2]

Hi!!
Unfortunately I do not have an instance 11 to try to connect.
The DS version is 7.5.2. If I use the generic OCI load stage which kind of connection will be created? Does it depend from the oracle libraries?
Thx
Valentina

[chulett]

Yes, it will use whatever client libraries you have setup in your dsenv file, unless you override those Environment Variables in your job.

[valentina2]

If I use the OCI8 makes some difference between the OCI Load?

[chulett]

Not sure, you'd need to either ask Support or just try it when you can and let us know.

[valentina2]

I'll let you know. Corss your fingers!
Thanks so much
Bye
Valentina

[valentina2]

I'll let you know. Corss your fingers!
Thanks so much
Bye
Valentina