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 APRIL 17, 2023

Applies to:

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

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