In our last post, we talked about how SQL server determines which sessions/connections are long connections. Today, let's talk about how to check the oracle client version on Windows and Linux.
In practical work, there are often situations where you need to check or verify the Oracle client version, as a server may have multiple Oracle client versions installed. You may also need to know if the installed version is 32-bit or 64-bit. So, how can you check the Oracle Client version? Below are methods for checking the Oracle client version on Windows and Linux.
How to Check the Oracle Client Version on Windows?
By using the sqlplus -v command below, you can find the client version installed, such as version 11.2.0.1.0.
C:\Users>sqlplus -v SQL*Plus: Release 11.2.0.1.0 Production
How to Check the Oracle Client Version on Linux?
[oracle@ceglnx01 bin]$ sqlplus -v SQL*Plus: Release 10.2.0.4.0 - Production
On 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
On 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
