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

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.

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

转载于:http://blog.itpub.net/15747463/viewspace-752046/