Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find DB is Standard Edition or not ?

JhilApr 12 2022

HI All,
It seems following below 11204 DB is Standard Edition.
I'm in confusion. Kindly confirm is this standard edition or some other edition.
We are planning to apply one off patch.

$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 12 20:02:30 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g 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 Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Thanks

This post has been answered by Mike Kutz on Apr 12 2022
Jump to Answer
Comments
Post Details
Added on Apr 12 2022
8 comments
1,303 views