11g Reconstruction EM report Ora-20001:sysman already exists

Today after installing the 11g (11.1.0.7.0) database, the error is created by manually creating EM with the Emca-config dbcontrol db-repos create command, and the following errors are found after viewing the log

config:spooling to C:\app\Administrator\cfgtoollogs\emca\orcl\emca_repos_create_2009_01_16_06_44_13.log
Jan, 6:44:13 AM oracle.sysman.emcp.EMReposConfig createrepository
info:creating the EM repository ( this is a while) ...
Jan, 6:44:13 AM oracle.sysman.emcp.EMReposConfig createrepository
Config:ora-20001:sysman already exists.
Ora-06512:at Line

Oracle.sysman.assistants.util.sqlengine.sqlfatalerrorexception:ora-20001:sysman already exists.
Ora-06512:at Line

Atoracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl (sqlengine.java:1530)
At Oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript (sqlengine.java:880)
atoracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript (sqlplusengine.java:270)
atoracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript (sqlplusengine.java:311)
atoracle.sysman.emcp.EMReposConfig.createRepository (emreposconfig.java:492)
Atoracle.sysman.emcp.EMReposConfig.invoke (emreposconfig.java:218)
Atoracle.sysman.emcp.EMReposConfig.invoke (emreposconfig.java:147)
atoracle.sysman.emcp.EMConfig.perform (emconfig.java:222)
Atoracle.sysman.emcp.EMConfigAssistant.invokeEMCA (emconfigassistant.java:535)
atoracle.sysman.emcp.EMConfigAssistant.performConfiguration (emconfigassistant.java:1215)
Atoracle.sysman.emcp.EMConfigAssistant.statusMain (emconfigassistant.java:519)
Atoracle.sysman.emcp.EMConfigAssistant.main (emconfigassistant.java:468)
Jan, 6:44:13 AM oracle.sysman.emcp.EMReposConfig invoke
Severe:error Creating the repository
Jan, 6:44:13 AM oracle.sysman.emcp.EMReposConfig invoke
Info:refer to the log file Atc:\app\administrator\cfgtoollogs\emca\orcl\emca_repos_create_.log for moredetails.
Jan, 6:44:13 AM oracle.sysman.emcp.EMConfig perform
Severe:error Creating the repository
Refer to the log file Atc:\app\administrator\cfgtoollogs\emca\orcl\emca_2009_01_16_06_43_53.log formore details.
Jan, 6:44:13 AM oracle.sysman.emcp.EMConfig perform
config:stack Trace:
Oracle.sysman.emcp.exception.EMConfigException:Error Creating the repository
Atoracle.sysman.emcp.EMReposConfig.invoke (emreposconfig.java:230)
Atoracle.sysman.emcp.EMReposConfig.invoke (emreposconfig.java:147)
At oracle.sysman.emcp.EMConfig.perform (emconfig.java:222)
Atoracle.sysman.emcp.EMConfigAssistant.invokeEMCA (emconfigassistant.java:535)
atoracle.sysman.emcp.EMConfigAssistant.performConfiguration (emconfigassistant.java:1215)
At Oracle.sysman.emcp.EMConfigAssistant.statusMain (emconfigassistant.java:519)
Atoracle.sysman.emcp.EMConfigAssistant.main (emconfigassistant.java:468)

After the colleague reminds, just know oneself made a very stupid mistake, before manually create EM, need to remove the EM configuration information:

Here's how:

0, the administrator mode to start cmd. Note It must be an administrator, or the subsequent move file operation may cause a failure.

1. Use the Emca-deconfigdbcontrol DB command to remove the configuration

2. Delete Repository using Emca-repos drop

3. Create a database Control using Emca-config dbcontroldb-repos.

The above operation, also applies to 10g. After the configuration is successful, there will be a hint of the content.

Summarize:

This error, to view the log file specific records: such as the log file in E:\FILES\ORACLE\CFGTOOLLOGS\EMCA\ORCL

Emca_2016_10_22_11_29_55.log

You can see something similar to the following:

The above error is indicated as follows:

As long as the error in the log prompt, you can find the root cause of the problem, rather than according to the online keyword search results, to modify the configuration, the result is self-defeating instead of wasting a lot of time.

Reference articles

11g Reconstruction EM report Ora-20001:sysman already exists

11g Reconstruction EM report Ora-20001:sysman already exists