I have installed a database through dbca, unchecking all the options boxes when going through the setup wizard:
Upon completion, there is still a component left that I do not want to have installed: the Oracle Workspace Manager.
It is registred in the database's registry:
SYS@orcl>SQL>SELECT COMP_NAME,COMP_ID,VERSION,STATUS FROM DBA_REGISTRY; COMP_NAME COMP_ID VERSION STATUS ---------------------------------------- ------------------------------ ------------------------------ ---------------- Oracle Database Catalog Views CATALOG 19.0.0.0.0 VALID Oracle Database Packages and Types CATPROC 19.0.0.0.0 VALID Oracle Real Application Clusters RAC 19.0.0.0.0 OPTION OFF Oracle XML Database XDB 19.0.0.0.0 VALID Oracle Workspace Manager OWM 19.0.0.0.0 VALIDTo remove the OWM component:
SYS@orcl>SQL> @?/rdbms/admin/owmuinst.plb Session altered. PL/SQL procedure executed. PL/SQL procedure executed. Session altered.Option is now deinstalled:
SYS@orcl>SQL>SELECT COMP_NAME,COMP_ID,VERSION,STATUS FROM DBA_REGISTRY; COMP_NAME COMP_ID VERSION STATUS ---------------------------------------- ------------------------------ ------------------------------ ------------------ Oracle Database Catalog Views CATALOG 19.0.0.0.0 VALID Oracle Database Packages and Types CATPROC 19.0.0.0.0 VALID Oracle Real Application Clusters RAC 19.0.0.0.0 OPTION OFF Oracle XML Database XDB 19.0.0.0.0 VALIDWhat exactly is the OWM ?
In a nutshell, it's a version tool for data within a schema. It has been around since Oracle 9i
See documentation here
Particulary the whitepaper
Check out Tim Hall's article on oracle-base.com about the subject.
No comments:
Post a Comment