Posts

Showing posts from October, 2011

Rebuild Oracle EM

A. On both nodes stop dbconsole emctl stop dbconsole B. Drop DBConsole manaully Step 1: Drop AQ related objects in the SYSMAN schema Logon SQLPLUS as user. Bypass any errorSYSMAN SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'MGMT_NOTIFY_QTABLE',force =>TRUE); Step 1:Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects: SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force =>TRUE); SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs; SQL> EXEC sysman.setEMUserContext('',5); SQL> REVOKE dba FROM sysman; SQL> DECLARE CURSOR c1 IS SELECT owner, synonym_name name FROM dba_synonyms WHERE table_owner = 'SYSMAN'; BEGIN FOR r1 IN c1 LOOPIF r1.owner = 'PUBLIC' THEN EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM 'r1.name; ELSE EXECUTE IMMEDIATE 'DROP SYNONYM 'r1.owner'.'r1.name; END IF; END LOOP; END;/ SQL> DROP USER mgmt_view CASCADE; S