12.1.0.1: ORA-00600: [kclcls_8], [196616], [107163] in RAC (Doc ID 2102951.1)

Last updated on FEBRUARY 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The below errors are reported in alert log. 

alert_tmo12cdb1.log
==============

Fri Jan 29 02:42:46 2016
Insufficient memory to populate table to inmemory area
Fri Jan 29 02:45:07 2016
Errors in file /usr/app/oracle/diag/rdbms/tmo12cdb/tmo12cdb1/trace/tmo12cdb1_ora_10277.trc (incident=405823) (PDBNAME=TMOLABDB4):
ORA-00600: internal error code, arguments: [kclcls_8], [196616], [107163], [], [], [], [], [], [], [], [], []
Incident details in: /usr/app/oracle/diag/rdbms/tmo12cdb/tmo12cdb1/incident/incdir_405823/tmo12cdb1_ora_10277_i405823.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Jan 29 02:45:10 2016
Sweep [inc][405823]: completed
Sweep [inc2][405823]: completed
Fri Jan 29 02:45:19 2016
Dumping diagnostic data in directory=[cdmp_20160129024519], requested by (instance=1, osid=10277), summary=[incident=405823].

 

tmo12cdb1_ora_10277_i405823.trc
======================


ORA-00600: internal error code, arguments: [kclcls_8], [196616], [107163], [], [], [], [], [], [], [], [], []

========= Dump for incident 405823 (ORA 600 [kclcls_8]) ========

----- Beginning of Customized Incident Dump(s) -----

BH (0x23c1162e8) file#: 18 rdba: 0x00740003 (1024/7602179) class: 1 ba: 0x23cf5c000
set: 43 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,19
dbwrid: 0 obj: 107163 objn: 107163 tsn: [3/8] afn: 18 hint: f                  <<<<<  
hash: [0x1ce28a238,0x2856dcf30] lru: [0x1dfe58348,0x1ce0faf10]
ckptq: [NULL] fileq: [NULL]
objq: [0x182464c90,0x182464c90] objaq: [0x182464c80,0x182464c80]
use: [0x282f195b0,0x282f195b0] wait: [NULL]
st: READING md: EXCL tch: 0 le: 0x0
flags:
GLOBAL CACHE IMC ELEMENT DUMP (address: 0x1d792be98):
id1: 0x740003 id2: 0x12 pkey: OBJ#3,8,105286 block: (18/7602179)          <<<<< objdmismatch issue
flags: 0x4 lock: X aid: 257 link: [0x1cd108c28,0x27b6460f0]

 

----- Current SQL Statement for this session (sql_id=grcf4nmdyqc3s) -----

INSERT /*+ SYS_DL_CURSOR */ INTO "CA_EDMT"."CONTRACT" ("IAM_CONTRACT_ID","CONTRACT_CODE","UNIQUE_CONTRACT_CODE","USERID","PRIMARY_BILLING_ACCOUNT_ID","IMSI","IMSI_STATUS","IMSI_START_DATE",
"IMSI_EXPIRATION_DATE","STATUS","MSISDN","STATUS_DATE","ACTIVATION_DATE","CANCELLATION_DATE","TRANSACTION_TYPE","RATE_PLAN_TYPE","LOGIN_COUNT"," LAST_LOGIN_TIMESTAMP","OPT_IN_SILENT_TIMESTAMP","REGISTRATION_STATUS","OPERATOR_ID","ACCOUNT_TYPE_SUBTYPE","AUTH_FAILURE_COUNT",
"LAST_AUTH_FAILURE_TIMESTAMP","PREPAID_PIN_FAILURE_COUNT","LAST_PREPAID_PIN_FAILURE_TIME","SSN_FAILURE_COUNT","LAST_SSN_FAILURE_TIMESTAMP,
"SMS_PIN_FAILURE_COUNT","LAST_SMS_PIN_FAILURE_TIMESTAMP","OPT_OUT_IBA","IS_RECEIVING_OFFER","CSN","EXPERIENCE_TYPE","ICCID","ICCID_PIN","IMEI","MEID","OEM_AUTHENTICATION_TOKEN","VO_WIFI_ENABLED","MCA_ENABLED","MWI_ENABLED","IS_PRIMARY","TC_ACCEPT_DATE","PIN_CODE","PIN_CODE_EXP_TIMESTAMP","MIGRATION_STATUS","LASTUPDATEDTIMESTAMP") VALUES NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,current_timestamp(:"SYS_B_0"))

----- Call Stack Trace -----

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ksfdmp
<- dbgexPhaseII <- dbgexExplicitEndInc <- dbgeEndDDEInvocatio <- nImpl <- dbgeEndDDEInvocatio
<- kclcls <- kclgrnew <- kcbnew <- ktsbnew <- ktspfmdb                                                                   <<<<<<<
<- ktspfmtrng <- ktspfmbb <- ktspfmall <- ktspsynchwm <- ktspfmthwm
<- ktsmg_trimf1 <- kdbltrmt <- kdblfpl <- kdblfl <- klafin
<- kpodpfin <- kpodpmop <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start

 

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