Container Database PDB Crashes at Startup with ORA-600 [kpdbeGetSqlPatchCbk: more-sps-than-cnt]
(Doc ID 2040639.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
During startup of a Pluggable Databases the database crashed with an Error:
Alert.log will show an entry like:
Database Characterset for OHISS02T is AL32UTF8
Errors in file /u01/app/oracle/diag/rdbms/chiss02t/CHISS02T1/trace/CHISS02T1_ora_71796.trc (incident=136417) (PDBNAME=CDB$ROOT):
ORA-00600: interne foutcode, argumenten: [kpdbeGetSqlPatchCbk: more-sps-than-cnt], , , , , , , , , , , 
Incident details in: /u01/app/oracle/diag/rdbms/chiss02t/CHISS02T1/incident/incdir_136417/CHISS02T1_ora_71796_i136417.trc
From the trace file, it is seen that the SQL being executed is:
alter database open
The stack trace from the trace file will be similar to the following:
The issue can be related to a previous online installation of a patch with ' -force ' option, which leads to a double entry in object registry$sqlpatch.
The next startup after patch installation of the PDB will fail with ORA-00600 [kpdbeGetSqlPatchCbk: more-sps-than-cnt]
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