How to determine which Release version of Oracle is installed

book

Article ID: 159652

calendar_today

Updated On:

Products

Symantec Products

Issue/Introduction

How to check which release version of Oracle is running.

Resolution

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

%ORACLE_HOME%\admin\protect\bdump\alert_protect.log

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.2.0.2.0 - Production vsnsta=0
….
Starting up ORACLE RDBMS Version: 10.2.0.2.0.

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:

VERSION

-----------------

11.1.0.6.0

Or, you can execute the following SQL statement: 

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

It should return something like this:

Banner
--------------------------------------------------------------------------------------
Oracle Database 10g Release 10.2.0.2.0 - Production

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

SQL*Plus: Release 10.2.0.2.0 - 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 10.2.0.2.0 - Production

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

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.2.0 - Production