How to use Oracle 10G through datastage 7.1?

skumar · Post by **skumar** » Thu Apr 12, 2007 11:25 pm

Hi all,

I just wanted to know the information,Are there anyways that are possible to connect oracle 10G through Datastage 7.1 version???If that can be possible please let me know how to acheive that...........

Thanks in advance.

Regards,
skumar.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 13, 2007 1:55 am

Only via a scripted approach, unless you have an OCI stage that is documented as working with Oracle 9i - this will connect successfully to Oracle 10g.

Otherwise upgrade to version 7.5.

skumar · Post by **skumar** » Fri Apr 13, 2007 2:47 am

Ray,

Thanks for your reply and can you please tell me what type of scripting is required and where to call it??Can you explain a bit more on the same if you don't mind..........

Thanks,
Srinivas.

chulett · Post by **chulett** » Fri Apr 13, 2007 5:57 am

I wouldn't worry about a 'scripted' approach right now. You can connect to an Oracle 9i instances via an OCI9 stage right now, yes? Since that's the case, all you need to do is continue to use the 9i client and simply point it to a 10g instance. Will work fine.

In other words, you shouldn't have to do anything special for this, other than ensure that the tnsnames entry for the 10g instance gets into the tnsnames.ora file under your 9i client.