*** 2012-05-03 07:32:19.298
Checking RLB queue status failed. ORA-01000: maximum open cursors exceeded
Error executing stmt : CREATE type SYS$RLBTYP as object (srv VARCHAR2(1024), payload VARCHAR2(2048))
RLB SQL failed. ORA-01000: maximum open cursors exceeded
通过：
select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current';
发现是MMON进程产生的这一问题.
Checking RLB queue status failed. ORA-04063: view "SYS.DBA_QUEUES" has errors
Error executing stmt : BEGIN DBMS_AQADM.CREATE_QUEUE_TABLE('SYS$SERVICE_METRICS_TAB', 'SYS$RLBTYP', 'tablespace sysaux, storage (INITIAL 1M next 1M pctincrease 0)', NULL, TRUE); END;
RLB SQL failed. ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 58
ORA-06512: at line 1
04/28/12 09:16:09 >ERROR: exception at dbms_ha_alerts_prvt.post_instance_up308: SQLCODE -13917,ORA-13917: Posting system
alert with reason_id 135 failed with code [5] [post_error]
04/28/12 09:16:09 >ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources637: SQLCODE -13917,ORA-13917: Posting syst
em alert with reason_id 136 failed with code [5] [post_error]
04/28/12 09:16:09 >parameter dump for dbms_ha_alerts_prvt.check_ha_resources
04/28/12 09:16:09 > - local_db_unique_name (racdb)
04/28/12 09:16:09 > - local_db_domain (==N/A==)
04/28/12 09:16:09 > - rows deleted (0)
04/28/12 09:16:09 >ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources637: SQLCODE -13917,ORA-13917: Posting syst
em alert with reason_id 136 failed with code [5] [post_error]
04/28/12 09:16:09 >parameter dump for dbms_ha_alerts_prvt.check_ha_resources
04/28/12 09:16:09 > - local_db_unique_name (racdb)
04/28/12 09:16:09 > - local_db_domain (==N/A==)
04/28/12 09:16:09 > - rows deleted (0)
不知该如何处理？