ORA-20001错误

APPLIES TO: Enterprise Manager for Oracle Database - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2] Information in this document applies to any platform. ***Checked for relevance on 16-Feb-2013*** SYMPTOMS While executing the Enterprise Manager Configuration Assistant (EMCA) command (emca -config dbcontrol db -repos create) to create the DBConsole repository, the following error is reported to the screen:- Do you wish to continue? [yes(Y)/no(N)]: yes <timestamp> oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at <ORACLE_HOME>\cfgtoollogs\emca\<sid>\emca_<timestamp>.log. <timestamp> oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... <timestamp> oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository <timestamp> oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at <ORACLE_HOME>\cfgtoollogs\emca\<sid>\emca_repos_create_<date>.log for more details. <timestamp> oracle.sysman.emcp.EMConfig perform SEVERE: Error creating the repository Refer to the log file at <ORACLE_HOME>\cfgtoollogs\emca\<sid>\emca_<timestamp>.log for more details. Could not complete the configuration. Refer to the log file at <ORACLE_HOME>\cfgtoollogs\emca\<sid>\emca\ emca_<timiestamp>.log for more details in $ORACLE_HOME/cfgtoollogs/emca/<sid>/emca_<timestamp>.log (10.2.X) or $ORACLE_BASE/cfgtoollogs/emca/<sid>/emca_<timestamp>.log (11.x), the following can be seen:- INFO: Creating the EM repository (this may take a while) ... May 25, 2010 2:21:30 PM oracle.sysman.emcp.EMReposConfig createRepository CONFIG: ORA-20001: SYSMAN already exists.. ORA-06512: at line 17 oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists.. ORA-06512: at line 17 SEVERE: Error creating the repository May 25, 2010 2:21:30 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at <ORACLE_HOME>/cfgtoollogs/emca/<sid>/emca_repos_create_<date>.log for more details. emca_repos_create_<date>.log shows DECLARE * ERROR at line 1: ORA-20001: SYSMAN already exists.. ORA-06512: at line 17 CAUSE This is caused by the fact that the DBConsole repository already exists for this database.  This can also sometimes be seen if the dbconsole has been previously dropped (including the repository), but for some reason the SYSMAN account may not have been completely removed as part of the drop process. SOLUTION 1.  Since the repository already exists, it is only necessary to create the configuration files using:- emca -config dbcontrol db and provide answers to the prompts. 2.  Alternatively,  if it is deemed preferrable to create a fresh dbconsole,  the existing dbconsole repository (including sysman schema) needs to be dropped first. To drop the existing repository please follow below steps.  a. Drop the existing repository emca -deconfig dbcontrol db -repos drop For more details Refer Note 278100.1  How To Drop, Create And Recreate DB Control In A 10g Database . Repository can be dropped either using above emca command or manually as explained in <> Note : Above emca -drop command requires the database to be quiesced. This means that, temporarily, no operations are possible on the database and new users cannot login.  Refer  Note 375946.1 Running EMCA Results in Database quiesce And No New Connections or Operations Can Be Performed During the DB Control Repository Creation b. Once the DBconsole repository is dropped run the emca command to create the dbconsole  emca -config dbcontrol db -repos create