Home > Oracle, RDBMS > How to check Oracle 10/11g is Standard or Enterprise Edition?

How to check Oracle 10/11g is Standard or Enterprise Edition?

In normal situation, we can check the edition of Oracle 10/11g 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 two 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. In case of Oracle 10g you have to locate the following file:

$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.

In case of Oracle 11g, you need to locate the following file:

$ORACLE_HOME/inventory/globalvariables/oracle.server/globalvariables.xml

Inside this globalvariables.xml file, look for variable oracle_install_db_InstallType and check out its value (VALUE). If it is EE, means it is Enterprise Edition. While SE means Standard Edition.

Advertisements
Categories: Oracle, RDBMS Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: