find if Oracle version is Standard or Enterprise edition ?
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.
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.
Comments
Post a Comment