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） 说明

http://blog.csdn.net/tianlesoftware/article/details/5937382

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.1HowTo Drop, Create And Recreate DB Control In A 10g Database

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

Oracle OEM 重建 及 案例 说明

http://blog.csdn.net/tianlesoftware/article/details/4702978

-------------------------------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

Skype: tianlesoftware

Email: [e-mail]

Blog: http://www.tianlesoftware.com

Weibo: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

-------加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请----

DBA1 群：62697716(满); DBA2 群：62697977(满)DBA3 群：62697850(满)

DBA 超级群：63306533(满); DBA4 群：83829929 DBA5群： 142216823

DBA6 群：158654907 DBA7 群：172855474 DBA总群：104207940