How to know installed Oracle Client is 32 bit or 6

Question

OS: Windows 2008 Server R2

Oracle Client: 11.2

Many Thanks

Answer 1

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.

Answer 2

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