10G 重建EM 报ORA-20001: SYSMAN already exists

 

在手工创建EM之前，需要先要删除EM配置信息：

具体操作如下：

1、使用emca -deconfig dbcontrol db命令删除配置

2、使用emca -repos drop删除repository

3、使用emca -config dbcontrol db -repos create 创建Database Control

 

另外一种方法：

Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects:

　                SQL> drop user sysman cascade;

                  SQL> drop role MGMT_USER;

                  SQL> drop user MGMT_VIEW cascade;

                  SQL> drop public synonym MGMT_TARGET_BLACKOUTS;

                  SQL> drop public synonym SETEMVIEWUSERCONTEXT;