Jun 10
Do the following steps to recreate the database control which don’t place the database in quiesce state:
Make sure that the database and the listener is up and running.
1. Logon SQLPLUS as user SYS and drop the sysman account and mangement objects:
a. drop user sysman cascade;
b. drop role MGMT_USER;
c. drop user MGMT_VIEW cascade;
d. drop all public synonyms referencing SYSMAN tables
(select ‘drop public synonym ‘||synonym_name||’;’ from dba_synonyms where table_owner = ‘SYSMAN’)
2. Manually remove the following folders:
ORACLE_HOME/host_sid/
ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_host_sid
3.Set the ORACLE_HOME and ORACLE_SID
From $ORACLE_HOME/bin issue the following command:
emca -config dbcontrol db -repos create
