I have installed oracle 220.127.116.11 Ent edition on windows 2008 R2 64-bit server. Now I am trying to recreate repository for database. I issued command: emca -config dbcontrol db -repos recreate
But it throws error at end as:
SEVERE: Dbcontrol Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode.
I have also tried from dbca but no luck. using dbca i got following error
oracle.sysman.emcp.exception.EMConfigException: The existing database you have specified has Grid Control repository. This operation is not supported.
Kindly help me out.
Looks like you might have an issue has stated in note: 1488154.1
Prerequiested Section 7
. DB Control SYSMAN schema is created in the database as part of the database install. You need to deconfigure it using the following command:
a.) Set the ORACLE_HOME and ORACLE_SID environment variable:
b.) $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop