My Oracle Support Banner

Utlrp.sql Fails with ORA-7445 [kkbortc()+111] when Compiling View SYS.KU$_ATTR_DIM_JOIN_PATH_VIEW (Doc ID 2848213.1)

Last updated on FEBRUARY 09, 2022

Applies to:

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

Symptoms

On 19.13, running utlrp.sql fails with the following error when compiling view SYS.KU$_ATTR_DIM_JOIN_PATH_VIEW:

ORA-07445: exception encountered: core dump [kkbortc()+111] [SIGSEGV] [ADDR:0x20] [PC:0xAE6870F] [Address not mapped to object] []

The error below is returned to the session and the core dump error is reported in the alert log.

ORA-03113: end-of-file on communication channel

 

The incident trace file shows the following current SQL statement for the session:

create or replace force view ku$_attr_dim_join_path_view
 of ku$_attr_dim_join_path_t
  with object identifier (dim_obj#, join_path_id) as
WITH ......

----- Call Stack Trace -----
ksedst1 ksedst dbkedDefDump ksedmp ssexhd sslssSynchHdlr sslsshandler __sighandler
kkbortc kokvptv kkmdrvend kkmdrv kkocpqb qkswcInlineQBC qkswcChkList qkswcDriver
qkswcDriver kkmdrvend kkmdrv opiSem opiprs kksParseChildCursor rpiswu2 kksLoadChild
kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr
ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.