Oracle database version check.

There is several ways to check your Oracle database version.

1.Oracle Universal Installer shows you all installed products.
Unix run runInstaller or in Windows run setup.
In both OS this file can be find in $ORACLE_HOME/oui/bin .



2. But easier way is to just connect into database with sqlplus like this (as oracle user):
sqlplus system@test

#First you see the sqlplus version:
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 5 08:08:53 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

#Then you have to give password:
Enter password:

#And after that you see database server version of the database your connected:
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>



3. When you are connected into database via sqlplus you can also check v$version view. This view shows more detailed version information of current database server:
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production



NOTE! If you have several server installations or server and client installations on same server then you should use full paths with these commands. Otherwise you can get mixed information with these commands. In sqlplus example I used different version client and database server and that is why sqlplus version and database server versions are different.