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
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.
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 -deconfig dbcontrol db -repos drop
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
emca -config dbcontrol db -repos create
|
ORA-20001错误
最新推荐文章于 2023-07-14 23:52:57 发布