12c Instance Crashes after Errors ORA-600 [kgskigetelt_subplan]
(Doc ID 2120842.1)
Last updated on AUGUST 25, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
After opening the newly created CDB, the instance crashes with repeating ORA-00600:[kgskigetelt_subplan] like:
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_dbrm_23393.trc (incident=63273) (PDBNAME=PDB$SEED):
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_63273/<instname>_dbrm_23393_i63273.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Mar 01 23:11:07 2016
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_dbrm_23393.trc:
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Tue Mar 01 23:11:07 2016
Errors in file<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_dbrm_23393.trc:
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Tue Mar 01 23:11:07 2016
USER (ospid: 23393): terminating the instance due to error 56710
Tue Mar 01 23:11:07 2016
System state dump requested by (instance=2, osid=23393 (DBRM)), summary=[abnormal instance termination].
System State dumped to trace file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_diag_23389_20160301231107.trc
Tue Mar 01 23:11:08 2016
Dumping diagnostic data in directory=[cdmp_20160301231107], requested by (instance=2, osid=23393 (DBRM)), summary=[abnormal instance termination].
Tue Mar 01 23:11:08 2016
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_63273/<instname>_dbrm_23393_i63273.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Mar 01 23:11:07 2016
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_dbrm_23393.trc:
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Tue Mar 01 23:11:07 2016
Errors in file<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_dbrm_23393.trc:
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Tue Mar 01 23:11:07 2016
USER (ospid: 23393): terminating the instance due to error 56710
Tue Mar 01 23:11:07 2016
System state dump requested by (instance=2, osid=23393 (DBRM)), summary=[abnormal instance termination].
System State dumped to trace file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_diag_23389_20160301231107.trc
Tue Mar 01 23:11:08 2016
Dumping diagnostic data in directory=[cdmp_20160301231107], requested by (instance=2, osid=23393 (DBRM)), summary=[abnormal instance termination].
Tue Mar 01 23:11:08 2016
The call stack from the trace file shows functions like:
... kgskigetelt kskgetpdbplanshelper kpdbSwitch kskgetpdbplans kgskigetelt_cdb kgskirefpl kskirefplhelper kskswitchpdbhelper kskswitchpdb kskirefpl kskreload kskswitchpdbhelper kskswitchpdb kskirefrplan ksktopplmodint kskswitchpdbhelper kskswitchpdb kskdbrmpa ksbabs ksbrdp ...
Changes
New installation of 12c where the database was created manually instead of using DBCA.
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 |