ORA-600(12333)错误和ORA-600(ttclxx1)错误

数据库频繁出现ORA-12333错误,而且随后还出现了ORA-600错误。
错误信息如下:

Mon Aug 10 12:07:41 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_9069.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [1], [], [], [], []
Mon Aug 10 12:07:43 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_9069.trc:
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [1], [], [], [], []
Mon Aug 10 12:07:46 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_9069.trc:
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [1], [], [], [], []
Mon Aug 10 12:07:49 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_9069.trc:
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [1], [], [], [], []
Mon Aug 10 15:55:00 2009
Thread 1 advanced TO log SEQUENCE 86
CURRENT log# 2 seq# 86 mem# 0: /opt/oracle/oradata/eomsdb/redo02.log
Tue Aug 11 10:07:13 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_16898.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Tue Aug 11 11:18:12 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_18734.trc:
ORA-07445: exception encountered: core dump [0000000101A36FBC] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] []
Wed Aug 12 09:15:17 2009
Thread 1 advanced TO log SEQUENCE 87
CURRENT log# 3 seq# 87 mem# 0: /opt/oracle/oradata/eomsdb/redo03.log
.
.
.
Tue Aug 18 08:17:00 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_14394.trc:
ORA-00600: internal error code, arguments: [ttclxx1], [256], [768], [], [], [], [], []
Tue Aug 18 08:17:01 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_14394.trc:
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-00600: internal error code, arguments: [ttclxx1], [256], [768], [], [], [], [], []
Tue Aug 18 08:17:03 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_14394.trc:
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-00600: internal error code, arguments: [ttclxx1], [256], [768], [], [], [], [], []
Tue Aug 18 08:17:07 2009
Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_14394.trc:
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-07445: exception encountered: core dump [000000010100E8C8] [SIGSEGV] [Address NOT mapped TO object] [0x000000068] [] []
ORA-00600: internal error code, arguments: [ttclxx1], [256], [768], [], [], [], [], []

查询了MOS发现导致ORA-600 12333错误的原因很多,不好确定当前的问题,但是根据随后的ORA-600 ttclxx1找到了导致问题的原因。文档Bug 4577381: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [TTCLXX1], [174], [512], [], []描述的就是这个问题,这个问题指向的基本bug为Bug 4551798: [8/8] PEND: ORA-00600 [12333] ON INSERT WITH LOB。
由于Oracle并没有给出这个bug原因的具体描述,只是说明这个bug与LOB的INSERT语句有关,不过Oracle说明在11g中这个bug会被解决。

This entry was posted in BUG and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *