需要官方开SR
APPLIES TO:
Oracle Database – Enterprise Edition – Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
SYMPTOMS
ORA-00600: internal error code, arguments: [kclgclks_3], [0], [75195224], [], [], [], [], [], [], [] reported
Alert logs shows:
Mon Apr 18 09:53:57 2016 Errors in file /u01/app/oracle/diag/rdbms/<dbname>/<instance_name>/trace/<instance_name>_ora_9158.trc (incident=106753):
ORA-600: internal error code, arguments: [kclgclks_3], [0], [1540030962], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dbname/<instance_name>/incident/incdir_106753/<instance_name>_ora_9158_i106753.trc
Use ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.
Mon Apr 18 09:54:06 2016Dumping diagnostic data in directory=[cdmp_20160418095406], requested by
(instance=1, osid=9158), summary=[incident=106753].
<instance_name>_ora_9158_i106753.trc
[TOC00006] <- skdstdst <- ksedst <- dbkedDefDump <- ksedmp
<- ksfdmp <- dbgexPhaseII <- dbgexExplicitEndInc <- dbgeEndDDEInvocatio <- nImpl
<- dbgeEndDDEInvocatio <- kclgclks <- kcbzib <- kcbgtcr <- ktrgtc2
@ <- qeilbk1 <- qeilsr <- qerixtFetch <- qergiFetch <- qergiFetch
<- qerjotFetch <- rwsfcd <- qerltcFetch <- insexe <- opiexe
<- opipls <- opiodr <- rpidrus <- skgmstack <- rpiswu2
<- rpidrv <- psddr0 <- psdnal <- pevm_EXECC <- pfrinstr_EXECC
<- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe
<- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start <-
CHANGES
When the new 12c feature of updating a Global Temporary Table from an ADG standby is used, then the internal SCN checks (comparing enviroment SCN with recent SCN) find that the env scn is ahead of the recent scn. While it is correct that in most cases an error needs to be raised then, in case of temp blocks on ADG kenvscn<=rscn is not an invariant.
CAUSE
Bug 23128150 : ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KCLGCLKS_3], [0], [1540030962], [],
Fix Superceded by
Bug 26556014 – ORA-00600 WITH ARGUMENT KCLGCLKS_3 ON ADG
SOLUTION
Bug 26556014 fixed in 18.1.
Apply one-off Patch 26556014 if it exists for your platform and version. If interim patch does not exist for your platform/version,engage Oracle Support to request a patch.
