Check Oracle Version

Home»Software»Databases»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.

About the Author:

LK is a technology writer for Tech Journey with background of system and network administrator. He has be documenting his experiences in digital and technology world for over 15 years.Connect with LK through Tech Journey on Facebook, Twitter or Google+.
  • It was a very helpful to find the oracle version information through sqlplus.

    Thanks,
    pankaj

  • Karthikeyan

    select * from versions;

    The above SQL will do.

  • A

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

  • 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%';

    • David Roberts

      Thank you!; the tip about the curly quotes did it for me.

  • 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. 🙂

  • Thanks. It worked for me.

    Still running Windows Server 2003 with Oracle 9.22 enterprise server.

  • In Oracle 9.2. is:
    select * from sys.v_$version

  • Dan

    Hi

    Does anyone know if you can run a higher client version that the database version?

    I have a database running Oracle9, and I want to use client version 10.2, is anyone aware of any issues?

    Thanks

  • Badminton Skills

    "select * from v$version" is exactly what I needed, thanks.

  • Axel Röhken

    Hi All !
    But if one installed the newly distributed PSUs (Patch Set Updates) then neither banner (when starting sqlplus and connect to an DB) nor v$version reports the right version.
    A better opportunity is to use opatch.
    "opatch lsinventory" shows the installed (base) version and apllied patch sets as well as patches. The latter (patch number) is the indicator to find the installed PSU, e.g. 11724936 stands for 11.1.0.7.7 (latest PSU for 11gR1).

    opatch could be retrieved under support.oracle.com
    Beware: For every major oracle db server you must download the appropriate opatch version: –> https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1#aref2

    Regards
    Axel

  • Alok

    query to find oracle server name:

    set serveroutput on
    execute dbms_output.put_line(utl_inaddr.get_host_name);

  • macy

    how do I check the version of Oracle installed in Centos Linux?

  • macy

    Could you please tell me how to check the version of Oracle installed in Centos Linux

Pin It on Pinterest

Share This

Share This

Share this post with your friends!