A little more info about this...as you can see the queue table does not exist. Hmmmm. SQL> select owner||' - '||queue_table from dba_queue_tables order by owner; OWNER||'-'||QUEUE_TABLE --------------------------------------------------------------- SYS - ALERT_QT SYS - AQ$_MEM_MC SYS - AQ_EVENT_TABLE SYS - AQ_SRVNTFN_TABLE SYS - KUPC$DATAPUMP_QUETAB SYS - SCHEDULER$_EVENT_QTAB SYS - SYS$SERVICE_METRICS_TAB SYS - SCHEDULER$_JOBQTAB SYSTEM - DEF$_AQERROR SYSTEM - DEF$_AQCALL WMSYS - WM$EVENT_QUEUE_TABLE 11 rows selected. SQL> > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Sweetser, Joe > Sent: Tuesday, November 14, 2006 3:27 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Trying to recreate OEM repository > > 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> > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l