oracle 数据文件已存在,Oracle11g Em已经存在的解决方法

当前位置:我的异常网» 数据库 » Oracle11g Em已经存在的解决方法

Oracle11g Em已经存在的解决方法

www.myexceptions.net  网友分享于：2014-08-23  浏览：0次

Oracle11g Em已经存在的解决办法

emca  -repos create 创建资料库时出现如下错误

SEVERE: Dbcontrol Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode.

使用emca -deconfig dbcontrol db -repos drop进行删除。

[oracle@oradb01 bin]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Jan 6, 2012 2:11:28 PM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:

Database SID: orcl

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

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

WARNING : While repository is dropped the database will be put in quiesce mode.

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

Do you wish to continue? [yes(Y)/no(N)]: y

Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /opt/ora11g/cfgtoollogs/emca/orcl/emca_2012_01_06_14_11_28.log.

Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration

WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:

1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME= and re-run EMCA script

2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script

Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) ...

Jan 6, 2012 2:15:46 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Enterprise Manager configuration completed successfully

FINISHED EMCA at Jan 6, 2012 2:15:48 PM

再用dbca的Configure Database Options重建EM即可

[oracle@oradb01 bin]$ dbca

dbca 重建好EM后，默认已经启动dbconsole

[oracle@oradb01 bin]$ emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.

https://oradb01:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.

文章评论