一. Enterprise Manager 组件说明
在说明之前,我们先用如下SQL 查看一下DB中的组件:
SQL> col comp_id for a15
SQL> col version for a15
SQL> col comp_name for a30
SQL> select comp_id,comp_name,versionfrom dba_registry ;
COMP_ID COMP_NAME VERSION
--------------------------------------------- ---------------
XDB Oracle XML Database 11.2.0.3.0
AMD OLAP Catalog 11.2.0.3.0
EM Oracle Enterprise Manager 11.2.0.3.0
SDO Spatial 11.2.0.3.0
ORDIM Oracle Multimedia 11.2.0.3.0
CONTEXT Oracle Text 11.2.0.3.0
ODM Oracle Data Mining 11.2.0.3.0
EXF Oracle Expression Filter 11.2.0.3.0
RUL Oracle Rules Manager 11.2.0.3.0
OWM Oracle Workspace Manager 11.2.0.3.0
CATALOG Oracle Database Catalog Views 11.2.0.3.0
COMP_ID COMP_NAME VERSION
--------------------------------------------- ---------------
CATPROC Oracle Database Packages and T11.2.0.3.0
ypes
JAVAVM JServer JAVA Virtual Machine 11.2.0.3.0
XML Oracle XDK 11.2.0.3.0
CATJAVA Oracle Database Java Packages 11.2.0.3.0
XOQ Oracle OLAP API 11.2.0.3.0
APS OLAP Analytic Workspace 11.2.0.3.0
17 rows selected.
MOS说明:
Oracle 8i/9i/10g/11g 组件(Components) 说明
This componentwill appear in dba_registry when you have configured a db console in yourdatabase. This is available from Oracle rdbms 10gR1 onwards. Please note thatfor this component you need to have Oracle Enterprise Manager installed atbinaries level.
OEM 组件用户:
DBSNMP, SYSMAN, MGMT_VIEW (11gR1 and 11gR2only)
二.OEM 组件重建
Note.278100.1 HowTo Drop, Create And Recreate DB Control In A 10g Database