How to Check Oracle Edition is Standard or Enterprise

FREQUENTLY ASKED QUESTIONS (Oracle)
Q.How to Check/find if Oracle version is Standard or Enterprise edition ?

Sometimes you need to find the version and Edition of Oracle database installed on your server. There are few ways to find the Oracle version. You can find Oracle version complete Information from SQLPlus, Registry,query, etc..

Recognize Oracle Stardard Editions (SE)

Login into SQL Plus via command prompt and after typing username and password there will be a banner message like below. And it not specified as any Editions ? It must me a Standard Edition.

Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production.

Above connected to is a Standard Edition(SE) of Oracle.(Not specified any Editions particularly)


Find Oracle Version details from SQLPlus
SQL> select * from v$version;

Recognize Oracle Enterprise Editions (EE)
Login into SQL Plus via command prompt and after typing username and password there will be a message like below. It must particularly specified as an Enterprise Edition Oracle release.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production.
With the Partitioning, OLAP and Data Mining options


Above is an  Enterprise Edition (EE) of Oracle. (Specified as Enterprise Edition particularly)
You can also do the above query.

Find Oracle Edition from Windows Registry (7, XP,2003, 2008)
Navigate to "HKEY_LOCAL_MACHINE" ->   "SOFTWARE"  ->  "ORACLE"    and click on  "KEY_OraDb11g_home1" and you can find the Edition on the right side (see below screenshot).
as ORACLE_BUNDLE_NAME

LABELS: extra-tips, FAQ, Oracle, Windows