How to verify that the edition of Oracle is Std ONE
654913May 15 2009 — edited May 15 2009Hello,
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