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 10.2.0.3.0 - 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 10.2.0.3.0 - 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 10.2.0.1.0
Oracle interim Patch Installer version 10.2.0.1.0
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    : 10.2.0.1.0
OUI version       : 10.2.0.1.0
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                                                  10.2.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.

Oracle Database

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 © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com 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
www.erpgreat.com or the content authors.