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 checkGo $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)
Tuesday, July 14, 2009
How to check database is "Enterprise Edition" Or "Standard Edition"
Subscribe to:
Post Comments (Atom)
3 comments:
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
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
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
Post a Comment