Instance termination after ORA-00600: [16614], ORA-00600: [kghbigasp:ds] ORA-00600: [kghfrh:ds]
(Doc ID 464830.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]Information in this document applies to any platform.
*** ***
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 ...
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 |