vicker313 tech blog

May 16, 2009

How to check Oracle 10g is Standard or Enterprise Edition

Filed under: Oracle — Tags: , , — vicker313 @ 8:22 am

In normal situation, we can check the edition of Oracle 10g 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.

If you want to change the Oracle edition, you can refer to here.

Advertisements

9 Comments »

  1. […] here to check out the edition of Oracle. Possibly related posts: (automatically generated)Install Oracle […]

    Pingback by Change Oracle 10g edition in Linux « vicker313 tech blog — May 24, 2009 @ 5:05 pm

  2. Thanks a lot it was very helpfull

    Comment by Rodrigo — June 10, 2009 @ 1:14 am

  3. Good stuff.

    Thanks

    Comment by jennyca — February 17, 2010 @ 2:20 am

  4. useful information

    Comment by Pan — November 9, 2010 @ 3:05 pm

  5. In my case is very strange situation:

    SQL> SELECT * FROM v$version;

    BANNER
    —————————————————————-
    Oracle Database 10g Release 10.2.0.3.0 – 64bit Production
    PL/SQL Release 10.2.0.3.0 – Production
    CORE 10.2.0.3.0 Production
    TNS for Solaris: Version 10.2.0.3.0 – Production
    NLSRTL Version 10.2.0.3.0 – Production

    So I still do not know what license I have: Standard or Enterprise

    So I have checked in context.xml – but the path for this file is:

    /u01/app/oracle/product/10.2/inventory/Components21/oracle.server/10.2.0.1.0

    So – if I have Oracle 10g Release 10.2.0.3.0 – so why the path for context.xml file is: 10.2.0.1.0
    ???

    In context.xml file there is information what I want:

    grep -i s_serverInstallType context.xml

    – but I still do not know if this “SE” is for Release: 10.2.0.3.0 or for Release: 10.2.0.1.0

    Regards

    Comment by Marcin — December 17, 2010 @ 3:14 am

    • If there is no “Enterprise” word, you have standard edition, that is your case

      Comment by Osy — April 26, 2011 @ 8:02 am

  6. Thank you for this post. I did not have a version listed either. This confirms my what I thought.

    Comment by Donny Wilson — January 19, 2011 @ 3:15 am

  7. Thanks, simple and use full
    select * from v$version

    Comment by Jahanzaib — January 19, 2011 @ 8:44 pm

  8. Thankyou simple and use full
    select * from v$version

    Comment by Jahanzaib — January 19, 2011 @ 8:44 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: