ORA-600 [KGHALO4], [0x388c3e060], [] in 10.2.0.1 [ID 340976.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.1 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

Alert log is showing errors:

ORA-00600: internal error code, arguments: [KGHALO4], [0x388C3E060], [], [], [], [], [], []

The stack trace contains:

ksedmp <- kgerinv <- kgesinv <- kgesin <- kghalo <- ksmasgn <- kghnospc <- kghalo <- ksmdacnk <- ksmdget <- kssadpm <- kjlalc <- kjxnrl <- kjxrri <- kjmxmpm <- kjmpmsgi <- kjmdm <- ksbrdp <- opirip <- opidrv <- sou2o <- opimai_real <- main <- start


And, in some cases, the instance will terminate.


Cause

This is due to internal bug 4676509, which was closed as a duplicate of internal bug 4414666.

ORA-600 [KGHALO4] can occur on a NUMA machine with ksmasgn in the call stack. 

This bug is fixed in the 10.2.0.2 and higher releases.

Solution

1.  Upgrade to 10.2.0.2 or higher.

OR

2.  If available for your platform. and version, download and apply Patch:4414666

OR

3.  Use one of the workarounds available:

a. Disable the NUMA optimization.

  • set the _enable_NUMA_optimization=FALSE parameter in the init/spfile 
    If an ASM instance, two parameters are needed: 
    _enable_NUMA_optimization = FALSE 
    _disable_instance_params_check = TRUE
  • restart the instance.

or 

b. Increase the shared_pool_size parameter to a larger size.

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