安装时选择了配置EM,但是安装到89%时提示EM未能启动,安装完成后手动配置
执行 emca -config dbcontrol db 命令时提示:‘严重:无法启动Database Control。’
日志文件emca_2010_06_28_08_15_02.log内容如下:2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag '-migrate' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateFromDBControl' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateToCentralAgent' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateFromCentralAgent' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateToDBControl' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag '-reconfig' set to true
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'ports' set to true
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: RMI_PORT value: 5523
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ORACLE_HOME value: E:\oracle\product\11.1.0\db_1
2010-6-28 8:15:02 oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
配置: isCRSInstalled: false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SID 的值。
2010-6-28 8:15:05 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SID value: student
2010-6-28 8:15:08 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ASM_SID 的值。
2010-6-28 8:15:08 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ASM_SID value: +ASM
2010-6-28 8:15:08 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2010-6-28 8:15:08 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: +ASM, oracleHome: E:\oracle\product\11.1.0\db_1, and user: SYS
2010-6-28 8:15:09 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: ORA-12560: TNS: 协议适配器错误oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12560: TNS: 协议适配器错误 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:853)
at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:364)
at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1040)
at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:2885)
at oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:641)
at oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java:2680)
at oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:2706)
at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:2733)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1190)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
2010-6-28 8:15:20 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2010-6-28 8:15:20 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: +ASM, oracleHome: E:\oracle\product\11.1.0\db_1, and user: SYS
2010-6-28 8:15:21 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: ORA-12560: TNS: 协议适配器错误oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12560: TNS: 协议适配器错误 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:853)
at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:364)
at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1040)
at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:2885)
at oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:641)
at oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java:2680)
at oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:2706)
at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:2733)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1190)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
执行 emca -config dbcontrol db 命令时提示:‘严重:无法启动Database Control。’
日志文件emca_2010_06_28_08_15_02.log内容如下:2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag '-migrate' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateFromDBControl' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateToCentralAgent' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateFromCentralAgent' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'migrateToDBControl' set to false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag '-reconfig' set to true
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'ports' set to true
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: RMI_PORT value: 5523
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ORACLE_HOME value: E:\oracle\product\11.1.0\db_1
2010-6-28 8:15:02 oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
配置: isCRSInstalled: false
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2010-6-28 8:15:02 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SID 的值。
2010-6-28 8:15:05 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SID value: student
2010-6-28 8:15:08 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ASM_SID 的值。
2010-6-28 8:15:08 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ASM_SID value: +ASM
2010-6-28 8:15:08 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2010-6-28 8:15:08 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: +ASM, oracleHome: E:\oracle\product\11.1.0\db_1, and user: SYS
2010-6-28 8:15:09 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: ORA-12560: TNS: 协议适配器错误oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12560: TNS: 协议适配器错误 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:853)
at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:364)
at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1040)
at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:2885)
at oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:641)
at oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java:2680)
at oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:2706)
at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:2733)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1190)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
2010-6-28 8:15:20 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2010-6-28 8:15:20 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: +ASM, oracleHome: E:\oracle\product\11.1.0\db_1, and user: SYS
2010-6-28 8:15:21 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: ORA-12560: TNS: 协议适配器错误oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12560: TNS: 协议适配器错误 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:853)
at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:364)
at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1040)
at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:2885)
at oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:641)
at oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java:2680)
at oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:2706)
at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:2733)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1190)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
用这种方法试试:
手工重新配置dbconsole的步骤
1,修改DBSNMP密码:
重新配置DBCONSOLE,需要输入DBSNMP密码,但任何密码都会显示错误,需要预先修改。
sql>alter user dbsnmp identified by xxx;
2,删除早期DBCONSOLE创建的用户:
sql>drop role MGMT_USER;
sql>drop user MGMT_VIEW cascade;
sql>drop user sysman cascade;
3,删除早期DBCONSOLE创建的对象:
sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
sql>drop public synonym SETEMVIEWUSERCONTEXT;
4,重新创建DBCONSOLE:(如果是在windows下,要先到注册表删除DBCONSOLE的服务,重启电脑)
$emca -config dbcontrol db -repos create
根据提示,先输入SID,再输入Y继续;
输入端口1521,输入SYS密码,输入DBSNMP密码,输入SYSMAN 密码,输入Y继续
完成。本文来自CSDN博客,转载请标明出处:
http://blog.csdn.net/tianlesoftware/archive/2009/10/21/4702978.aspx还有你的数据库和监听启动正常吗?
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
到注册表删除DBCONSOLE的服务,是LEGACY_ORACLEDBCONSOLEORCL吗?
到注册表删除服务? 重建OEM 不用删除这些, 你是怎么操作的?
不明白所以请教。
您是想说服务里的DBCONSOLE吗?我的这个服务起不来。
sqlplus中错误提示为emca_repos_create_2010_06_28_18_03_03.log中的错误提示:....
CREATE PUBLIC SYNONYM MGMT_AVAILABILITY FOR MGMT_AVAILABILITY
*
第 1 行出现错误:
ORA-00955: 名称已由现有对象使用
emca_2010_06_28_18_02_28.log中的错误提示:
...
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...
2010-6-28 18:06:02 oracle.sysman.emcp.EMReposConfig createRepository
配置: ORA-00955: 名称已由现有对象使用oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00955: 名称已由现有对象使用 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:270)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:311)
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
2010-6-28 18:06:02 oracle.sysman.emcp.EMReposConfig invoke
严重: 创建资料档案库时出错
2010-6-28 18:06:02 oracle.sysman.emcp.EMReposConfig invoke
信息: 有关详细资料, 请参阅 E:\oracle\cfgtoollogs\emca\student\emca_repos_create_<日期>.log 中的日志文件。
2010-6-28 18:06:02 oracle.sysman.emcp.EMConfig perform
严重: 创建资料档案库时出错
有关详细资料, 请参阅 E:\oracle\cfgtoollogs\emca\student\emca_2010_06_28_18_02_28.log 中的日志文件。
2010-6-28 18:06:02 oracle.sysman.emcp.EMConfig perform
配置: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: 创建资料档案库时出错
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:230)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)