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 >
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 >
why not using sqlplus -v ?
ReplyDeletebut 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
Dear Laurent,
ReplyDeleteI didn't know about sqlplus -v. I will update the post accordingly.
Your 2nd point is worth remembering too.
Kind regards,
Andrew