ORA-07445 [kgghteGetEle()+55] : After Upgrade From 10g To 11.2.0.2. Dbms_refresh Getting Ora-03113 (Doc ID 1408757.1)

Last updated on MAY 12, 2017

Applies to:

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

Symptoms

When running a a refresh of an mview refresh group we see an ORA-3113 and the following in the trace file:

 

SQL> alter session set "_optimizer_distinct_agg_transform" = false; 

 
--  This parameter was seen to be a potential work around, but failed to resolve the issue.

 

Session altered.

SQL> BEGIN dbms_refresh.refresh('base_group'); END;
2 /
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 25728
Session ID: 1153 Serial number: 17141

 

Dump continued from file: /opt/app/oracle/admin/vlreport/diag/rdbms/vlreport/vlreport/trace/vlreport_ora_18758_trace_10.trc
ORA-07445: exception encountered: core dump [kgghteGetEle()+55] [SIGSEGV] [ADDR:0x7FFF0A2FDFF8] [PC:0x88D8085] [Address not mapped to object] []

*** 2011-10-05 22:46:24.767
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=72xgqakg49kg8) -----
SELECT /*+ remote_mapped("VECTORDB") */ CURRENT$."ADV_TRAINING_KEY_RESULTS_ID",CURRENT$."OFFICE_ID",CURRENT$."CREATED_DATE",CURRENT$."DEMOS",CURRENT$."SALES",CURRENT$."AMOUNT_SOLD",CURRENT$."APPOINTMENTS",CURRENT$."FINISH",CURRENT$."FINISH_DATE",CURRENT$."RESOLVE_LOCKOUT" FROM (SELECT "ADV_TRAINING_KEY_RESULTS"."ADV_TRAINING_KEY_RESULTS_ID" "ADV_TRAINING_KEY_RESULTS_ID","ADV_TRAINING_KEY_RESULTS"."OFFICE_ID" "OFFICE_ID","ADV_TRAINING_KEY_RESULTS"."CREATED_DATE" "CREATED_DATE","ADV_TRAINING_KEY_RESULTS"."DEMOS" "DEMOS","ADV_TRAINING_KEY_RESULTS"."SALES" "SALES","ADV_TRAINING_KEY_RESULTS"."AMOUNT_SOLD" "AMOUNT_SOLD","ADV_TRAINING_KEY_RESULTS"."APPOINTMENTS" "APPOINTMENTS","ADV_TRAINING_KEY_RESULTS"."FINISH" "FINISH","ADV_TRAINING_KEY_RESULTS"."FINISH_DATE" "FINISH_DATE","ADV_TRAINING_KEY_RESULTS"."RESOLVE_LOCKOUT" "RESOLVE_LOCKOUT" FROM "ADV_TRAINING_KEY_RESULTS"@"VECTORDB" "ADV_TRAINING_KEY_RESULTS") CURRENT$, (SELECT DISTINCT MLOG$."ADV_TRAINING_KEY_RESULTS_ID" "ADV_TRAINING_KEY_RESULTS_ID" FROM "VECTOR"."MLOG$_ADV_TRAINING_KEY_RES"@"VECTORDB" MLOG$ WHERE "SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."ADV_TRAINING_KEY_RESULTS_ID" = LOG$."ADV_TRAINING_KEY_RESULTS_ID"

The corresponding stack is:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ssexhd <- sighandler <- kgghteGetEle <- kggmsFindPtr <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc

Changes

Upgrade to 11.2 from 10g.

 

The bounce of the database also failed with:

 

ERROR at line 1:
ORA-12048: error encountered while refreshing materialized view
"VECTOR"."MV_A_SELF"
ORA-30091: secondary translation table not loaded
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2566
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2779
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

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