Wednesday, July 31, 2013

How to check if your installed oracle client is 32bit or 64bit

The easy way to check the installed oracle client version in windows operating system:

The first way to check  is checking from sqlplus binary.

1. Run sqlplus in command line, and leave it prompting for user name as shown below

2. Check oracle version from windows task manager:

If the process shows "sqlplus.exe*32" as in the picture then it's the 32bit version client. If it shows "sqlplus.exe" then it's the 62bit version client.

The second way is checking from installation log:

The path of the installation lies on [ORACLE BASE]\product\11.2.0\client_1\cfgtoollogs\oui\, and the file name starts with installActions with log as an extension; for example installActions2013-07-11_03-08-26PM.log.
Here is what you have to do to check the installed oracle version:

1. Open the oracle client installation log.

2. Search for the keyword oracle_install_architecture. If you see the number as 32 then it is 32bit version client and if it is 64 then it is 64bit client. The example below shows that the installed oracle is oracle client 32bit version..