Search This Blog

Tuesday, July 14, 2009

How to check database is "Enterprise Edition" Or "Standard Edition"

Today I come across one question on OTN forum about "EE" Or "SE" identification।

There is a simple way to check is

C:\>sqlplus system@TEST
SQL*Plus: Release 10.1.0.4.2 - Production on Tue Jul 14 12:00:32 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, OLAP and Data Mining options

But some condition "sqlplus" will not help in that case use the below procedure to check

Go $ORACLE_HOME -->Inventory (Directory) ---> Components21(Directory) ---> oracle.server (Directory) --->[version_name] (directory) --->context.xml (xml file)

Open the context.xml file and search for ""s_serverInstallType"" and check "Val" field value

If it is Val=EE mean Enterprise Edition Or if it is Val=SE mean Standard Edition

For example:

VAL="EE"" ADV="F" CLONABLE="F" USER_INPUT="CALC" />

NOTE: Above Solution work for both platform (Linux & Windows)

3 comments:

Coskan Gundogar said...

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Rajeshkumar Govindarajan said...

useful information taj
we can also view through

SQL> select * from product_component_version;

PRODUCT
--------------------------------------------------------------------------------VERSION
--------------------------------------------------------------------------------STATUS
--------------------------------------------------------------------------------NLSRTL
10.2.0.1.0
Production

Oracle Database 10g Enterprise Edition
10.2.0.1.0
Prod

PRODUCT
--------------------------------------------------------------------------------VERSION
--------------------------------------------------------------------------------STATUS
--------------------------------------------------------------------------------
PL/SQL
10.2.0.1.0
Production

TNS for Linux:
10.2.0.1.0

PRODUCT
--------------------------------------------------------------------------------VERSION
--------------------------------------------------------------------------------STATUS
--------------------------------------------------------------------------------Production

Rajeshkumar Govindarajan said...

very useful information taj,
we can also view through...
SQL> select * from product_component_version;

PRODUCT
--------------------------------------------------------------------------------VERSION
--------------------------------------------------------------------------------STATUS
--------------------------------------------------------------------------------NLSRTL
10.2.0.1.0
Production

Oracle Database 10g Enterprise Edition
10.2.0.1.0
Prod

PRODUCT
--------------------------------------------------------------------------------VERSION
--------------------------------------------------------------------------------STATUS
--------------------------------------------------------------------------------
PL/SQL
10.2.0.1.0
Production

TNS for Linux:
10.2.0.1.0

PRODUCT
--------------------------------------------------------------------------------VERSION
--------------------------------------------------------------------------------STATUS
--------------------------------------------------------------------------------Production