My Oracle Support Banner

Instance termination after ORA-00600: [16614], ORA-00600: [kghbigasp:ds] ORA-00600: [kghfrh:ds] (Doc ID 464830.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 16-FEB-2010***
***Checked for relevance on 24-OCT-2012***

Symptoms

ALTER TABLE <table_name> EXCHANGE PARTITION causes the following errors which finally causes instance termination:

a) ORA-00600: [16614]
b) ORA-00600: [kghbigasp:ds]
c) ORA-00600: [kghfrh:ds]

ALERT LOG --------- 
Wed Oct 3 23:09:50 2007 
Errors in file /opt/oracle/svprd1b/db/admin/udump/svprd1b1_ora_19796.trc: 
ORA-00600: internal error code, arguments: [kghbigasp:ds], [0xC000000892535880], [], [], [], [], [], [] 
Wed Oct 3 23:09:52 2007 
Trace dumping is performing id=[cdmp_20071003230952] 
Wed Oct 3 23:09:52 2007 
Errors in file /opt/oracle/svprd1b/db/admin/udump/svprd1b1_ora_19796.trc: 
ORA-00603: ORACLE server session terminated by fatal error 
ORA-00600: internal error code, arguments: [kghbigasp:ds], [0xC000000892535880], [], [], [], [], [], [] 
Wed Oct 3 23:10:53 2007 
Errors in file /opt/oracle/svprd1b/db/admin/bdump/svprd1b1_pmon_28346.trc: 
OORA-00600: internal error code, arguments: [kghfrh:ds], [0xC000000892535880], [], [], [], [], [], [] 
Wed Oct 3 23:10:54 2007 
Errors in file /opt/oracle/svprd1b/db/admin/bdump/svprd1b1_pmon_28346.trc: 
ORA-00600: internal error code, arguments: [kghfrh:ds], [0xC000000892535880], [], [], [], [], [], [] 
Wed Oct 3 23:10:54 2007 
PMON: terminating instance due to error 472 
TRACE FILE ---------- The traces confirm the following functions on the call stack: 
a) ORA-00600 [16614] 
   Call Stack Trace 
   ~~~~~~~~~~~~~~~~ 
   kglsupd kqlsupd atbunvc_upd_nvld_constrs atbFMexchange atbdrv ... 
       
b) ORA-00600: [kghbigasp:ds] 
    
   Call Stack Trace 
   ----------------- 
   kghbigasp kghasp kglpndl kssdct ktcrcm ktdcmt k2lcom k2send xctctl ... 
    
c) ORA-00600: [kghfrh:ds]
   Call Stack Trace 
   ~~~~~~~~~~~~~~~~ 
   kghfrh kgldafr kglobfr kglpndl kssxdl kssdch_stage kssdch ktcdso ... 
 
@ @ For internal Support usage: @ --------------------------- @ The ORA-600 [kghbigasp:ds] traces confirm a heap corruption on @ heap "partitioning d": @ @ ***** Internal heap ERROR kghbigasp:ds addr=c000000892535880 ds=c0000008c568f898 ***** @ ***** Dump of memory around addr c000000892535880:  @ ... @ HEAP DUMP heap name="partitioning d"  desc=c0000008c568f898 @  extent sz=0x440 alt=32767 het=32 rec=0 flg=2 opc=5 @  parent=c000000840000030 owner=c0000008c568f700 nex=0000000000000000 xsz=0x1068 @ ... @ EXTENT 601 addr=c000000892535880 @ ERROR extent at c000000892535880 contains wrong ds c0010008c568f898 @ ***** Dump of memory around addr c000000892535880:  @ ... @ C000000892535880 C0010008 C568F898 C0000008 92535CD8  [.....h.......S\.] @ C000000892535890 50B38F00 00000431 00000000 00000000  [P......1........] @

Changes

This occurs when one or both tables involved in the exchange have novalidated constraints defined and the following command is executed:

ALTER TABLE <table_name> 
EXCHANGE PARTITION <partition_name> WITH TABLE <table_name> 
INCLUDING INDEXES WITHOUT VALIDATION UPDATE GLOBAL INDEXES; 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.