Different Methods to find or Check whether the installed Oracle Client Software is 32 bit or 64 bit in Windows Environments

Some times we may need to check whether the oracle client software which is installed in Windows Environments is 32 bit or 64 bit, and this sometimes comes mostly because of the application team who bugs us and say that we need 64 bit client sofware or 32 bit.

Eventhough they have same version of client software, still they will say i want it. This is app team's default behaviour. ( Just Joking ).

If you wanna check in Unix / Linux Environments, please use below link.

http://stepintooracledba.blogspot.com/2013/08/different-methods-to-find-or-check.html

Below are the two methods which i use mostly to find out the bit size.

**************************************************************** Methods ******************************************************************************

#########################################
# 1) Using Task Manager
#########################################

In Command Prompt, Change directory (cd) to Oracle Client Home bin directory ( $ORACLE_HOME/bin ) and invoke Sqlplus

After invoking, go to Task Manager & check the process running.

From the below screenshot, if you can see, we have two Sqlplus Prompts, And from Image its clear that

32 bit version shows as "Oracle SQL*PLUS(32 bit)" and

64 bit version shows as "Oracle SQL*PLUS"

Note : Below Task Manager output is from Windows Server 2012

=====================================================================================================================

#########################################
# 2) Using Registry ( regedit )
#########################################

Go to run and type regedit.

In registry Editor navigate as below,

HKEY_LOCAL_MACHINE --> SOFTWARE --> ORACLE --> KEY_OraHome1 ( If oracle Client Software folder exists in this place then its of 64 bit version )

HKEY_LOCAL_MACHINE --> SOFTWARE --> Wow6432Node --> ORACLE --> KEY_OraHome1 ( If oracle Client Software folder exists in this place then its of 32 bit version )

=====================================================================================================================

Different Methods to find or Check whether the installed Oracle Client Software is 32 bit or 64 bit in Linux / Unix Environments

########################
 Task
########################

To find whether the installed Client Software is 32 bit or 64 bit in Linux / Unix Environments

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

=====================================================================================================================
Method 1 :
--------
Using ORACLE_HOME properties File
=====================================================================================================================


$ cat $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml | grep -i architecture

     

From above output, we can find its 64 bit, 32 means then the client software is 32 bit.

=====================================================================================================================
Method 2 :
--------
Using File OS command
=====================================================================================================================

$ file $ORACLE_HOME/bin/sqlplus

/u01/app/oracle/product/11.2.0/client_1/bin/sqlplus: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped

From above output, we can find x86-64, so this is 64 bit version.

=====================================================================================================================
Method 3 :
--------
From lib directories created during installation.
=====================================================================================================================

$ ls -l $ORACLE_HOME | grep lib

drwxr-xr-x  2 oracle oinstall 4096 Jun 26 14:26 jlib
drwxr-xr-x  3 oracle oinstall 4096 Jun 26 14:26 lib

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib exist, then it is 64 bit client.

If you have only $ORACLE_HOME/lib you need to use method 1 as there are client versions (11.2) where $ORACLE_HOME/lib32 directory does not exist on 64-bit client installations.

=====================================================================================================================
Method 4 :
--------
Using Perl Version
=====================================================================================================================

$ perl -v

This is perl, v5.8.8 built for x86_64-linux-thread-multi

Note: Perl is installed according to the bit version of the ORACLE_HOME but not the OS bit version.

=====================================================================================================================