RE: Trying to recreate OEM repository

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

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_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Sweetser, Joe
> Sent: Tuesday, November 14, 2006 3:27 PM
> To: oracle-l_at_freelists.org
> 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>
> --
> http://www.freelists.org/webpage/oracle-l
>

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

Received on Tue Nov 14 2006 - 16:39:49 CST