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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms