How to view the Oracle client version

2014-11-10 15:36 by Xiaoxiang Hermit, 34830 reads, 0 comments, Favorites, compilation

In practice, there are always issues that require you to view and verify the Oracle client version, because one server may have multiple versions of Oracle clients, or you might want to know whether the installed version is 32-bit or 64-bit. How do I view the Oracle client version? Here's how to view the Oracle client version under Windows, Linux.

Windows platform:

Method 1: View the installed Oracle client version

As shown below, using the Sqlplus-v command, you can find the client version of the 11.2.0.1.0 that the client installed.

C:\users>sqlplus-v

Sql*plus:release 11.2.0.1.0 Production

If I want to see if this client version is 32bit or 64bit, how to look at it as follows:

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>sqlplus/nolog

Sql*plus:release 11.2.0.1.0 Production on Mon Nov 10 11:32:23 2014

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

Windows Server 32bit Oracle Client

Method 2: View the installed Oracle client version

Locate the Comps.xml file under the%oracle_home%\inventory\contentsxml directory, for example, the path on my current test server is C:\Oracle_Client\Client64\product\11.2.0\ Client_1\inventory\contentsxml\comps.xml

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.

Oracle 64bit Client

Oracle 32bit Client

Method 3: View the installed Oracle client version

If the operating system is 32-bit, then the Oracle client must also be 32-bit, if the operating system is a 64-bit operating system, then the Oracle client may be 32-bit or 64-bit, we can see through the registry

For example, I installed a 32-bit Oracle 11g Client on Windows Server 2012. Run regedit into the registry system, under Hkey_local_machine\software\oracle\,

You will find that there is no registration information below, but you can see some detailed registry information under Hkey_local_machine\software\wow6432node\oracle, if the 64-bit Oracle client is installed, the registry information is located in HKEY_ Local_machine\software\oracle\, and there is no ORACLE directory under Hkey_local_machine\software\wow6432node.

Linux platforms:

[Email protected] bin]$ sqlplus-v

Sql*plus:release 10.2.0.4.0-production

1: Use the file command to view 32-bit or 64-bit clients.

Oracle Client + bit

[email protected] ~]$ which sqlplus

/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus

[Email protected] ~]$ File/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus

/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for G Nu/linux 2.2.5, dynamically linked (uses GKFX libs), not stripped

Oracle Client-bit

[email protected] ~]$ which sqlplus

/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus

[Email protected] ~]$ File/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus

/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GN U/linux 2.6.9, dynamically linked (uses GKFX libs), for Gnu/linux 2.6.9, not stripped

Or

Oracle Client + bit

[Email protected] logs]$ Cd/u01/app/oracle/product/10.2.0/db_1/bin

[[Email protected] bin]$ file Oracle

Oracle:setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for Gnu/linux 2.2.5, dynamically Linked (uses shared libs), not stripped

Oracle Client-bit

[Email protected] ~]$ Cd/u01/app/oracle/product/10.2.0/db_1/bin

[[Email protected] bin]$ file Oracle

Oracle:setuid setgid ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for Gnu/linux 2.6.9, dynamically L Inked (uses shared libs), for Gnu/linux 2.6.9, not stripped

2: By looking at the Lib or lib32 directory under $oracle_home, if two directories are stored, then 64 bits, if only the Lib directory. is a 32-bit client.

[Email protected] db_1]$ ls-d Lib

Lib

[Email protected] db_1]$ ls-d lib*

Lib Lib32

How to view the Oracle client version