Tuesday, December 10, 2013

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 )


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

No comments: