Container Database PDB Crashes at Startup with ORA-600 [kpdbeGetSqlPatchCbk: more-sps-than-cnt] (Doc ID 2040639.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

During startup of a Pluggable Databases the database crashed with an Error:

ORA-00600: [kpdbeGetSqlPatchCbk: more-sps-than-cnt], [3], [2], [], [], [], [], [], [], [], [], []


Alert.log will show an entry like:

This instance was first to open pluggable database OHISS02T (container=3)
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:

----- Current SQL Statement for this session (sql_id=a01hp0psv0rrh) -----
alter database open


The stack trace from the trace file will be similar to the following:

... kpdbeGetSqlPatchCbk kpdbSwitch kpdbeXmlVldSqlPatchCbk kpdbeCallVldCbks_int kpdbeCallVldCbks kpdbaOpenSync kpdbaSwitchOpenClose kpdbSwitchRunAsSysCbk rpiswu2...

 

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

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