博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Oracle11g重建EM 报ORA-20001: SYSMAN already exists
阅读量:7221 次
发布时间:2019-06-29

本文共 3365 字,大约阅读时间需要 11 分钟。

日志:

Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMReposConfig createRepositoryCONFIG: ORA-20001: SYSMAN already exists..ORA-06512: at line 17oracle.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 invokeSEVERE: Error creating the repositoryApr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_repos_create_
.log for more details.Apr 4, 2015 10:08:09 PM oracle.sysman.emcp.EMConfig performSEVERE: Error creating the repositoryRefer 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 performCONFIG: 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 restoreOuiLocCONFIG: 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

转载于:https://www.cnblogs.com/rusking/p/4394025.html

你可能感兴趣的文章
Web前端入门学习(3)——CSS选择器
查看>>
DNS的搭建
查看>>
Apache/Nginx 访问日志分析脚本
查看>>
Curator的使用
查看>>
第五章 集合类型
查看>>
我的友情链接
查看>>
nagios监控服务出现FLAPPING状态时无法发出邮件报警信息
查看>>
数据库链接字符串方法
查看>>
The DCI Architecture: A New Vision of Object-Oriented Programming(一篇具有里程碑式意义的论文)...
查看>>
RIP路由配置实例V2
查看>>
Bytescout Spreadsheet SDK for.NET
查看>>
我的友情链接
查看>>
Haproxy的三种保持客户端会话保持方式
查看>>
iOS的数学函数
查看>>
python 模块 chardet下载及介绍(转)
查看>>
能力工场--关于在JavaScript中使用EL表达式的问题
查看>>
NFS服务器设置
查看>>
s:iterator 中的status 使用方法
查看>>
cocos2d-x 源码剖析系列
查看>>
IT系统架构设计
查看>>