ORA-00600 [kzan_open_osfile:ksfdread] while querying/purging unified audit mustafakalayci, 2021-08-08 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” Oracle PL/SQL Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5714.trc (incident=33073): ORA-00600: internal error code, arguments: [kzan_open_osfile:ksfdread], [], [], [], [], [], [], [], [], [], [], [] ORA-27072: File I/O error Additional information: 4 Additional information: 1 Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_33073/orcl_ora_5714_i33073.trc 123456 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5714.trc (incident=33073):ORA-00600: internal error code, arguments: [kzan_open_osfile:ksfdread], [], [], [], [], [], [], [], [], [], [], []ORA-27072: File I/O errorAdditional information: 4Additional information: 1Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_33073/orcl_ora_5714_i33073.trc 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: Oracle PL/SQL =================== skgfqio Request Dump ======================= OSD Context: aiopend=0, aiodone=0, limfsiz=4294967295l, sigwinchslot=0 Request flags: READ - - - - skgfrrq request element 1 - - - - BLOCKNO = 1 IOV: addr=0x0xe0aca018, fib=0x0xe0b13ac0, maxaio=0, seal=0x45726963, fd=262 fsync required?=FALSE, offset=18446744073709551615, aiopend=0 FIB: addr=0x0xe0b13ac0, lblksiz=512, ora ftype=36, pblksiz=512, filsiz=0 maxvec=16, fname=/u01/app/oracle/audit/orcl/.ora_audit_01267.bin, serr=0, seal=0x45726963 fstype=0x58465342, unix ftype=0x8180, last block=0 IOSB: addr=0x0x7f98044ce028, status=3, time=0, qstatus=541412418,AIO start time=6135103725341922137 err=27072 errno=0 ose[0]=4 ose[1]=1 ose[2]=0 BUFFER: addr=0x0x7f9804453000, len=512 ORA-27072: File I/O error Additional information: 4 Additional information: 1 2021-08-07T09:08:58.408757+02:00 Incident 33073 created, dump file: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_33073/orcl_ora_5714_i33073.trc ORA-00600: internal error code, arguments: [kzan_open_osfile:ksfdread], [], [], [], [], [], [], [], [], [], [], [] ORA-27072: File I/O error Additional information: 4 Additional information: 1 Exception in kzam_ang_cleanup, 1403:ORA-01403: no data found kzam_message_handler: Got error 600 2 51 12345678910111213141516171819202122232425 =================== skgfqio Request Dump =======================OSD Context: aiopend=0, aiodone=0, limfsiz=4294967295l, sigwinchslot=0Request flags: READ- - - - skgfrrq request element 1 - - - -BLOCKNO = 1IOV: addr=0x0xe0aca018, fib=0x0xe0b13ac0, maxaio=0, seal=0x45726963, fd=262 fsync required?=FALSE, offset=18446744073709551615, aiopend=0FIB: addr=0x0xe0b13ac0, lblksiz=512, ora ftype=36, pblksiz=512, filsiz=0 maxvec=16, fname=/u01/app/oracle/audit/orcl/.ora_audit_01267.bin, serr=0, seal=0x45726963 fstype=0x58465342, unix ftype=0x8180, last block=0IOSB: addr=0x0x7f98044ce028, status=3, time=0, qstatus=541412418,AIO start time=6135103725341922137err=27072 errno=0 ose[0]=4 ose[1]=1 ose[2]=0BUFFER: addr=0x0x7f9804453000, len=512ORA-27072: File I/O errorAdditional information: 4Additional information: 12021-08-07T09:08:58.408757+02:00Incident 33073 created, dump file: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_33073/orcl_ora_5714_i33073.trcORA-00600: internal error code, arguments: [kzan_open_osfile:ksfdread], [], [], [], [], [], [], [], [], [], [], []ORA-27072: File I/O errorAdditional information: 4Additional information: 1 Exception in kzam_ang_cleanup, 1403:ORA-01403: no data foundkzam_message_handler: Got error 600 2 51 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: Oracle PL/SQL $ ls -la total 0 drwxr-x---. 2 oracle ***** 34 Jun 16 21:22 . drwxr-x---. 3 oracle ***** 19 Dec 11 2020 .. -rw-------. 1 oracle ***** 0 Jun 16 21:22 .ora_audit_01267.bin 12345 $ ls -latotal 0drwxr-x---. 2 oracle ***** 34 Jun 16 21:22 .drwxr-x---. 3 oracle ***** 19 Dec 11 2020 ..-rw-------. 1 oracle ***** 0 Jun 16 21:22 .ora_audit_01267.bin 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. 19c Administration kzan_open_osfile:ksfdreadora 600ORA-00600purge auditpurge logquerying auditunified audit