My Oracle Support Banner

ORA-00600 [6816] on SELECT sequence.NEXTVAL FROM dual in RAC (Doc ID 2428000.1)

Last updated on SEPTEMBER 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 18.3.0.0.0 [Release 11.2 to 18]
Information in this document applies to any platform.

Symptoms

The following error occurs in the alert log when accessing a sequence: SELECT sequence.NEXTVAL FROM dual;

ORA-00600 [6816] [360] [370826] [4]

The Call Stack Trace in the associated incident trace file shows:

kdnbka <- kdnobl <- kqldsnr <- kqlobjlod <- kqllod_new <- kqlCallback <- kqllod <- kglobld
<- kglobpn <- kglpim <- kglpin <- kglgob <- qcdlgbo <- qcdlgob <- qcsfgob <- qcsResolveSqnRef
<- qcsRslvName <- qcsridn <- qcsraic <- qcspqbDescendents <- qcspqb <- kkmdrv <- opiSem
<- opiDeferredSem <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild
<- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- kpoopr

 Also the trace file shows : "kjfmHB_ACT_Action_Diag: Executing action dump through DIAG".

Eg:

diag/rdbms/orcl/orcl/trace/orcl_j000_15430.trc:
*** 2017-11-01T06:42:22.003125+01:00
kjfmHB_ACT_Action_Diag: Executing action dump through DIAG
2017-11-01 06:42:22.003 :kjzddmp(): Submitting asynchronized dump request
[14]. summary=[LMHB css dump (kjfmHB_Action)].

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.