MMON进程引起的ORA-01000报错

hcn

OS：AIX 5.3
DB : 10.2.0.1.0 (RAC)

今天查看告警日志发现大量的：

1. Fri Feb 15 15:32:06 2013
   
2. Errors in file /oracle/admin/pmos/bdump/pmos1_mmon_1233000.trc:
   
3. ORA-01000: maximum open cursors exceeded
   
4. Fri Feb 15 15:32:06 2013
   
5. Errors in file /oracle/admin/pmos/bdump/pmos1_mmon_1233000.trc:
   
6. ORA-01000: maximum open cursors exceeded
   
7. Fri Feb 15 15:37:09 2013
   
8. Errors in file /oracle/admin/pmos/bdump/pmos1_mmon_1233000.trc:
   
9. ORA-01000: maximum open cursors exceeded
   
10. Fri Feb 15 15:37:09 2013
    
11. Errors in file /oracle/admin/pmos/bdump/pmos1_mmon_1233000.trc:
    
12. ORA-01000: maximum open cursors exceeded
    

复制代码

查看pmos1_mmon_1233000.trc文件，内容如下：

1. *** 2013-02-04 12:21:29.474
   
2. Checking RLB queue status failed. ORA-01000: maximum open cursors exceeded
   
3. Error executing stmt : CREATE type SYS$RLBTYP as object (srv VARCHAR2(1024), payload VARCHAR2(2048))
   
4. RLB SQL failed. ORA-01000: maximum open cursors exceeded
   
5. *** 2013-02-04 12:21:29.474
   
6. ksedmp: internal or fatal error
   
7. ORA-01000: maximum open cursors exceeded
   
8. *** 2013-02-04 12:21:29.474
   
9. ksedmp: internal or fatal error
   
10. ORA-01000: maximum open cursors exceeded
    
11. *** 2013-02-04 12:26:20.486
    
12. MMON encountered error 1000, clearing the error
    
13. MMON encountered error 1000, clearing the error
    
14. Checking RLB queue status failed. ORA-01000: maximum open cursors exceeded
    
15. Error executing stmt : CREATE type SYS$RLBTYP as object (srv VARCHAR2(1024), payload VARCHAR2(2048))
    
16. RLB SQL failed. ORA-01000: maximum open cursors exceeded
    
17. *** 2013-02-04 12:26:29.495
    
18. ksedmp: internal or fatal error
    
19. ORA-01000: maximum open cursors exceeded
    
20. *** 2013-02-04 12:26:29.495
    
21. ksedmp: internal or fatal error
    
22. ORA-01000: maximum open cursors exceeded
    
23. *** 2013-02-04 12:31:29.519
    
24. Checking RLB queue status failed. ORA-01000: maximum open cursors exceeded
    
25. Error executing stmt : CREATE type SYS$RLBTYP as object (srv VARCHAR2(1024), payload VARCHAR2(2048))
    
26. RLB SQL failed. ORA-01000: maximum open cursors exceeded
    
27. *** 2013-02-04 12:31:29.519
    
28. ksedmp: internal or fatal error
    
29. ORA-01000: maximum open cursors exceeded
    
30. *** 2013-02-04 12:31:29.519
    
31. ksedmp: internal or fatal error
    
32. ORA-01000: maximum open cursors exceeded

复制代码

初步推断是无效对象引起，但是无法最终定位，希望找到真正的原因，来确定解决方案，具体的trc等内容请查看附件，
已经通过刘大的Script:Diagnostic ORA-01000 maximum open cursors exceeded 脚本收集了部分信息，请各位帮忙看看，
谢谢