ORA-21780、ORA-4030、ORA-600(keltenq)、SMG-3000、SMG-3503错误

客户Oracle 10.2.0.1数据库告警日志出现大量的ORA-21780错误,并包含SMG-3000SMG-3503信息,紧接着出现了ORA-4030ORA-600(keltenq)错误。

[@more@]

错误信息如下:

Mon Aug 17 10:37:48 2009
ORA-21780 encountered when generating server alert SMG-3000
Mon Aug 17 10:38:27 2009
ORA-21780 encountered when generating server alert SMG-3503
Mon Aug 17 10:47:48 2009
ORA-21780 encountered when generating server alert SMG-3000
Mon Aug 17 10:48:42 2009
ORA-21780 encountered when generating server alert SMG-3503
Mon Aug 17 10:57:48 2009
ORA-21780 encountered when generating server alert SMG-3000
ORA-21780 encountered when generating server alert SMG-3503
Mon Aug 17 11:07:48 2009
ORA-21780 encountered when generating server alert SMG-3000
Mon Aug 17 11:08:12 2009
ORA-21780 encountered when generating server alert SMG-3503
Mon Aug 17 11:09:12 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-22], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:10:12 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:11:12 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:14:19 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:17:49 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:17:49 2009
ORA-4030 encountered when generating server alert SMG-3000
Mon Aug 17 11:18:22 2009
ORA-4030 encountered when generating server alert SMG-3503
Mon Aug 17 11:26:37 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:27:49 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:27:50 2009
ORA-4030 encountered when generating server alert SMG-3000
Mon Aug 17 11:28:38 2009
ORA-4030 encountered when generating server alert SMG-3503
Mon Aug 17 11:35:50 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:38:24 2009
Restarting dead background process MMON
MMON started with pid=11, OS id=606440

显然问题直接和ORA-4030错误有关。ORA-600和部分SMG错误都是ORA-4030直接导致的。

根据文档Bug 6061892 - Memory Leak on 'PLS non-lib hp' by recursive PLSQL calls / ORA-4030 AND ORA-21780 [ID 6061892.8]ORA-4030是内存泄漏导致的,当应用删除或重建正在被调用的PL/SQL包、过程和函数时,可能引发这个错误。

这个问题影响的版本包括10.2.0.110.2.0.210.2.0.3Oracle10.2.0.411.1.0.6中解决了这个问题。

请使用浏览器的分享功能分享到微信等