HOW TO FIND ENTERPRISE OR STANDARD EDITION IN ORACLE DATABASE

HOW TO FIND ENTERPRISE OR STANDARD EDITION IN ORACLE DATABASE

Execute sqlplus and find the edition. In this case, we can see enterprise edition in the output

E:\app\product\11.2.0\dbhome_2\inventory\ContentsXML\ConfigXML>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 8 19:48:51 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Check in v$version

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Check global variables file from inventory in oracle home. Search with oracle_install_db_InstallEdition

E:\app\product\11.2.0\dbhome_2\inventory\globalvariables\oracle.server>cd
E:\app\product\11.2.0\dbhome_2\inventory\globalvariables\oracle.server

E:\app\product\11.2.0\dbhome_2\inventory\globalvariables\oracle.server>notepad globalvariables.xml

Leave a Reply

%d