Oracle Server 64 bit or 32 bit for DS 7.1

vnspn · Post by **vnspn** » Sat Mar 24, 2007 6:40 am

Hi,

We are currently working on the 7.1 version and planning to use Oracle OCI 9i stage for the database connectivity.

We would like to know would DS Oracle stage be able to connect to a Oracle 10g database server which is a 64 bit (OR) should we only have the 32 bit version of Oracle 10g database...

Thanks.

chulett · Post by **chulett** » Sat Mar 24, 2007 7:02 am

You should check with your DBA or IBM Support to be sure. Or just try, not like you'd hurt anything.

We all know that a 32 bit implentation of DataStage requires a 32 bit client but I don't know if you can use that to connect to a 64 bit instance. I've used a full 64bit environment with no issues, so it's not like it can't "do" 64 but I don't know if a mixture of bitness can be used. Never had a need to find out. Anyone know?

ray.wurlod · Post by **ray.wurlod** » Sat Mar 24, 2007 7:13 am

The 32-bit Oracle client CAN "talk" to 64-bit Oracle.

chulett · Post by **chulett** » Sat Mar 24, 2007 8:05 am

Well, there you go. Golden. :D