Forgot your password?    
+ Reply to Thread
Results 1 to 3 of 3

Thread: How to check whether a Database is of Enterprise edition or standard edition?

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43

    How to check whether a Database is of Enterprise edition or standard edition?

    How to check whether a Database is of Enterprise edition or standard edition?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    In normal situation, we can check the edition of Oracle using SQLPlus. Just login using SQLPlus, and there will be a connention message on top of the SQL prompt, stating that the Oracle is either Standard or Enterprise.

    Or you can also issue the following select statement to get the edition information:
    select * from v$version

    However if the database is not created using Database Configuration Assistant (DBCA), but using script or SQL statement, the 2 methods stated above might not work. It still will show out the edition detail but not stating that it is either Standard or Enterprise.

    In such scenario, we will need to digg into the files. First look for this file (applicable to both linux and windows):
    $ORACLE_HOME/inventory/Components21/oracle.server/*/context.xml

    Inside this context.xml file, look for parameter s_serverInstallType and check out its value (VAL). If it is EE, means it is Enterprise Edition. While SE means Standard Edition.

    Regards

  3. #3
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    THanx for the useful information

+ Reply to Thread

Similar Threads

  1. OEM Grid Control Training in Delhi : Online Grid Control 11g Training
    By Hemant in forum Oracle Training Modules - Database RAC RMAN DataGuard GoldenGate Apps FMW Weblogic OAM OIM ODS ..
    Replies: 0
    Last Post: 07-28-2012, 01:38 AM
  2. Script to check the Database space
    By Amit in forum Database Scripts
    Replies: 0
    Last Post: 11-03-2011, 03:53 PM
  3. Check Database Long Runing Sessions
    By Amit in forum Database Scripts
    Replies: 0
    Last Post: 11-03-2011, 12:52 PM
  4. Health Check script for Oracle RAC Database
    By Amit in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 11-03-2011, 12:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics