ORA-00600 [kzan_open_osfile:ksfdread] while querying/purging unified audit

Hi everyone,

Lately, I hit and ORA-600 while querying unified_audit_trail on 19.8 Oracle database and same thing happens if you want to purge audit data too. the exact error message is:

ORA-00600: internal error code, arguments: [kzan_open_osfile:ksfdread], [], [], [], [], [], [], [], [], [], [], []

Normally, I check the support first but this time ora 600 argument seems understandable to me. I can see that Oracle is has some problems while reading a file. so I checked alert.log.

p.s. : I changed db names with “orcl”

I checked trace file that I found in alert.log (/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5714.trc ) after the trace file header information, here is the text belongs to error:

if you look closely, you can see that Oracle is trying to read /u01/app/oracle/audit/orcl/.ora_audit_01267.bin file and then got an file I/O Error and at the very end the error is “no data found”. So, definitely there is something about this file. when I queried the file I realized that file is 0 bytes:

I just consider that Oracle is trying to read this file but since it is and empty audit file got an no data found error. I deleted this file and all the problems are gone 🙂

hope this is helpful.

wish you healthy days.

 

Leave a Reply

Your email address will not be published.