ORA-00600 [17128] or ORA-00600 [17147] During Fast Refresh Of Materialized View
(Doc ID 752137.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
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]
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
<- opiodr <- opidrv <- sou2o <- opimai_real <- main <- main_opd_entry
ORA-00600: internal error code, arguments: [17128]
... kgherror <- kghiexchk <- kghichk <- kghhchk <- kghfrh_internal <- kghfrh ...
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |