Oracle11g重建EM 报ORA-20001: SYSMAN already exists

日志:

Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: ORA-20001: SYSMAN already exists..
ORA-06512: at line 17

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..
ORA-06512: at line 17

        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)
        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1000)
        at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)
        at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)
        at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:510)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:228)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_repos_create_<date>.log for more details.
Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2015_04_04_22_07_40.log for more details.
Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace: 
oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:240)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0.1/db_1/oui

处理方法:

1、使用emca -deconfig dbcontrol db命令删除配置
2、使用emca -repos drop删除repository
3、使用emca -config dbcontrol db -repos create 

如果还报其它错,则按如下步骤操作:

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;
 

[oracle@rhel201 ~]$ emca -config dbcontrol db -repos create  (创建资料库和dbcontrol)

***********************************************************

……
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 4, 2015 10:25:41 PM

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值