Trying to recreate OEM repository

From: Sweetser, Joe <Joe.Sweetser_at_infocrossing.com>
Date: Tue, 14 Nov 2006 15:26:54 -0700
Message-ID: <5CF4A34EE1FEA144B7474DC97E2F73A90165FCCC@MAPI.iconnection.com>

Oracle 10.2.0.2.0 64-bit
Windows Server 2003 R2 Enterprise x64 Edition SP 1

I am following the steps in Metalink Note:2781001.1 to drop and recreate the DB Control Repository and am receiving the below error(s).

Any/all ideas much appreciated as Metalink/Google have yet to reveal the answer.

Thanks,
-joe

SQL> exec sysman.emd_maintenance.remove_em_dbms_jobs;

PL/SQL procedure successfully completed.

SQL> exec sysman.setEMUserContext('',5);

PL/SQL procedure successfully completed.

SQL> revoke dba from sysman;

Revoke succeeded.

SQL> @f:\oraadmin\remove-sysman-syns.sql

PL/SQL procedure successfully completed.

SQL> drop user mgmt_view cascade;

User dropped.

SQL> drop role mgmt_user;
drop role mgmt_user

          *
ERROR at line 1:
ORA-01919: role 'MGMT_USER' does not exist

SQL> desc dba_roles

 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------

 ROLE                                      NOT NULL VARCHAR2(30)
 PASSWORD_REQUIRED                                  VARCHAR2(8)

SQL> select role from dba_roles where role like 'M%';

no rows selected

SQL> drop user sysman cascade;
drop user sysman cascade
*

ERROR at line 1:
ORA-24008: queue table SYSMAN.MGMT_NOTIFY_QTABLE must be dropped first

SQL> drop table SYSMAN.MGMT_NOTIFY_QTABLE; drop table SYSMAN.MGMT_NOTIFY_QTABLE

                  *

ERROR at line 1:
ORA-00942: table or view does not exist

SQL> exec dbms_aqadm.drop_queue_table (queue_table => 'SYSMAN.MGMT_NOTIFY_QTABLE', force => TRUE); BEGIN dbms_aqadm.drop_queue_table (queue_table => 'SYSMAN.MGMT_NOTIFY_QTABLE', force => TRUE); END;

*

ERROR at line 1:

ORA-24010: QUEUE SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_E does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4096
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1

SQL> select owner||' - '||name||' - '||queue_table from dba_queues where owner='SYSMAN';

OWNER||'-'||NAME||'-'||QUEUE_TABLE

---

SYSMAN - MGMT_NOTIFY_Q - MGMT_NOTIFY_QTABLE SYSMAN - AQ$_MGMT_NOTIFY_QTABLE_E - MGMT_NOTIFY_QTABLE 2 rows selected.

SQL>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 14 2006 - 16:26:54 CST