How do I know the installed Oracle client is 32-bit or 64-bit?

Question

OS: Windows Server 2008 R2 R2

Oracle Client: 11.2

Thank you very much

Answer 1

An easy way to find this on Windows is to start SQLPlus from your bin directory in Oracle and then check the task manager. If it is a 32-bit version of SQLPlus, you will see the process on the Processes tab, which looks like this:

sqlplus.exe *32 

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

 sqlplus.exe 

Answer 2

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

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

PLAT="NT_AMD64" , then this Oracle Home will be 64 bits.
PLAT="NT_X86" then 32 bits.

You can have both 32-bit and 64-bit Oracle databases installed.

Answer 3

One thing that was super lightweight and worked well for me was doing TNSPing from the command line:

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

Answer 4

On Linux:

1) find where sqlplus is located,

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

2) Determine the type of file,

[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 libraries). For GNU / Linux 2.6.18 is not shared.

Answer 5

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

As for checking the client installation, to try to determine if it is 32-bit or 64-bit, you can check the registry, the 32-bit house will be located in HKLM> Software> WOW6432Node> Oracle, while the 64-bit house will be in HKLM > Software> Oracle.

Answer 6

The following, taken from here , was not mentioned here:

If the Oracle Client is 32 bits, it will contain the "lib" folder; but if it is a 64-bit Oracle client, it will have the "lib" and "lib32" folders.

In addition, starting with Oracle 11.2.0.1, the client version for 64-bit and the Oracle client for 32-bit are shipped separately, and there is also a $ ORACLE_HOME / lib64 directory.

$ ORACLE_HOME / lib / ==> 32 bits $ ORACLE_HOME / lib64 ==> 64 bits

or

$ ORACLE_HOME / lib / ==> 64 bits $ ORACLE_HOME / lib32 ==> 32 bits

Answer 7

For a Windows Oracle 12.1 client, viewing the TNSPING command works:

With a 32-bit version on a 64-bit OS:

C:> tnsping

TNS Ping Utility for 32-bit Windows: Version 12.1.0.2.0 - Production on 02-FEB-2 016 15:44:37

Copyright (c) 1997, 2014, Oracle. All rights reserved.

With a 64-bit version on a 64-bit OS:

D:> tnsping

TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production on 02-FEB-2 016 16:00:23

Copyright (c) 1997, 2013, Oracle. All rights reserved.

Answer 8

On a 64-bit system:

32-bit driver: C:\Windows\SysWOW64\odbcad32.exe

64-bit driver: C:\Windows\System32\odbcad32.exe

Go to the Drivers tab
A version is also shown there.