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 verify that the edition of Oracle is Std ONE

654913May 15 2009 — edited May 15 2009
Hello,

I need to verify which edition of Oracle I just installed.

During the installation I selected "Standard One" from the drop down box. That is the edition I need.
After install completed, I could not find a single indication that it is actually edition "One". I could find "Standard" in the install log, but not "Standard One".
Same in the registry (oracle_bundle_name).
Select from v$version or Product_Component_Version doesn't specify the edition at all.

BANNER
Oracle Database 11g Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

At one point I thought of using the limitation as a way to determine the exact version. However CPU limitation and database size limitation are property of EXPRESS, not Std ONE. The only difference between STD and STD ONE seems to be Real App Cluster. Don't know if One has replication. So, can't use the limits to determine the version.


The purpose of this installation is to determine if this version ONE of Oracle would be sufficient for the particular development,
which makes it very important to make sure the version is correct.

Is there any way (direct or nondirect) to confirm that the version installed is exactly "Standard One"?

It should not be that hard to find the edition info, is there something I am missing?

Please help

Thanks
This post has been answered by oradba on May 15 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2009
Added on May 15 2009
4 comments
1,213 views