6

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.

Robert Love
  • 12,447
  • 2
  • 48
  • 80

1 Answers1

1

A quick Google search revealed the following:

Community
  • 1
  • 1
Eddie Awad
  • 3,669
  • 1
  • 19
  • 17
  • The first 3 are for client side only not server side. The last one is client side but builds a reporting mechanism to report it to a server. – Robert Love Dec 22 '10 at 22:17
  • 1
    I also asked this question to "Ask Tom" and he replied there was no way he knew of doing this. I am going to accept this answer because of the "Blog Post" link as it attempts to report this to the server. And it has given me the idea to build this functionality into our application. – Robert Love Jan 06 '11 at 16:53