My Oracle Support Banner

ORA-600 [kzaf_dump_audit:Recursive Audit Record Attempt] While Drop Table (Doc ID 2507559.1)

Last updated on FEBRUARY 20, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Intermittent error ORA-00600:[KZAF_DUMP_AUDIT:RECURSIVE AUDIT RECORD ATTEMPT] seen in alert log file.

Sun Dec 10 10:05:00 2017
Errors in file /location/***/****/trace/***_j001_20242.trc (incident=510201):
ORA-00600: internal error code, arguments: [kzaf_dump_audit:Recursive Audit record attempt], [], [], [], [], [], [], [], [], [], [], []


****abc.trc
----------------------------------------
*** 2018-01-11 19:06:43.033
*** SESSION ID:(104.38069) 2018-01-11 19:06:43.033
*** CLIENT ID:() 2018-01-11 19:06:43.033
*** SERVICE NAME:(***) 2018-01-11 19:06:43.033
*** MODULE NAME:(****@**** (TNS V1-V3)) 2018-01-11 19:06:43.033
*** CLIENT DRIVER:() 2018-01-11 19:06:43.033
*** ACTION NAME:() 2018-01-11 19:06:43.033

========= Dump for incident 427790 (ORA 600 [kzaf_dump_audit:Recursive Audit record attempt]) ========

*** 2018-01-11 19:06:43.036
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=*******) -----
drop table "SYS"."BIN$Yn0w7ZJMUozgVAAQ4Ghamg==$0" purge
[TOC00003-END]

[TOC00004]
----- Call Stack Trace -----

kgeasnmierr()
kzaf_dump_audit()
kzaf_audit_compose()
kzaf_write_audit()
kzanWriteStandardAudit
audins()+380
audone()+3108
auddft_internal()+1
opiexe()+8072
opiosq0()
opiall0()
opikpr()
opiodr()
rpidrus()
skgmstack()
rpidru()
rpiswu2()
kprball()
kdpurtab()
kdpurts()
kdpursp()
ktsx_purge_bin()+30
ktspnr_next()
ktrsexec()
ktspbmphwm()
ktspmvhwm()
ktsp_bump_hwm()
ktspgsp_main2()
kdtgsp()
kdtgsph()
kdtgrs()
kdtInsRow()
qerltcNoKdtBufferedInsRowCBK()
qerltcSingleRowLoad
qerltcFetch()



SQL> select count(*) from unified_audit_trail;

COUNT(*)
----------
  34122


audit_file_dest string /dir/
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB
unified_audit_sga_queue_size integer 1048576

select * from recyclebin;
no results




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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