How to check Edition of Oracle 10g/11g or 12c in Software Installed Only?

In normal Case where the Database is created , We can check the Version and as well Edition Using SQL plus 
Just Login the with SQL plus and execute the command

SQL > Select * from v$version ;

But what if there is Software installed only & not Database Created yet and We need to check the edition. In such a scenario we need  to find check some files.

In Case of Oracle 10g , locate the file in below path

$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,Go to the Location

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

In case of Oracle 12c,Go to the Location

$ORACLE_HOME/oui/bin/
./runInstaller

you will find the Edition. This will also help to find out all Oracle home currently installed in system with Edition

Thanks,

Stay tune on DBA Sniper