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 (10.2.0.4.0 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 9.2.0.7.0 - Production

Tru64 >

H:\>sqlplus -v

SQL*Plus: Release 10.2.0.4.0 - Production

H:\> 

Solaris > sqlplus -v

SQL*Plus: Release 11.2.0.2.0 Production 

Solaris >

Laurent Schneider wrote the book advertised below:



In Spanish / en espaƱol

2 comments:

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

sqlplus 8.1.7.0.0

with a sqlplus 8.1.7.2, 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,

Andrew