Audit Tablespace Datafile Fails To Extend When AUD$ Grows.

(Doc ID 1310035.1)

Last updated on OCTOBER 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
Checked for relevance on 07-Jan-2013

Symptoms

You have moved the AUD$ table to a dedicated tablespace using package DBMS_AUDIT_MGMT (or otherwise), and the datafiles associated with this tablespace are set to autoextend. However when  AUD$ grows and fills up the tablepace the datafile(s) do not autoextend and the following error is reported:

ORA-02002: error while writing to audit trail datafile not extending.


Typically this error appears within a larger errorstack showing recursive operations:



Sun Feb 06 09:07:36 2011
Errors in file /u02/app/oracle/diag/rdbms/.../../trace/..._ora_13107318.trc (incident=84169):
ORA-00600: internal error code, arguments: [4414], [13019], [1], [11400], [3], [], [], [], [], [], [], []
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 5
ORA-08243: recursive audit operation attempted
ORA-08243: recursive audit operation attempted
ORA-06512: at "SYSMAN.MGMT_JOB_EXEC_UPDATE", line 19
ORA-04088: error during execution of trigger 'SYSMAN.MGMT_JOB_EXEC_UPDATE'
Incident details in: /u02/app/oracle/diag/rdbms/.../.../incident/incdir_84169/..._ora_13107318_i84169.trc
Sun Feb 06 09:07:41 2011
Trace dumping is performing id=[cdmp_20110206090741]
Errors in file /u02/app/oracle/diag/rdbms/.../.../trace/..._ora_13107318.trc (incident=84170):
ORA-00600: internal error code, arguments: [4414], [0], [0], [11400], [3], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4414], [13019], [1], [11400], [3], [], [], [], [], [], [], []
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 5
ORA-08243: recursive audit operation attempted
ORA-08243: recursive audit operation attempted
ORA-06512: at "SYSMAN.MGMT_JOB_EXEC_UPDATE", line 19
ORA-04088: error during execution of trigger 'SYSMAN.MGMT_JOB_EXEC_UPDATE'
Incident details in: /u02/app/oracle/diag/rdbms/.../.../incident/incdir_84170/..._ora_13107318_i84170.trc
Sun Feb 06 09:07:42 2011
Sweep Incident[84169]: completed
Trace dumping is performing id=[cdmp_20110206090744]



While connecting to the database using sqlplus the following errors occur:


ERROR:
ORA-00604: error occurred at recursive SQL level 3
ORA-08243: recursive audit operation attempted
ORA-08243: recursive audit operation attempted
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 3
ORA-08243: recursive audit operation attempted
ORA-08243: recursive audit operation attempted

Cause

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 hundreds of Community platforms