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.
