Tuesday, November 27, 2012

How to See the Version Number of an Oracle Client

If you want to find out the version number of an Oracle client from Windows, open a Command Prompt, type tnsping and press Enter / Return. No parameters are required. You will see the Oracle version number ( in this case) and whether it is 32-bit or 64-bit. As usual, click on the image to enlarge it and bring it into focus:

Another option, suggested by Laurent Schneider in the first comment at the end, is to use sqlplus -v:

Tru64 > sqlplus -v

SQL*Plus: Release - Production

Tru64 >

H:\>sqlplus -v

SQL*Plus: Release - Production


Solaris > sqlplus -v

SQL*Plus: Release Production 

Solaris >

Laurent Schneider wrote the book advertised below:

In Spanish / en espaƱol


Laurent Schneider said...

why not using sqlplus -v ?

but just to mention, the version of the tool is not necessarly the version of the database, for instance you could get


with a sqlplus, simply because the 2nd patchset for 8iR3 did not touch sqlplus. Some comment for the fifth digit

Andrew Reid said...

Dear Laurent,

I didn't know about sqlplus -v. I will update the post accordingly.
Your 2nd point is worth remembering too.

Kind regards,