1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to know which Oracle version you are using?

Discussion in 'General' started by Arju, Oct 17, 2008.

  1. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    It is common question for most of us specially with the newbie is which version I am using. This may be sometime ambiguous about what you mean. Do you indicate oracle version or Sql*plus version or imp version or rman version or etc like that. Here is some way to determine your several version you use on your database.
    1)
    In order to know oracle version, along with PL/SQL, TNS, NLSRTL use,
    Code (Text):
    SQL> select * from v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
    PL/SQL Release 10.2.0.1.0 - Production
    CORE    10.2.0.1.0      Production
    TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production
    2)
    In order to know your sql*plus version use,
    Code (Text):
    C:\Documents and Settings\Queen>sqlplus -V

    SQL*Plus: Release 10.2.0.1.0 - Production
    3)Almost all of the utility version can be seen by simply writing the utility name. Several utility versions are shown below.
    Code (Text):
    C:\Documents and Settings\Queen>expdp

    Export: Release 10.2.0.1.0 - Production on Saturday, 18 October, 2008 0:22:44

    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Code (Text):
    C:\Documents and Settings\Queen>nid

    DBNEWID: Release 10.2.0.1.0 - Production on Sat Oct 18 00:23:00 2008

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    Code (Text):
    C:\Documents and Settings\Queen>exp

    Export: Release 10.2.0.1.0 - Production on Sat Oct 18 00:23:46 2008

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    Code (Text):
    C:\Documents and Settings\Queen>sqlldr

    SQL*Loader: Release 10.2.0.1.0 - Production on Sat Oct 18 00:24:42 2008

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
     
    Code (Text):
    C:\Documents and Settings\Queen>dbv

    DBVERIFY: Release 10.2.0.1.0 - Production on Sat Oct 18 00:25:55 2008

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    4)RMAN/Recovery manager version can be identified by simply name of it on console like,
    Code (Text):
    C:\Documents and Settings\Queen>rman

    Recovery Manager: Release 10.2.0.1.0 - Production on Sat Oct 18 00:28:02 2008

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