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: 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的小补丁

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-534839/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-534839/