If you see the '64bit' string in V$VERSION it means Oracle 64-bit is running. When accessing the Oracle client, make sure you're accessing the correct client based off the HOME name and the PATH. If found, this indicates that the client specified here is 32-bit.? Note the path of the ORACLE_HOME variable and the name. If so, does that have an Oracle node within it? Verify if there is also an ORACLE_HOME variable also. Further, check to see if there's a WOW6432Node node. Note the path of the ORACLE_HOME variable and the name.ĭ. If found this indicates that the client specified here is 64bit. Open the Registry by selecting Start | Run and entering REGEDITĬ. *Note: In newer versions of the client, the library is not included and this directory may not exist.Ī. If there is only an ORACLE_HOME/lib directory then it is a 32-bit client. If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64-bit. This will display client information and should note 64-bit or 32-bit. The bit level shown is the bit level of the Oracle client. If you run this utility without any command line options it will tell you what version is installed. In the bin folder, there should be an executable called tnsping.exe In the Oracle client directory, there should be a bin folder. Rt-Click on Computer -> Properties -> Advanced system settings ->Advanced Tab -> Environment Variables -> then check Path Option in the System variables to see Oracle client HOME dir.Ĭd into the Oracle client directory. If nothing is found on your the machine, then the client is not installed. Open a Windows command (cmd) prompt and run: If it does not specify 64-bit, then it is 32-bit (even though it does not explicitly say so). If you're logged into SQL Plus, the banner will tell you 64-bit if the 64-bit version is installed. How to check if your Oracle CLIENT software is 32-bit or 64-bit

Toad 32 bit download