删除EM资料库出问题

2849087

请问：删除EM资料库，为什么一直提示“此操作可能需要一段时间”
1： emca  -deconfig  dbcontrol db
2：-repos  drop
然后就一直等着，将近半小时了。
这种长时间的等待算正常情况么？我之前重建过别的库，等待时间也就2分钟左右。这个库居然已经40分钟了。。还是没完。

Ling.QIu

请上传日志以及环境  不要让我们去猜
什么数据库版本 什么样的状况 监听器的状况  用户的状况

willing_ox

把相关的服务停止掉。
有可能是服务还在运行。

gtlions

删除EM的时候有遇到过这个情况，一般情况下3-5分钟就能完成了，但是有时候半天都没反应，是同一个库，前一次机会很快，后来再做一次的时候就遇到了。

s.o.m

drop oem是数据库会处于静默（quiescing）状态，oracle会给出警告的，查询 select status,active_state from v$instance;
此时只能通过sys、system建立数据库连接，所以oem伤不起，尤其是在生产库上要在业务空闲的时候操作。

s.o.m

Note that this command puts the database in Quiesce Mode.Please consult the Note 375946.1
Applies to: Enterprise Manager Grid Control - Version: 10.2.0.1 to 11.1.0.7
This problem can occur on any platform.
SymptomsWhen running 'emca -config dbcontrol db -repos recreate' or 'emca -deconfig dbcontrol db -repos drop' to recreate or drop the Enterprise Manager Database Control configuration files and repository the operation hangs and at the same time users are not able to login to the database. CauseThe emca command, when recreating or dropping the repository, requires the database to be quiesced. This means that, temporarily, no operations are possible on the database and new users cannot login.

If there are active sessions on the database at the time the quiesce operation will hang pending their completion, during which time no new users will be able to connect.
Therefore it is important to understand that running these commands may/will cause the database to be unavailable during the time that the repository is being dropped and should not be run on a production database unless you are fully aware of the possible impact to database availability and have planned for this eventuality
SolutionTo implement the solution, please execute the following steps:

1. Kill the emca command
2. Connect to the database with SYS account through SQL*Plus
SQL > alter system unquiesce;

Run the emca command at a time when there is low system usage.
For additional information on emca, please consult:
Enterprise Manager Advanced Configuration  
Topic 1.2.6 Configuring Database Control During and After the Oracle Database 10g Installation
Available on OTN at:
http://download.oracle.com/docs/cd/B16240_01/doc/nav/portal_booklist.htm