ORA-00600 [qkaffsindex3] reported in database alert log at the time of auto stats gather job (Doc ID 2703284.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Oracle ver -->12.1.0.2
OS ver -->Linux x86-64
====================

Below errors have reported in database alert log

Wed Jul 15 22:00:20 2020
Archived Log entry 281212 added for thread 1 sequence 281217 ID 0xf0169190 dest 1:
Errors in file /u01/app/oracle/diag/rdbms/tmsp/TMSP/trace/TMSP_j002_15721.trc (incident=68569):
ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/tmsp/TMSP/incident/incdir_68569/TMSP_j002_15721_i68569.trc
Wed Jul 15 22:10:16 2020
Errors in file /u01/app/oracle/diag/rdbms/tmsp/TMSP/incident/incdir_68569/TMSP_j002_15721_i68569.trc:
ORA-00308: cannot open archived log '/u02/oradata/TMSP/arch/1_279978_937053715.dbf'
ORA-17503: ksfdopn:4 Failed to open file /u02/oradata/TMSP/arch/1_279978_937053715.dbf
ORA-17500: ODM err:File does not exist
ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.