必须先说明组件oracle,Oracle Enterprise Manager 组件 说明 .

一．    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 组件重建

HowTo Drop, Create And Recreate DB Control In A 10g Database

OEM的重建，之前有Blog 说明，这里直接参考：