ORA-00600: [KGHALO4], [0xC00000006C59D058], [], [], [], [], [], []

今天在客户巡检rac数据库一个节点时,发现alert.log日志中出现以下错误
版本是hu-unix ia64 9.2.0.6 rac
Tue Dec 30 18:08:06 2008Errors in file /opt/app/oracle/admin/gzgov/udump/gzgov2_ora_5401.trc:
ORA-00600: internal error code, arguments: [KGHALO4], [0xC00000006C59D058], [], [], [], [], [], []

但是前面应用都没反应说出现什么问题,看trace文件 也是看不懂,
$ more /opt/app/oracle/admin/gzgov/udump/gzgov2_ora_5401.trc
/opt/app/oracle/admin/gzgov/udump/gzgov2_ora_5401.trc
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /opt/app/oracle/product/9.2.0/portal
System name: HP-UX
Node name: dbsrv2
Release: B.11.23
Version: U
Machine: ia64
Instance name: gzgov2
Redo thread mounted by this instance: 2
Oracle process number: 193
Unix process pid: 5401, image: mailto:oracle@dbsrv2]oracle@dbsrv2 (TNS V1-V3)
*** 2008-12-30 18:07:51.528
*** SESSION ID:(249.31089) 2008-12-30 18:07:51.519
********** Internal heap ERROR KGHALO4 addr=c00000006c59d058 *********
***** Dump of memory around addr c00000006c59d058:
通过查询metalink,发现是bug
主题: Bug 3949307 - SGA memory corruption / OERI:KGHALO4 with high concurrency
文档 ID: 3949307.8 类型: PATCH
上次修订日期: 24-SEP-2008 状态: PUBLISHED
Bug 3949307 SGA memory corruption / OERI:KGHALO4 with high concurrency
This note gives a brief overview of bug 3949307.
The content was last updated on: 10-MAY-2005
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 9.2.0.6 but < 10.1.0.2 Versions confirmed as being affected 9.2.0.6 Platforms affected Generic (all / most platforms affected) It is believed to be a regression in default behaviour thus: Regression introduced in 9.2.0.6 Fixed: This issue is fixed in 9.2.0.7 (Server Patch Set) Symptoms: Related To: Internal Error May Occur (ORA-600) Memory Corruption ORA-600 [510] ORA-600 [KGHALO4] ORA-600 [17175] Dump in or under kgldtin / kglhdgc (None Specified) Description This problem is introduced in 9.2.0.6 by the fix for bug 3749490. Various internal errors and SGA memory corruption can occur in a heavily concurrent system due to internal mis-use of a latch cleanup structure. Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice. References Bug 3949307 (This link will only work for PUBLISHED bugs) Note 245840.1 Information on the sections in this article 下面是ORA-600 [kghalo4] 的详细解释 主题: ORA-600 [kghalo4] 文档 ID: 273721.1 类型: REFERENCE 上次修订日期: 15-SEP-2008 状态: PUBLISHED Note: For additional ORA-600 related information please read Note 146580.1 PURPOSE: This article discusses the internal error "ORA-600 [KGHALO4]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [kghalo4] [a] VERSIONS: versions 9.2 to 10.1 DESCRIPTION: The recovery location must be nulled by the client. We are trying to allocate memory from the Shared Pool and the caller has not passed a pointer whose value is null. ARGUMENTS: Arg [a] Memory pointer FUNCTIONALITY: Heap Manager IMPACT: PROCESS FAILURE MEMORY CORRUPTION NON CORRUPTIVE - No underlying data corruption. SUGGESTIONS: There may well be additional ORA-600 errors reported along with this one. See if the problem will reproduce, many are one time occurrences. Check all memory hardware and operating system logs for any additional errors. If the Known Issues section below does not help in terms of identifying a solution, please submit the trace files and alert.log to Oracle Support Services for further analysis. Known Issues: Bug# 5736850 See Note 5736850.8 SGA corruption / crash from PQO bloom filter Fixed: 10.2.0.4, 11.1.0.6 Bug# 5631836 See Note 5631836.8 OERI[kghalo4] can occur Fixed: 10.2.0.4, 11.1.0.6 Bug# 5345999 See Note 5345999.8 Dump / OERI accessing V$SPPARAMETER Fixed: 10.2.0.4, 11.1.0.6 Bug# 4890281 See Note 4890281.8 OERI[KGHALO4] can occur under qesblGetFilter Fixed: 10.2.0.3, 11.1.0.6 Bug# 4414666 See Note 4414666.8 OERI[KGHALO4] can occur on NUMA Fixed: 10.2.0.2, 11.1.0.6 Bug# 3949307 See Note 3949307.8 SGA memory corruption / OERI:KGHALO4 with high concurrency Fixed: 9.2.0.7 建议是检查内存硬件和操作系统日志,然后再继续观察这个错误是否经常出现 这个补丁造成的影响是进程失败,内存错误,但是对数据不会有任何影响 和打3949307的小补丁