ORA-00600 [17128] or ORA-00600 [17147] During Fast Refresh Of Materialized View (Doc ID 752137.1)

Last updated on SEPTEMBER 25, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Sep-2013***

Symptoms

Fast refresh of  a materialized view fails with errors such as ORA-00600 [17128], ORA-00600 [17147], ORA-00600: [17114], or ORA-07445.

o  Alert log shows following error messages:

ORA-600: internal error code, arguments:[17147], [0x9FFFFFFFEF5959C8], []
ORA-600: internal error code, arguments: [KGHALO4], [0x6000000000058990]
ORA-600: internal error code, arguments: [17128], [0x9FFFFFFFFD1E6CF8]

- OR -

ORA-00600: internal error code, arguments: [17114], [0x2B9C2F0704E8], [], [], [], [], [], []


User's session terminates with the error:

ORA-3114: not connected to ORACLE


o Call stack trace for different errors is similar to:

  ORA-00600: internal error code, arguments: [17147] 
  ORA-00600: internal error code, arguments: [17114]

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ksupop <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- main <- main_opd_entry


  ORA-00600: internal error code, arguments: [17128]

... kgherror <- kghiexchk <- kghichk <- kghhchk <- kghfrh_internal <- kghfrh ...

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