Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to determine which version of Oracle Client is being used from the server

Using Oracle 10g. ( 10.2.0.4 )

Possibly by looking at either logs or system tables is there a way to determine which version of the oracle client each connection is using.

Our systems initially had 8.1.7 Clients, and then 9.X clients.

We attempted to manually locate all machines that had older clients and upgrade them to to 10.2 Clients.

We are seeking a method to audit (from the server) if we were successful in upgrading all of our client machines.

like image 954
Robert Love Avatar asked Dec 22 '10 18:12

Robert Love


People also ask

How do I find my Oracle client version?

Hi, In the sql plus prompt type. SQL> select * from v$version; You will get your oracle client verison.


1 Answers

A quick Google search revealed the following:

  • Oracle Forums thread
  • Stackoverflow thread
  • OraFAQ thread
  • Blog post
like image 75
Eddie Awad Avatar answered Sep 17 '22 13:09

Eddie Awad