How to view the Oracle client version and number of bits (Windows system)

First, view the Oracle client version: SQLPLUS-V

Second, check whether the Oracle client version is 32bit or 64bit: Method one:

Step 1: Run the Sqlplus/nolog command, if your server has multiple client versions installed, then you should go to the bin directory of the corresponding installation directory and run the command

C:\users\mr.bruce>sqlplus/nolog

Sql*plus:release 11.2.0.1.0 Production on Monday August 8 16:06:05 2016

Copyright (c) 1982, Oracle. All rights reserved.

Sql>

Step 2: Open Task Manager and locate the Sql*plus process, if the client for Oracle is 32-bit, then the image name is marked as *32, as shown in:

Windows Server 32bit Oracle Client

Windows Server 64bit Oracle Client

Method Two:

Locate the Comps.xml file under the%oracle_home%\inventory\contentsxml directory, for example, the path on my current test server is F:\Win10\app\Mr.Bruce\product\11.2.0\ Client_1\inventory\contentsxml

If plat= "nt_amd64" means that the 64-bit Oracle client is installed, the plat= "nt_x86" means that the 32-bit Oracle client is installed.

Method Three:

if the operating system is 32-bit, then the Oracle client must also be 32 bits, if the operating system is a 64-bit operating system, then the Oracle client may be 32-bit or 64-bit, which we can view through the registry. For example, I installed a 64-bit Oracle 11g Client on Windows 10. Run regedit into the registry system, under Hkey_local_machine\software\oracle\, you will find no registration information below, but hkey_local_machine\software\ Wow6432node\oracle can see some detailed registry information, if the 64-bit ORACLE client is installed, the registry information is located under Hkey_local_machine\software\oracle\, and hkey_local There is no Oracle directory under _machine\software\wow6432node.

Note: Refer to from http://www.cnblogs.com/kerrycode/p/4087292.html

How to view the Oracle client version and number of bits (Windows system) (RPM)