Oracle client version and number of bits (Windows System) View method _oracle

First, view Oracle client version:sqlplus-v

Second, see Oracle client version is 32bit or 64bit

Method One:

Step 1: Run the sqlplus/nolog command, if your server has more than one client version installed, then you should go to the bin directory of the corresponding installation directory, 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, locate the Sql*plus process, and if Oracle's client is 32-bit, the image name is labeled *32, as shown in the following illustration:

Windows Server 2008 Oracle 32bit Client

Windows Server 2008 Oracle 64bit Client

Method Two:

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

If plat= "Nt_amd64" indicates that a 64-bit Oracle client is installed, if plat= "Nt_x86" indicates that a 32-bit Oracle client is installed.

Method Three:

If the operating system is 32-bit, then the Oracle client must also be 32 bits, and if the operating system is a 64-bit operating system, then the Oracle client may be 32-or 64-bit, and we can view it 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 You can see some detailed registry information under \oracle, and if you have a 64-bit ORACLE client installed, the registry information is located under Hkey_local_machine\software\oracle\, and hkey_local_machine\ There is no Oracle directory under Software\wow6432node.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.