ORA-7445 [kkzs_get_summ_mflag()+xxx] On Mview Refresh After Upgrade To 10gR2 (Doc ID 580162.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3 - Release: 10.2 to 10.2

Symptoms

ORA-07445: exception encountered: core dump [kkzs_get_summ_mflag()+192] [SIGSEGV] [Address not mapped to object] [0x000000044] [] []

The call stack from the ORA-7445 [kkzs_get_summ_mflag()+192] error contained the following:

sighndlr <- call_user_handler <- 0000000000105C00 <- kkzs_mv_fresh_after_refresh <- kkzscgn_create_graph_nodes <- kkzsbg_build_graph <- kkzschedule <- kkzisf3g <- spefcpfa <- spefmccallstd <- peftrusted <- psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- rpiexe <- kkjex1e <- kkjsexe <- kkjrdp <- opirip <- opidrv <- sou2o <- opimai_real <- main <- start

Prior to the upgrade, a select from dba_objects showed that all objects had a status of VALID.   But upon further inspection, a select from dba_mviews showed the compile_state had a value of ERROR in the 9i database.

Changes

Upgrade from 9i to 10gR2.

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