How to Tell if Oracle Client is 32 or 64 bit installed on Windows

It is easy to tell 32 bit or 64 bit oracle on Unix/Linux by :

$ file sqlplus
sqlplus: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), not stripped

In Windows, there are a couple of ways to check Oracle client is 32 bit or 64 bit by :

TNSPING

—  32bit Oracle client installed

D:\>tnsping
TNS Ping Utility for 32-bit Windows: Version 12.1.0.2.0 - Production on 29-NOV-2016 09:24:50

— 64 bit Oracle client installed

c:\>tnsping
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 29-NOV-2016 09:27:19
Copyright (c) 1997, 2014, Oracle. All rights reserved.

TASK MANAGER

Run command “sqlplus” in command prompt window, then open “task manager”.

—  32bit Oracle client installed

oracleclient32bit

— 64 bit Oracle client installed

oracleclient64bit

 

%ORACLE_HOME%\inventory\ContentsXML\oraclehomeproperties.xml file

—  32bit Oracle client installed

...
..
  
 <ARU_ID>912</ARU_ID>
 <ARU_ID_DESCRIPTION>Microsoft Windows (32-bit)
..
.
 <PROPERTY NAME="ARCHITECTURE" VAL="32"/>
..
.

— 64 bit Oracle client installed

...
..
 <ARU_ID>233</ARU_ID>
 <ARU_ID_DESCRIPTION>Microsoft Windows (64-bit AMD)
..
.
 <PROPERTY NAME="ARCHITECTURE" VAL="64"/>
..
.

PERL under %ORACLE_HOME%

Perl  installed according to the bit version of the ORACLE_HOME but not the OS bit version

cd %ORACLE_HOME%\perl\bin
perl -version

This is perl 5, version 14, subversion 4 (v5.14.4) built for MSWin32-x86-multi-thread ( 32-bit ORACLE_HOME )

This is perl 5, version 14, subversion 4 (v5.14.4) built for MSWin32-x64-multi-thread ( 64-bit ORACLE_HOME )

JAVA under %ORACLE_HOME%

32-bit Java will be installed with 32-bit Oracle software & 64 bit with 64-bit Oracle software

—  32bit Oracle client installed.  32-bit doesn’t shows the bit version.

cd %ORACLE_HOME%\jdk\bin
java -version

java version "1.6.0_75"
Java(TM) SE Runtime Environment (build 1.6.0_75-b13)
Java HotSpot(TM) Client VM (build 20.75-b01, mixed mode)

—  64bit Oracle client installed

cd %ORACLE_HOME%\jdk\bin
java -version

java version "1.6.0_75"
Java(TM) SE Runtime Environment (build 1.6.0_75-b13)
Java HotSpot(TM) 64-Bit Server VM (build 20.75-b01, mixed mode)
Advertisements
This entry was posted in Client, ORMB and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s