Database Crash Due To ORA-00600 [504] And ORA-07445 [ksfvidmp()+196] (Doc ID 1292301.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Oct-2013***

Symptoms

After killing an active session, using "kill -9" OS command or "alter system kill session '<sid>, <serial#>' immediate;", the database may crash with errors:

ORA-00600: internal error code, arguments: [504], [0x44DA539C8], [4], [0], [ksfv messages], [2], [1], [0x000000000], []

ORA-07445: exception encountered: core dump [ksfvidmp()+196] [SIGSEGV] [ADDR:0x0] [PC:0x100672A64] [Address not mapped to object] []


The PMON trace file shows the following information:

*** Dump continued from file: /ora_diag/diag/rdbms/twddb_dg1/twddb/trace/twddb_pmon_28668.trc
ORA-00600: internal error code, arguments: [504], [0x44DA539C8], [4], [0], [ksfv messages], [2], [1], [0x000000000], [], [], [], []

========= Dump for incident 40026 (ORA 600 [504]) ========
----- Beginning of Customized Incident Dump(s) -----
*** LATCH HIERARCHY ERROR ***
An attempt to get the 'ksfv messages' latch (child #2) at level 0 (address = 0x4da539c8)
from location 'ksfv2.h LINE:910 ID:ksfvfree' (also see call stack below)
conflicts with the following held latch(es):
Level 2: 'i/o slave adaptor' (address = 0x8000e120)
gotten from location 'ksfv2.h LINE:865 ID:ksfvidel'
----- End of Customized Incident Dump(s) -----

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst1 <- ksedst <- dbkedDefDump <- dbgexPhaseII <- dbgexExplicitEndInc<- dbgeEndDDEInvocationImpl
<- ksl_level_check <- kslgetl <- ksfvidel <- kssxdl <- kssdch <- ksudlp <- kssxdl <- ksuxdl
<- ksuxda_del_proc <- ksucln_dpc_cleanup <- ksucln_dpc_dfs <- ksucln_dpc_main <- ksucln <- ksbrdp
<- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- start


The generic symptoms are:

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