Refresh Mview, UTLRP, UTL_RCOMPILE FAIL With ORA 7445 [qsmqbtss_build_table_subordsets] (Doc ID 2811792.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 ORA-07445: Exception occurred: CORE Dump [qsmqbtss_build_table_subordsets()+1068] [SIGSEGV] [ADDR:0x30] [PC:0xC4A85BC] [Address not mapped to object] []
 

...
----- Current SQL Statement for this session (sql_id=797jbm6hk093a) -----
/* QSMQ VALIDATION */ ALTER SUMMARY "<<<OWNER>>&parent=EXTERNAL_SEARCH" rel="nofollow" ."<<<MVIEW NAME>>>" COMPILE

...
  object line object
  handle number name
0x8239e488 1329 package body SYS.DBMS_UTILITY.VALIDATE
0x7243f170 1 anonymous block
0x865f2808 433 package body SYS.UTL_RECOMP.ALTER_COMPILE
0x865f2808 562 package body SYS.UTL_RECOMP.SEQ_SLAVE
0x865f2808 898 package body SYS.UTL_RECOMP.RECOMP_PARALLEL
0x865f2808 940 package body SYS.UTL_RECOMP.RECOMP_SERIAL
0x8239e488 435 package body SYS.DBMS_UTILITY.COMPILE_SCHEMA
0x6e5fa208 3 procedure BUISY.TMP_COMPILE
0x84735688 1 anonymous block

Error Stack: ORA-7445[qsmqbtss_build_table_subordsets]

Main Stack:
qsmqbtss_build_table_subordsets <- qsmqUpdateOneTableSubSet
<- qsmqUpdateTableSubSets <- qsmqcsm <- opiexe <- opiosq0 <- opiodr <- rpidrus <- skgmstack
<- rpidru <- rpiswu2 <- rpidrv <- rpisplu_internal <- qsmqValidateSumm <- kqlvld <- kglgob
<- psd_validate <- pevm_icd_call_common <- pfrinstr_ICAL <- pfrrun_no_tool <- pfrrun
<- plsql_run <- peicnt <- kkxexe <- opiexe <- opipls <- opiodr <- rpidrus <- skgmstack <- rpidru
<- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXIM <- pfrinstr_EXIM <- pfrrun_no_tool
<- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main

Changes

 Upgrade to 19C

Cause

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