Drop Enterprise Manager repository manually

Drop Enterprise Manager repository manually

Logon SQLPLUS SYS user and follow the following instructions.

EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
 EXEC sysman.setEMUserContext('',5);
DROP user sysman cascade;
DROP role MGMT_USER;
DROP user MGMT_VIEW cascade;
DROP public synonym MGMT_TARGET_BLACKOUTS;
DROP public synonym SETEMVIEWUSERCONTEXT;

Deconfig the dbcontrol

emca -deconfig dbcontrol db -repos drop

Now the new dbcontrol can be created

 emca -config dbcontrol db -repos create

2 thoughts on “Drop Enterprise Manager repository manually”

  1. Good article Naveed. Also note that the followig command places the database in Quiesce Mode:
    emca -deconfig dbcontrol db -repos drop

    1. Thanks Riaz bhai … always love to see your feedback .. I hope to see you here more often .

      Regards
      Raja M Naveed

Leave a Reply

Your email address will not be published. Required fields are marked *