ORA-600[KKDLREADONDISKDEFVAL:ERROR][1403] On 11.1.0.6 (Doc ID 1075762.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Nov-2013***

Symptoms

This problem was observed on Oracle 11.1.0.6 32-bit on a Windows 32-bit server

The problem occurred when running Siebel, and getting intermittent errors in the alert log.

Thu Mar 11 22:01:50 2010
ORA-00600: internal error code, arguments: [kkdlReadOnDiskDefVal: error], [1403], [], [], [], [], [], []




The trace file shows a failing statement as follows:
/* SQL Analyze(85,1) */ SELECT /*+ ALL_ROWS */ . . . . . . .

The function stack:

dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv <- kgeasnmierr
kkdlReadOnDiskDefVal kkdlGetOnDiskDefVal kkdlgkcc kkdlgcn qkshtTabResolveIndSpec
VInfreq__qksbgRefresh <- PGOSF530__qkshtTabSetIndexNames <- PGOSF533__qksqbApplyToFroCbk <-

the important pieces of the stack are: kkdlGetOnDiskDefVal  kkdlgkcc




The PL/SQL call stack may have similar packages to these
3CBF1FB8 7101 package body SYS.DBMS_SQLTUNE_INTERNAL
39DD8D18 8 SYS.WRI$_ADV_SQLTUNE
7959BA18 570 package body SYS.PRVT_ADVISOR
7959BA18 2236 package body SYS.PRVT_ADVISOR
4231C01C 241 package body SYS.DBMS_ADVISOR
39E13FCC 643 package body SYS.DBMS_SQLTUNE
10963E20 4 anonymous block



Changes

Upgraded to 11.1.0.6

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