This discussion is archived
7 Replies Latest reply: Jul 2, 2013 9:40 PM by rarain RSS

Confusion with installed Oracle Database Edition

Krishna Newbie
Currently Being Moderated

Hello Experts,

 

Greetings !

 

I have installed Oracle 11.2.0.3 RAC  over RHEL 6.4. While Installing Oracle Database I selected the Standard Edition but after completion when logged into SQL Prompt, it showed me the "Enterprise Edition". I am really confused and really not getting what went wrong into it.

 

Please guide.

 

Thnks & Bst Rgds,

Kapil Relan

  • 1. Re: Confusion with installed Oracle Database Edition
    kcrrga Newbie
    Currently Being Moderated

    Can you provide us the output of the below SQL Query?

     

    select * from v$version or gv$version;

  • 2. Re: Confusion with installed Oracle Database Edition
    Krishna Newbie
    Currently Being Moderated

    [oracle@database1 ~]$ sqlplus "/ as sysdba"

     

     

    SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 19 12:02:15 2013

     

     

    Copyright 1982, 2011, Oracle.  All rights reserved.

     

     

     

     

    Connected to:

    Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

    With the Real Application Clusters and Automatic Storage Management options

     

    SQL> select * from v$version;

     

     

    BANNER

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

    Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

    PL/SQL Release 11.2.0.3.0 - Production

    CORE    11.2.0.3.0      Production

    TNS for Linux: Version 11.2.0.3.0 - Production

    NLSRTL Version 11.2.0.3.0 - Production

  • 3. Re: Confusion with installed Oracle Database Edition
    kcrrga Newbie
    Currently Being Moderated

    Can you also provide the output of the below query?

     

    select * from product_component_version;

  • 4. Re: Confusion with installed Oracle Database Edition
    Krishna Newbie
    Currently Being Moderated

    SQL> select * from product_component_version;

     

     

    PRODUCT

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

    VERSION

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

    STATUS

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

    NLSRTL

    11.2.0.3.0

    Production

     

     

    Oracle Database 11g

    11.2.0.3.0

    64bit Production

     

     

    PRODUCT

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

    VERSION

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

    STATUS

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

     

     

    PL/SQL

    11.2.0.3.0

    Production

     

     

    TNS for Linux:

    11.2.0.3.0

     

     

    PRODUCT

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

    VERSION

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

    STATUS

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

    Production

  • 5. Re: Confusion with installed Oracle Database Edition
    kcrrga Newbie
    Currently Being Moderated

    I am sorry for delayed response.

     

    How did you install Oracle database using DBCA or manually?

  • 6. Re: Confusion with installed Oracle Database Edition
    NikolayIvankin Expert
    Currently Being Moderated

    I don't see "Enterprise Edition" after login.

    Standart Edition supports up to 4 1-CPU (or 2x2-CPU) nodes RAC configuration, therefore you see enterprise options.

     

    Here is a link to ensure which edition do you have - To be or not to be?… Standard Edition or Standard Edition One? | Oracle Blog

  • 7. Re: Confusion with installed Oracle Database Edition
    rarain Explorer
    Currently Being Moderated

    Hi,

     

    You can grep the db_InstallType from globalvariables.xml to find Grid or Database binaries edition as shown in below example.

     

    [grid11@server1 oracle.crs]$ cat /oracle/app1/11.2.0/grid_2/inventory/globalvariables/oracle.crs/globalvariables.xml |grep db_InstallType

    <VAR NAME="oracle_install_db_InstallType" TYPE="STRING" VALUE="EE" ADVISE="T" COMPUTE_AT_CLONE="F" CALC_REQD="F" class="oracle.sysman.oii.oiis.OiisVariable" EXTENDS_FROM="" ALLOW_A

    SSIGNMENT="T" HANDLE_ERRORS="F" VAL_REQD="F" SECURE="F" SUPPRESS_ON_SILENT="F" DESC_ID=""/>

     

    [grid11@server1 oracle.crs]$ cat /oracle/app1/oracle/product/11.2.0/db_2/inventory/globalvariables/oracle.server/globalvariables.xml |grep db_InstallType

    <VAR NAME="oracle_install_db_InstallType" TYPE="STRING" VALUE="EE" ADVISE="T" COMPUTE_AT_CLONE="F" CALC_REQD="F" class="oracle.sysman.oii.oiis.OiisVariable" EXTENDS_FROM="" ALLOW_A

    SSIGNMENT="T" HANDLE_ERRORS="F" VAL_REQD="F" SECURE="F" SUPPRESS_ON_SILENT="F" DESC_ID=""/>

     

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points