ORA-600[KCLANTILOCK_17]

Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[ORA-600[KCLANTILOCK_17] After upgrade to 12.2, Due to this Instance got crashed. As per metalink this is a known Bug 27162390 Patch 27162390: LNX64-181-RAC: LMS HIT ORA-600[KCLANTILOCK_17], INST CRASH I’ve seen this in 12.2. As per Oracle it’s fixed in version 18.1

Read More

ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY]

Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[KDZA_CHECK_EQ NOT IN DICTIONARY] As per metalink this is a known Bug 24818566 Patch 24818566: SQLLOAD FAILED WITH ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY] I’ve seen this in 11204 ,12102,12.2 both. As per Oracle it’s fixed in version 18.1

Read More

KST tracing in Oracle

KST tracing is an in-memory tracing feature for Oracle RDBMS Database Server, this is similar to on-disk (KSD) tracing except it is stored in SGA. For on-disk tracing, we have many events like 10046 (sql_trace), 10053 (sql_optimizer), etc. Different to these on-disk tracing, KST tracing use a cyclic buffer in the SGA and we won’t […]

Read More

ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi]

Recently started seeing this error on few of the RAC environments. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_q002_5570998.trc: ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], [1], [0], [], [], [], [], [], [], [], [], [] As per metalink this is a known Bug 20987661 – Doc ID 20987661.8 DECLARE po dbms_aqadm.aq$_purge_options_t; BEGIN po.block := FALSE; DBMS_AQADM.PURGE_QUEUE_TABLE( queue_table => […]

Read More

ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver]

On an Oracle 11204 restart environment, ASM spfile creation failed with error ora-600 create spfile=’+DATA5′ from pfile=’/u03/asmpfile.ora’ * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver],[0x0A2435D48], [3], [0x7F710EE38000], [512], [], [], [], [], [], [], [] This was caused due to a ASM disk with UNKNOWN HEADER_STATUS. […]

Read More

ORA-00600: internal error code, arguments: [kzsrgpw]

Recently I started getting ORA-00600 error, while I was trying to connect to SQLPlus sqlplus sys as sysdba SQL*Plus:Release 11.2.0.3.0 Production on Tue Jan 17 06:13:16 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter password: ERROR: ORA-00600: internal error code, arguments: [kzsrgpw], [], [], [], [], [], [], [], [], [], [], [] […]

Read More