My Oracle Support Banner

EMCA Release 10.1 to 11.1 Puts the Database in Quiesce And No New Connections or Operations Can Be Performed During the DB Control Repository Creation (Doc ID 375946.1)

Last updated on JANUARY 18, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.

Symptoms

Running 'emca -config dbcontrol db -repos recreate' or 'emca -deconfig dbcontrol db -repos drop' to recreate or drop the Enterprise Manager (EM) Database Control configuration files and repository hangs and at the same time users are not able to log in to the database.

NOTE : This applicable only for 10g and 11.1 database release.
Starting 11.2.0.1 database release the database is not put into quiesce mode anymore.  However when dropping the repository with emca or repManager for certain 11.2.0.x versions (eg. 11.2.0.2) this warning will be displayed:


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.