Find Out What The Oracle Database Version

1) How to check oracle client version for server?

There are a couple way you can find out what the oracle database version that you are running is:

a) select * from v$version.

b) start a sqlplus session and you will see the version there, see below:

C:\Documents and Settings\oracleservice>sqlplus / as sysdba
SQL*Plus: Release - Production on Thu Apr 10 12:28:25 2014
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP and Real Application Testing options
C:\Documents and Settings\oracleservice>sqlplus / as sysdba

2) Getting Oracle version without logging into the database(s)

Is there any way to find the version of the databases (which is running) without logging into the database, meaning by using operating system commands only.
Under Unix, get ORACLE_HOME from /etc/oratab and then run:
$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch
Oracle interim Patch Installer version
Copyright (c) 2005, Oracle Corporation.  All rights reserved..
Oracle Home       : /oracle/product/10.2.0/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/10.2.0/db_1/oraInst.loc
OPatch version    :
OUI version       :
OUI location      : /oracle/product/10.2.0/db_1/oui
Log file location : /oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch-2014_May_22_12-02-14-CEST_Fri.log
Lsinventory Output file location : /oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory-2014_May_22_12-02-14-CEST_Fri.txt
Installed Top-level Products (1):
Oracle Database 10g                                        
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
OPatch succeeded.

See Also

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of or the content authors.