Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

How to verify that Oracle installation is Enterprise or Standard Edition

edited Jan 16, 2012 7:00PM in Database Install/Upgrade/Opatch (MOSC) 7 commentsAnswered ✓
I would think this should be pretty straight forward to validate, but it is not, at least in my install case.  The installation was run and 'Standard Edition' was selected.  Based on review of the install log, it shows ‘Standard Edition’ selected.

 

Based on the known methods to validate whether a database is SE or EE, they all FAIL to confirm, except the last one, I propose.

 

select * from v$version;

 

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

"CORE  11.2.0.1.0          Production"

TNS for 64-bit Windows: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

 

select * from product_component_version;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center