Wednesday, October 27, 2010

How to Drop and Create Oracle EM On MS Windows

Steps used to drop and create Oracle EM on MS Windows:

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)

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:
drop user sysman cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym SETEMVIEWUSERCONTEXT;

6-Rebuild the EM Console using this command from Command Prompt:
EMCA -config dbcontrol db -repos create

1 comment:

mhewedy said...

Nice post, and great blog.

Thanks :)