12c Instance Crashes after Errors ORA-600 [kgskigetelt_subplan] (Doc ID 2120842.1)

Last updated on APRIL 11, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
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 /u001/app/oracle/diag/rdbms/racadev_pri/RACADEV2/trace/RACADEV2_dbrm_23393.trc (incident=63273) (PDBNAME=PDB$SEED):
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Incident details in: /u001/app/oracle/diag/rdbms/racadev_pri/RACADEV2/incident/incdir_63273/RACADEV2_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 /u001/app/oracle/diag/rdbms/racadev_pri/RACADEV2/trace/RACADEV2_dbrm_23393.trc:
ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], []
Tue Mar 01 23:11:07 2016
Errors in file /u001/app/oracle/diag/rdbms/racadev_pri/RACADEV2/trace/RACADEV2_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 /u001/app/oracle/diag/rdbms/racadev_pri/RACADEV2/trace/RACADEV2_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

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