Drop/Create Oracle Enterprise Manager

Drop/Create Oracle Enterprise Manager


1. make sure the DB Console service is stopped. If not, try to stop it.

2. Delete the service:
sc delete <service_name>

- where <service_name> is the DB Control service name (typically:
OracleDBConsole<sid>)

3. Check if the service is deleted now. If not, reboot the whole server

4. Remove the following directories from your filesystem:
<ORACLE_HOME>/<hostname_sid>
<ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>

5. Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects:
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;

6. Rebuild the EM Console: emca -config dbcontrol db -repos create