2 Replies Latest reply: Feb 5, 2013 10:26 AM by Pavan Kumar RSS

    Database version

    madala03
      how to check the database version ? my databases are not connected but i need to know which version i.e either standard or enterprise 10g or 11g please can you tell me how to look that ?


      BKPCCTB:/home/oracle>sp

      SQL*Plus: Release 10.2.0.2.0 - Production on Tue Feb 5 16:03:20 2013

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

      Connected to an idle instance.

      SIDNOTSET> exit
        • 1. Re: Database version
          sb92075
          madala03 wrote:
          how to check the database version ? my databases are not connected but i need to know which version i.e either standard or enterprise 10g or 11g please can you tell me how to look that ?


          BKPCCTB:/home/oracle>sp

          SQL*Plus: Release 10.2.0.2.0 - Production on Tue Feb 5 16:03:20 2013

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

          Connected to an idle instance.

          SIDNOTSET> exit
          [oracle@localhost ~]$ sqlplus / as sysdba
          
          SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 5 08:11:33 2013
          
          Copyright (c) 1982, 2010, Oracle.  All rights reserved.
          
          
          Connected to:
          Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
          With the Partitioning, OLAP, Data Mining and Real Application Testing options
          
          SQL> shutdown immediate
          Database closed.
          Database dismounted.
          ORACLE instance shut down.
          SQL> startup nomount
          ORACLE instance started.
          
          Total System Global Area  456146944 bytes
          Fixed Size                  1344840 bytes
          Variable Size             364907192 bytes
          Database Buffers           83886080 bytes
          Redo Buffers                6008832 bytes
          SQL> select * from v$version;
          
          BANNER
          --------------------------------------------------------------------------------
          Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
          PL/SQL Release 11.2.0.2.0 - Production
          CORE    11.2.0.2.0      Production
          TNS for Linux: Version 11.2.0.2.0 - Production
          NLSRTL Version 11.2.0.2.0 - Production
          
          SQL> 
          • 2. Re: Database version
            Pavan Kumar
            Hi,

            With out connecting to db or atleast db server little hard to get the things. If you have access to db server you can get the details from Oracle Inventory with respect to ORACLE_HOME which you would be working with.

            - Pavan Kumar N