1 Reply Latest reply: Mar 1, 2013 11:16 AM by 992802 RSS

    emca recreate repository error

      HI All,

      I have installed oracle 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.

        • 1. Re: emca recreate repository error
          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:

          For example:-
          export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
          export ORACLE_SID=orcl

          b.) $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop