12c Instance crash along with ORA-00600: Internal Error Code, Arguments: [qkebCreateColInFro:1], [], (Doc ID 2279533.1)

Last updated on JUNE 22, 2017

Applies to:

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

Symptoms

On : 12.1.0.2 version, XML Database

ORA-00600: internal error code, arguments: [qkebCreateColInFro:1], [], [], [], [], [], [], [], [], [

Getting ORA-00600: internal error code, arguments: [qkebCreateColInFro:1] selecting from a view.

CREATE OR REPLACE FORCE EDITIONABLE VIEW "DQ"."VIEW_PROCESS_SP_XML" ("PROCESS_RUN_ID", "PROFILE_ITEM_NAME", "MEMBER_SELECTION_NUMBER", "MEMBER_SELECTION_NAME", "PROFILE_ITEM_VALUE_VCHAR") AS
  SELECT t.process_run_id,
  pi.profile_name profile_item_name,
  ms.selection_number member_selection_number,
  ms.selection_name member_selection_name,
  pi.profile_value profile_item_value_vchar
  FROM dq_process_sp_xml t,
  XMLTABLE ('//SchemeProfile/MemberSelections'
PASSING t.sp_xml COLUMNS MemberSelections XMLTYPE path 'MemberSelection' ) mss,
  XMLTABLE ('MemberSelection'
PASSING mss.MemberSelections COLUMNS selection_number NUMBER(5) path '@number',
selection_name VARCHAR2(30) path '@name',
Pi XMLTYPE path 'ProfileItem' ) ms,
  XMLTABLE ('ProfileItem'
PASSING ms.Pi COLUMNS profile_name VARCHAR2(30) path '@name',
profile_type VARCHAR2(30) path '@type',
profile_value VARCHAR2(1000) path '.' ) pi
  ORDER BY 1,2,3;


SQL> select * from dq.view_process_sp_xml;
select * from dq.view_process_sp_xml
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qkebCreateColInFro:1], [], [], [],[], [], [], [], [], [], [], []

ERROR
-----------------------
ORA-00600: internal error code, arguments: [qkebCreateColInFro:1], [], [], [], [], [], [], [], [], [

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