EMCA dbconsole configuration failed with ORA-20001: SYSMAN already exists

Error Description: While creating the dbconsole repository using the command “emca -repos create” getting failed with CONFIG: ORA-20001: SYSMAN already exists
INFO: Creating the EM repository (this may take a while) ...
Jun 22, 2011 8:44:58 PM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: ORA-20001: SYSMAN already exists..
ORA-06512: at line 17
Problem Description: SYSMAN is the user for the dbconsole user and it is already present in your database. During the repository creation the SYSMAN user gets created. The reason could be because of your database is cloned from another database which is having the dbconsole configured already. The same configurations from the source database will not work in the target database. The second reason might be the dbconsole repository is already created in your database. You have to configure the dbconsole from the created repository.
How to drop emca existing repository?
$ emca -deconfig dbcontrol db -repos drop

How to create new repository?
$ emca -repos create

How to Configure the Grid control manually?
$ emca -config dbcontrol db
DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google