How to view the Oracle client version and the oracle client

How to view the Oracle client version and the oracle client

In practice, you will always encounter issues that require you to view and verify the ORACLE client version, because one server may have multiple Oracle client versions; you may also need to know whether the installed version is 32-bit or 64-bit. How can I view the version of the Oracle Client? The following describes how to view the Oracle client version in Windows and Linux.

Windows:

Method 1: view the installed Oracle Client Version

Use the sqlplus-v command to check the Client Version 11.2.0.1.0 installed on the client.

C: \ Users> sqlplus-v

SQL * Plus: Release 11.2.0.1.0 Production

If I want to check whether the client version is 32bit or 64bit, how can I check it as follows:

Step 1:Run the sqlplus/nolog command. If your server has installed Multiple Client versions, you should enter 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,201 0, Oracle. All rights reserved.

SQL>

Step 2:Open the task manager and find the SQL * Plus process. If the Oracle client is 32-bit, the Image Name is marked as * 32, as shown in:

Windows Server 2008 Oracle 32bit Client

Windows Server 2008 Oracle 64bit Client

Windows Server 2012 Oracle 32bit Client

Method 2: view the installed Oracle Client Version

Find comps under the % ORACLE_HOME % \ inventory \ ContentsXML directory. xml file. 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", the 64-bit Oracle client is installed. If PLAT = "NT_X86", 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, the Oracle client must be 32-bit. If the operating system is 64-bit, the Oracle client may be 32-bit or 64-bit, we can use the registry to view

For example, I installed a 32-bit Oracle 11g Client on Windows Server 2012. Run regedit to enter 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 a 64-bit Oracle client is installed, the registry information is located under HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \, but there is no ORACLE directory under HKEY_LOCAL_MACHINE \ SOFTWARE \ Wow6432Node.

Linux platform:

[Oracle @ ceglnx01 bin] $ sqlplus-v

SQL * Plus: Release 10.2.0.4.0-Production

1: run the file command to check whether the client is a 32-bit or 64-bit client.

Oracle Client 32 bit

[Oracle @ db-server-01 ~] $ Which sqlplus

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

[Oracle @ db-server-01 ~] $ 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 GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped

Oracle Client 64 bit

[Oracle @ db-server-02 ~] $ Which sqlplus

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

[Oracle @ db-server-02 ~] $ 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 GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped

Or

Oracle Client 32 bit

[Oracle @ db-server-01 logs] $ cd/u01/app/oracle/product/10.2.0/db_1/bin

[Oracle @ db-server-01 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 64 bit

[Oracle @ db-server-02 ~] $ Cd/u01/app/oracle/product/10.2.0/db_1/bin

[Oracle @ db-server-02 bin] $ file oracle

Oracle: setuid setgid ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped

2: Check the lib or lib32 directory under $ ORACLE_HOME. If both directories are saved as 64-bit, if only the lib directory is available, the 32-bit client is used.

[Oracle @ db-server-01 db_1] $ ls-d lib

Lib

[Oracle @ db-server-01 db_1] $ ls-d lib *

Lib lib32