How to know installed Oracle Client is 32 bit or 64 bit?

oracle 64-bit oracleclient

260,606

Solution 1

A simple way to find this out in Windows is to run SQLPlus from your Oracle homes's bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you'll see a process on the Processes tab that looks like this:

sqlplus.exe *32

If it is 64-bit, the process will look like this:

sqlplus.exe

Solution 2

Go to %ORACLE_HOME%\inventory\ContentsXML folder and open comps.xml file

Look for <DEP_LIST> on ~second screen.
If following lines have

PLAT="NT_AMD64" then this Oracle Home is 64 bit.

PLAT="NT_X86" then - 32 bit.

You may have both 32-bit and 64-bit Oracle Homes installed.

Solution 3

One thing that was super easy and worked well for me was doing a TNSPing from a cmd prompt:

TNS Ping Utility for 32-bit Windows: Version 11.2.0.3.0 - Production on 13-MAR-2015 16:35:32

Solution 4

In Linux:

1) find where is sqlplus located,

[oracle@LINUX db_1]$ `which sqlplus`
/app/oracle/product/11.2.0/db_1/bin/sqlplus

2) Determine the file type,

[oracle@LINUX db_1]$ file /app/oracle/product/11.2.0/db_1/bin/sqlplus

/app/oracle/product/11.2.0/db_1/bin/sqlplus: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs). For GNU/Linux 2.6.18, not stripped.

Solution 5

None of the links above about lib and lib32 folder worked for me with Oracle Client 11.2.0 But I found this on the OTN community:

As far as inspecting a client install to try to tell if it's 32 bit or 64 bit, you can check the registry, a 32 bit home will be located in HKLM>Software>WOW6432Node>Oracle, whereas a 64 bit home will be in HKLM>Software>Oracle.

View more solutions

260,606

Author by

aiyagaze

Updated on September 03, 2020

Comments

aiyagaze almost 4 years

OS: Windows 2008 Server R2

Oracle Client: 11.2

Many Thanks
n00b over 9 years

does the same hold true for windows server 2012? I see it running in task manager as sqlplus.exe, and description is "Oracle SQL*PLUS".
shonky linux user over 9 years

This method only works with Task Manager. If you use Process Explorer it shows sqlplus.exe for a 32 bit client, however you can display the Image Type column, and this will indicate 64 or 32 bits.
stephen about 9 years

Useful if you have more than 1 Oracle client!
geynske006 about 9 years

This helped me to look for the list. I've now got another question on this: How do I determine which is a client/something else? "oracle.sysman.agent" VER="11.1.0.1.0" PLAT="NT_AMD64" "oracle.sysman.agent.gc" VER="11.1.0.1.0" PLAT="NT_AMD64" "oracle.rdbms.install.common" VER="10.2.0.1.0" PLAT="NT_AMD64" "oracle.swd.oui" VER="10.2.0.1.0" PLAT="NT_AMD64" /> "oracle.bali.share" VER="11.1.1.2.0" PLAT="NT_AMD64" "oracle.sysman.plugin.ai.main.agent" VER="11.1.0.2.0" PLAT="NT_AMD64" "oracle.dms" VER="10.1.2.1.0" PLAT="NT_AMD64" NOTE: I'm green on this matter.
Tagar about 9 years

Good advice. Although task manager wouldn't show "sqlplus.exe *32" on a 32-bit OS, it would be just "sqlplus.exe" ;)
Veverke almost 9 years

Mark, I think the "32-bit" you relates to Windows, not Oracle's client
Mark Bowytz almost 9 years

Nope. I have Windows 8 on my PC and have both 32-bit and 64-bit clients installed due to job requirements.
Ivan Chau over 7 years

@n00b For server 2012, "(32 bit)" would be shown after the application name. In your case, it is 64bit.
armyofda12mnkeys over 5 years

I couldnt see this '*32' part in WIndows 10 Task Manager. I went into Task Manager area and right-clicked on the table area there. and selected 'Select Columns' and choose 'Platform' and that seemed to display whether it is a 64 or 32 bit prog
Isaac over 4 years

@MarkBowytz, but how do you know if you have both 32-bit and 64-bit?
Donald Li over 2 years

@geynske006 not sure if I am in time for this - but since they are all AMD64, you should be fine, just means you have 32-bit across the board.