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 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
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], [3], [2], [], [], [], [], [], [], [], [], []
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:
Changes
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.
For example:
The next startup after patch installation of the PDB will fail with ORA-00600 [kpdbeGetSqlPatchCbk: more-sps-than-cnt]
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 |