How to determine which Release version of Oracle is installed


Article ID: 159652


Updated On:


Symantec Products


How to check which release version of Oracle is running.


An easy way to check which release version of Oracle you are running is to look at:


and check for the latest startup sequence.  The first digit after the "ORACLE V" is the version. You should see something like the following:

Thu May 03 16:47:56 2007
ORACLE V10. - Production vsnsta=0
Starting up ORACLE RDBMS Version:

Or else you can use the command line. 

How to check the Oracle version from the command prompt  

Version information is stored in a table called v$version. In this table you can find version information on Oracle, PL/SQL, etc.

To retrieve the version information for Oracle:

Run this script as sys as sysdba:

SQL> select version from v$instance;

You will see something like this:



Or, you can execute the following SQL statement: 

SELECT * from v$version 
WHERE banner like 'Oracle%';

It should return something like this:

Oracle Database 10g Release - Production

For example:
C:\Documents and Settings\Administrator>sqlplus \nolog

SQL*Plus: Release - Production on Fri May 4 15:32:56 20

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter user-name: protect
Enter password:

Connected to:
Oracle Database 10g Release - Production

SQL> select * from v$version
2 where banner like 'Oracle%';

Oracle Database 10g Release - Production