I have a Windows 7 64-bit OS and need to install an Oracle client on this machine. Instead of installing a 64-bit client, I would like to install a 32-bit client and was wondering if this is possible and compatible on a 64-bit machine? The reason I would prefer to install a 32-bit client is because i have a 32-bit version of TOAD and apparently this doesnt work with a 64-bit client.
I have downloaded the following files:
Oracle Database 10g Client Release 2 (10.2.0.3) -> 10203_vista_w2k8_x86_production_client.zip
patchset 10.2.0.5 (for Windows 7 compatibility) -> p8202632_10205_WINNT.zip
Are these the correct files I have downloaded? Thanks.
Yes, if you have access to the database server tnsnames.ora file,
Then copy it to the client machine at $ORACLE_HOME/network/admin/ folder. Now make sure you remove all exiting entries from this tnsnames.ora file but keep one. Update this entry pointing, to correct host & sid and now save it.
Go to the command prompt and verify:
c:> tnsping <connection string name>
if it returns no errors means you are ready to go..
Hmmm, i see that my previous message was posted 3 times, eventhough i kept getting a message that the site is experiencing some problems....
Anyway, the database sid and machine name is the info that i dont have at the moment. I dont have any databases installed locally. I'll try to get the info soon so that I can test it.