How to check Oracle 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 connection 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:

1	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 dig into the files. In case of Oracle 10g you have to locate the following file:

1	$ORACLE_HOME/inventory/Components21/oracle.server/*/context.xml

Inside this context.xml file, 

check the parameter s_serverInstallType and check out its value (VAL). 

If it is EE, means it is Enterprise Edition. 

         SE or STD means Standard Edition.

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

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

Inside this globalvariables.xml file, look for variable oracle_install_db_InstallType or oracle_install_db_Installedition 

and check out its value (VALUE). 

If it is EE, means it is Enterprise Edition. 

         SE or STD means Standard Edition.