Once invoking sqlplus and connecting to database, we can use:
sql> SELECT * FROM VERSION;
SQL> SELELCT BANNER FROM V$VERSION;
But some condition "sqlplus" will not help in that case use the below procedure to check
Go $ORACLE_HOME -->Inventory (Directory) ---> Components21(Directory) ---> oracle.server (Directory) --->[version_name] (directory) --->context.xml (xml file)
Open the context.xml file and search for ""s_serverInstallType"" and check "Val" field value
If it is Val=EE mean Enterprise Edition Or if it is Val=SE mean Standard Edition
sql> SELECT * FROM VERSION;
SQL> SELELCT BANNER FROM V$VERSION;
But some condition "sqlplus" will not help in that case use the below procedure to check
Go $ORACLE_HOME -->Inventory (Directory) ---> Components21(Directory) ---> oracle.server (Directory) --->[version_name] (directory) --->context.xml (xml file)
Open the context.xml file and search for ""s_serverInstallType"" and check "Val" field value
If it is Val=EE mean Enterprise Edition Or if it is Val=SE mean Standard Edition
No comments:
Post a Comment