ORA-00600 [kkaegen_get_edition_name_2] While Compiling Or Executing Utlrp Script

(Doc ID 2135989.1)

Last updated on APRIL 11, 2017

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

The following error is encountered while while compiling or executing utlrp.sql script:

ORA-00600: internal error code, arguments: [kkaegen_get_edition_name_2], [0], [1], [2053589], [], [], [], [], [], [], [], []

The corresponding trace file shows characteristics like:

*** 2016-05-03 16:55:03.330
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
597b4c520 1298 package body SYS.DBMS_UTILITY
57fe5e480 1 anonymous block
5545ab450 413 package body SYS.UTL_RECOMP
5545ab450 522 package body SYS.UTL_RECOMP
5545ab450 847 package body SYS.UTL_RECOMP

*** 2016-05-03 16:55:03.331

[TOC00005]
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
... kkaegen_get_edition_name_ne kkaegenq_get_edition_name_qcdlcbk qcsSetViewContext_internal kpp_set_resolution_context kpp_parse_alter_summary  prscmd prsdrv kksQuickParse kksLoadParentOnLock kglLoadOnLock kgllkal kglLock kglget ...
............
FFFFFFFF7FFECE30 FFFFFFFF 7FFEC4D1 00000001 2F2A2051 [............/* Q]
FFFFFFFF7FFECE40 534D5120 56414C49 44415449 4F4E202A [SMQ VALIDATION *]
FFFFFFFF7FFECE50 2F20414C 54455220 53554D4D 41525920 [/ ALTER SUMMARY ]
FFFFFFFF7FFECE60 22415050 53222E22 4444525F 525F4F52 ["APPS"."DDR_R_OR]
FFFFFFFF7FFECE70 475F4152 45415F44 4E5F4D56 2220434F [G_AREA_DN_MV" CO]
FFFFFFFF7FFECE80 4D50494C 450007B0 00000000 FFFFFFFF [MPILE...........]

----------------------------------------
SO: 0x57c48f6a8, type: 96, owner: 0x5b08ef388, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x5b07a7020, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:9220 ID:, pg=0 conuid=0
..........
LibraryHandle: Address=549fa2178 Hash=7a339288 LockMode=N PinMode=0 LoadLockMode=X Status=0
ObjectName: Name=/* QSMQ VALIDATION */ ALTER SUMMARY "APPS"."DDR_R_ORG_AREA_DN_MV" COMPILE
.......
----- Bind Info (kkscoacd) -----
Bind#0
oacdty=01 mxl=128(128) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=01 siz=128 off=0
kxsbbbfp=ffffffff7b2f3238 bln=128 avl=04 flg=09
value="APPS"
Bind#1
oacdty=01 mxl=128(128) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=01 siz=128 off=0
kxsbbbfp=ffffffff7b2f32e8 bln=128 avl=20 flg=09
value="DDR_R_ORG_AREA_DN_MV"
Bind#2
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=ffffffff7b2f3388 bln=22 avl=02 flg=09
value=19
Bind#3
oacdty=01 mxl=128(128) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=01 siz=128 off=0
kxsbbbfp=ffffffff7c068770 bln=128 avl=00 flg=09

 

Changes

If the evaluation edition of a materialized view was dropped, future uses of the view could result in ORA-600 [KKAEGEN_GET_EDITION_NAME_2].

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