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:

  1. 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

    ReplyDelete
  2. 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

    ReplyDelete