EMCA Fails With Error "SEVERE: Error creating the repository" and "ORA-20001: SYSMAN already exists" While Creating DBConsole (Doc ID 549896.1)

Last updated on MAY 03, 2016

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***
Checked for relevance on 17-Jul-2014

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms