ORA-00600:[17147] in 12.1.0.2 During SYS.DBMS_SQLTUNE_INTERNAL (Doc ID 2296922.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
Alert log shows:

ORA-00600: internal error code, arguments: [17114], [0x7F49297F5D38], [], [], [], [], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [kghalf()+609] [SIGSEGV] [ADDR:0x0] [PC:0xD0B8C31] [SI_KERNEL(general_protection)] []

and

Trace file shows following PL/SQL and Call Stack trace:

----- PL/SQL Call Stack -----
object line object
handle number name
0x1a7471128 12825 package body SYS.DBMS_SQLTUNE_INTERNAL
0xaed987e8 7 SYS.WRI$_ADV_SQLTUNE
0x24481f658 602 package body SYS.PRVT_ADVISOR
0x24481f658 2678 package body SYS.PRVT_ADVISOR
0x23fa67638 241 package body SYS.DBMS_ADVISOR
0x2398b56e0 937 package body SYS.DBMS_SQLTUNE
0x1aaeb0a90 19 anonymous block

----- Call Stack Trace -----

kghalf <- kghstack_overflow_i <- nternal <- kghstack_alloc <- kcra_scan_redo
<- kcra_dump_redo <- kcra_dump_redo_inte <- rnal <- kcra_dump_redo_rdba <- s_helper
<- kcra_dump_redo_ltsn <- lrdba <- kcbdnbRedo <- _lrdba <- kcbdnb
<- dbkedDefDump <- ksedmp <- ksfdmp <- dbgexPhaseII <- dbgexExplicitEndInc
<- dbgeEndDDEInvocatio <- nImpl <- dbgeEndDDEInvocatio <- kgherror <- kghfrf
<- ksxpcloseport <- ksxpcrst <- kxfppdel <- kxfpqsod_qc_sod <- 147
<- kxfpqsod <- kxfrcls <- qerpx_stop <- qerpxFetch <- rwsfcd
<- qergsFetch <- qervwFetch <- opifch2 <- opifch <- opiodr
<- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc
<- kpufch0 <- kpufch <- OCIStmtFetch <- kkoadsTimeLimitFrom <- Src
<- kkoadsTimeLimit

Symptoms

ORA-07445: exception encountered: core dump [kghalf()+609] [SIGSEGV] [ADDR:0x0] [PC:0xD0B8C31] [SI_KERNEL(general_protection)] []
ORA-00600: internal error code, arguments: [17114], [0x7F49297F5D38], [], [], [], [], [], [], [], [], [], []

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