My Oracle Support Banner

'DBMS_AUDIT_MGMT.clean_audit_trail' fails with ORA-00600: [kkdoilsf1] (Doc ID 2421845.1)

Last updated on JANUARY 29, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 18.1.0.0.0 [Release 12.2 to 18]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Jobs failing with the following error:

2018-06-22T15:00:02.436681-07:00
Errors in file /u01/app/oracle/diag/rdbms/db01/db012/trace/db012_j001_389291.trc (incident=169180) (PDBNAME=PDB01):
ORA-00600: internal error code, arguments: [kkdoilsf1], [], [], [], [], [], [], [], [], [], [], []
PDB01(3):Incident details in: /u01/app/oracle/diag/rdbms/db01/db012/incident/incdir_169180/db012_j001_389291_i169180.trc

-OR-

DBMS_AUDIT_MGMT.clean_audit_trail failing with :


SQL> EXEC DBMS_AUDIT_MGMT.clean_audit_trail(audit_trail_type =>
DBMS_AUDIT_MGMT.audit_trail_unified, use_last_arch_timestamp => FALSE);
BEGIN DBMS_AUDIT_MGMT.clean_audit_trail(audit_trail_type =>
DBMS_AUDIT_MGMT.audit_trail_unified, use_last_arch_timestamp => FALSE); END;

*
ERROR at line 1:
ORA-02002: error while writing to audit trail
ORA-00600: internal error code, arguments: [kkdoilsf1], [], [], [], [], [],

 

Failing statement in both cases are the same:

----- Current SQL Statement for this session (sql_id=b311nu64bc3ac) -----
insert into AUDSYS.AUD$UNIFIED( AUDIT_TYPE, SESSIONID, PROXY_SESSIONID, OS_USER, HOST_NAME, TERMINAL, INSTANCE_ID, DBID, AUTHENTICATION_TYPE, USERID, PROXY_USERID, EXTERNAL_USERID, GLOBAL_USERID, CLIENT_PROGRAM_NAME, DBLINK_INFO, XS_USER_NAME, XS_SESSIONID, ENTRY_ID, STATEMENT_ID, EVENT_TIMESTAMP, ACTION, RETURN_CODE, OS_PROCESS, TRANSACTION_ID, SCN, EXECUTION_ID, OBJ_OWNER, OBJ_NAME, SQL_TEXT, SQL_BINDS, APPLICATION_CONTEXTS, CLIENT_IDENTIFIER, NEW_OWNER, NEW_NAME, OBJECT_EDITION, SYSTEM_PRIVILEGE_USED,.......

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!


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