If you want to find out whether Oracle is Standard Edition (SE) or Enterprise Edition (EE), then this is for you. Now, why would someone be interested in finding it out? One reason could be to check which licensing option is the Oracle based on and correspondingly find out which features can be used.
There are several ways some of which are listed below; if you do not see “Enterprise”, it means it is “Standard”.
Source for this Techbit is at http://vicker313.wordpress.com/2009/05/16/how-to-check-oracle-10g-is-standard-or-enterprise-edition/.
How is Oracle licensed or what kinds of features does one get to use based on EE etc.? These are going to be addressed as part of upcoming Techbits.
There are several ways some of which are listed below; if you do not see “Enterprise”, it means it is “Standard”.
- banner displayed at sqlplus prompt
- select * from v$version
- If the above methods do not work (which could be because of DB not being created using Database Configuration Assistant aka DBCA), then do this: In the file “$ORACLE_HOME/inventory/Components21/oracle.server/*/context.xml”, check the value (VAL) of the parameter ‘s_serverInstallType’ – SE or EE.
Source for this Techbit is at http://vicker313.wordpress.com/2009/05/16/how-to-check-oracle-10g-is-standard-or-enterprise-edition/.
How is Oracle licensed or what kinds of features does one get to use based on EE etc.? These are going to be addressed as part of upcoming Techbits.
