Using Toad for Oracle 9.7 on 64bit machine

 Problem Description : 

Toad 9.7 can only use the 32bit oracle client. Follow these steps on a 64bit machine to ensure Toad can connect to DB via Oracle instant client

 Resolution : 

Toad 9.7 can only use the 32bit oracle client. Follow these steps in a 64bit machine…

1. Under the machine’s environment variables add the instant client path in the PATH (preferably at the beginning) P:\Oracle\instantclient_11_2;

2. Also under environment variables add TNS_ADMIN = P:\Oracle\instantclient_11_2

3. Create the registry key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE]

4. In the above registry key, create a sub-key that starts with "KEY_" followed by the name of the installation you want:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Oracle\KEY_OraClient11g_home1_32bit]

5. Now create three string values below ​​inside the above key:

ORACLE_HOME="P:\Oracle\instantclient_11_2"

ORACLE_HOME_NAME="OraClient11g_home1_32bit"

NLS_LANG="AMERICAN_AMERICA.WE8MSWIN1252"

6. Install and open Toad and you should see the oracle home under installed clients 

 Revision Date : 11/6/2015