[kclgclks_3]ADG-创新互联

需要官方开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///trace/_ora_9158.trc (incident=106753):
ORA-600: internal error code, arguments: [kclgclks_3], [0], [1540030962], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dbname//incident/incdir_106753/_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].
_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.

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。