Check Oracle Version

There are several ways where you can query or retrieve the version number of installed Oracle products:

1. If you just want to check the version information of the Oracle database, simply connect and login to the Oracle database with SQL *Plus. Upon login, you will see:

SQL*Plus: Release 9.2.0.6.0 – Production on Tue Oct 18 17:58:57 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 – 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 – Production

The first italic number is the version of the SQL*Plus client and the second italic number is the version of Oracle database which you are connected to .

2. Retrieve the version information from v$version table by using SQL*Plus. In this table you can find version information on Oracle, PL/SQL, etc.

To retrieve the version information for Oracle, you execute the following SQL statement:

select * from v$version where banner like ‘Oracle%’;

It should return something like this:

Banner
————————————————————————————–
Oracle9i Enterprise Edition Release 9.2.0.1.0 – 64bit Production

3. Version information can also be checked from Installed Products from the Oracle Universal Installer. It will tells you what products is installed on the machine and also its version information too.

In Unix, the installer is located at $ORACLE_HOME/bin/runInstaller.
In Windows, access the installer by Start -> All Programs -> Oracle Installed Products -> Universal Installer.


This entry was posted on Tuesday, October 18th, 2005 at 6:06 pm and is filed under Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

6 Responses to “Check Oracle Version”

  1. Ivan Versluis
    October 22nd, 2009 16:48
    6

    Thanks. It worked for me.

    Still running Windows Server 2003 with Oracle 9.22 enterprise server.

  2. Jon Schneider
    September 12th, 2008 04:39
    5

    Apparently this server is automatically replacing straight singlequotes with curly ones, even in my comment! Still, the suggestion from my previous post above still applies; just do the replace on your own local machine, instead of in a comment here. :-)

  3. Jon Schneider
    September 12th, 2008 04:35
    4

    If anyone gets an “invalid character” error after copy & pasting in the query from the article:

    select * from v$version where banner like ‘Oracle%’;”

    Try replacing the “curly” singlequote characters around “Oracle%” with regular straight singlequotes:

    select * from v$version where banner like ‘Oracle%’;

  4. A
    August 13th, 2008 19:03
    3

    The above query will not work in oracle
    use the below query
    Select * from v$version;

  5. Karthikeyan
    August 13th, 2008 06:16
    2

    select * from versions;

    The above SQL will do.

  6. Pankaj
    March 3rd, 2008 22:29
    1

    It was a very helpful to find the oracle version information through sqlplus.

    Thanks,
    pankaj

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe to comments feature has been disabled. To receive notification of latest comments posted, subscribe to My Digital Life Comments RSS feed or register to receive new comments in daily email digest.
« Install AWStats- Free Logfile Analyzer for Site Statistics
Install phpBB 2 in Windows XP running on Apache 2, PHP 5 and MySQL 4 »

Custom Search

New Articles

Incoming Search Terms for the Article

oracle version query - check oracle version - how to check oracle version - oracle database version - oracle version - version oracle - how to check oracle database version - oracle check version - get oracle version sql - query oracle version - oracle db version - get oracle version - oracle version check - oracle get database version - oracle db version query - oracle get version - how to get oracle version - oracle query version - oracle database version query - how to know oracle version - how to check oracle db version - how to check the version of oracle - version of oracle - check oracle db version - oracle versions - check oracle database version - oracle client version check - determine oracle version - get oracle database version - how to get the oracle version - sql to get oracle version - query database version - how to see version of oracle - how to know version of oracle - Checking Oracle version - check version oracle - database version oracle - find oracle version - how to get version of oracle - how to find oracle version using sql - oracle query database version - oracle version from query - query to find oracle version - versione oracle - how to check database version in oracle - v version oracle - check oracle version sql - how to see oracle version - get version oracle - which oracle version -