How to check if your Oracle Client is 32 bit or 64 bit. (39545)

How to check if your Oracle Client is 32 bit or 64 bit.

How can you check if your Oracle Client is 32 bit or 64 bit?

RESOLUTION 1:
If logged into Toad and connected to your database, go to Help | Support Bundle and review the section noted as "ORACLE CLIENT INFORMATION"

RESOLUTION 2:
If logged into SQL Plus, the banner will tell you 64-bit if the 64-bit version is installed. If it does not specify 64-bit then it is 32-bit (even though it does not explicitly say so).

RESOLUTION 3:
Bring up command line prompt. Cd into the client directory and type in/run TNSPING. This will display client information and should note 64bit or 32bit.

RESOLUTION 4:

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit. If there is only an ORACLE_HOME/lib directory then it is 32 bit client.

*Note: In newer versions of the client, the library is not included and this directory may not exist.

RESOLUTION 6:

1. Open Registry by selecting Start | Run and entering REGEDIT

2. Go to Hkey_local_machine HKLM/Software

3. Check for an Oracle node. Verify the ORACLE_HOME variable.
-- If found this indicates that the client specified here is 64bit. Note the path ofthe ORACLE_HOME variable and the name.

4. Further check to see if there's a WOW6432Node node. If so, doe sthat have an Oracle node within it. Verify if there is also an ORACLE_HOME variable also. |
-- If found, this indicates that the client specified here is 32bit.  Note the path ofthe ORACLE_HOME variable and the name.

When accessing the Oracle client, make sure you're accessing the correct client based of fthe Home name and the path.

*Note: Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 "Description of the Microsoft Windows registry": http://support.microsoft.com/default.aspx?kbid=256986

There are various ways to check the bit version of a client. Noted here are some suggestions based off of 9i, 10g, and 11g clients. This applies to various versions of Toad. The suggestions here are apply to the connection you make at that time. If you have multiple Oracle clients installed, what is connecting to Toad can vary. The Toad login window has the option to choose the Oracle client you wish to connect with. Please make sure to select the correct working client.