SELECT sequence.NEXTVAL FROM dual;会引发bug？

在生产环境中，SELECT sequence.NEXTVAL FROM dual;报ora-600错误。在mos上面查居然是个bug
ORA-00600 [6816] on SELECT sequence.NEXTVAL FROM dual in RAC (文档 ID 2428000.1)

In this Document

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

The issue has been investigated in unpublished Bug 28129792 : OFA-600 [6816} ERROR WHEN APP TRYS TO ACCESS SEQUENCE closed as duplicate of

Bug 27181897 : INSERT INTO OBJAUTH$ LEADING ORA-00600 [6816] DURING STATS GATHERING.

SOLUTION

Apply Patch 27181897 if available for your version and platform.

To check for conflicting patches, please use the My Oracle Support (MOS) Patch Planner Tool.

Reference:
Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?

 If no patch exists for your platform and version, please contact Oracle Support to request a fix.
 

REFERENCES