In normal situation, we can check the edition of Oracle 10g using SQLPlus. Just login using SQLPlus, and there will be a connention message on top of the SQL prompt, stating that the Oracle is either Standard or Enterprise.
Or you can also issue the following select statement to get the edition information:
select * from v$version
However if the database is not created using Database Configuration Assistant (DBCA), but using script or SQL statement, the 2 methods stated above might not work. It still will show out the edition detail but not stating that it is either Standard or Enterprise.
In such scenario, we will need to digg into the files. First look for this file (applicable to both linux and windows):
context.xml file, look for parameter
s_serverInstallType and check out its value (
VAL). If it is EE, means it is Enterprise Edition. While SE means Standard Edition.
If you want to change the Oracle edition, you can refer to here.