ORA-07445: exception encountered: core dump [kksIsNLSEqual()+72] [SIGSEGV] [Address not mapped to ob


这个报错其实跟上一篇的ORA-00600是连在一起的,当时只顾着看600了,等7445再次报出来才发现这也是一个BUG。这个错误的 ML:462440.1,是一个未公开的BUG,BUG ID:4085252。这样的错误也没太多可分析和学习的,转贴下ML的文档玩完吧。[@more@]
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.3.0
This problem can occur on any platform.
Symptoms

The following errors are encountered:

ORA-07445: exception encountered: core dump [kksIsNLSEqual()+72] [SIGSEGV] [Address not
mapped to object] [0x00000003C] [] []
ORA-00600: internal error code, arguments: [729], [96], [space leak], [], [], [], [], []

The call stack from the trace file contains:

killpg kksIsNLSEqual kksauc kksCheckCriteria kksCheckCursor kksSearchChildList kksfbc kkspsc0
kksParseCursor
Cause

The cause of this problem has been identified and verified in unpublished Bug 4085252.

Space leak is the primary cause of this problem.
Solution

Set EVENT 10262 to safely ignore the space leak error:

a. Set the following event in init.ora parameter file. This example disables reporting for space leaks less than 90000 bytes:

event = "10262 trace name context forever, level 90000"

b. Stop and restart the database.

If the level is set to 1, space leak checking is disabled. This is not advised because large memory leaks will be missed.

If the event is set to a value greater than 1, any space leak up to the number specified in the event is ignored.
请使用浏览器的分享功能分享到微信等