Oracle OEM 重建 - 数据库编程

skipping the repository creation (this would be done for instance if you dropped only the files and left the repository in place):

For DB Control 10.1.x, run the command: /bin/emca -r

For DB Control 10.2.x, run the command: /bin/emca -config dbcontrol db

Option 2. Create the DB Control Repository Objects and Configuration Files

For DB Control 10.1.x, run the command: /bin/emca

For DB Control 10.2.x, run the command: bin/emca -config dbcontrol db -repos create

Warning: this command puts the database in Quiesce Mode.

Please consult thehttps://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=375946.1&blackframe=1Running EMCA Results in Database quiesce And No

New Connections or Operations Can Be Performed During the DB Control Repository Creation

C. Recreate/ReConfig DB Control

Option 1. Recreate the DB Control Configuration Files only (leave Repository intact)

Option 2. Recreate the DB Control Configuration Files and Repository

In 10.2, the EMCA commands can be used to reconfigure the existing installs without removing them first.

Option 1. Recreate the DB Control Configuration Files only (leave Repository intact):

For DB Control 10.2.x, run the command:

/bin/emca -config dbcontrol db

Option 2. Recreate the DB Control Configuration Files and Repository

For DB Control 10.2.x, run the command:/bin/[B]emca -config dbcontrol db -repos recreate

Warning: this command puts the database in Quiesce Mode.

Please consult thehttps://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=375946.1&blackframe=1Running EMCA Results in Database quiesce And No

New Connections or Operations Can Be Performed During the DB Control Repository Creation

For additional information on EMCA commandline options, please see the Oracle Enterprise Manager10gAdvanced Configuration Guide or seehttps://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=330130.1&blackframe=1Overview Of The EMCA Commands Available for DB Control 10.2References

https://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=375946.1&blackframe=1- Problem: Running EMCA Results in Database quiesce And No New Connections or Operations Can Be Performed During the DB Control Repository Creation

https://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=395162.1&blackframe=1- How to manage DB Control 10.2 for RAC Database with emca

https://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=456437.1&blackframe=1- Ora-24005 Error Trying To Drop User Sysman Cascade

附：

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 com

Oracle OEM 重建(四)