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”
|
1 2 3 4 5 6 |
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 |
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
=================== 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 |
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:
|
1 2 3 4 5 |
$ 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 |
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.