Deadlock while writing to audit trail
Problem:
Received Deadlock attempting to move the audit trail out of the system tablespace.
Solution:
Login as SYS and try again.
Full error message:
Error starting at line : 13 in command -
BEGIN
SYS.DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(
audit_trail_type => SYS.DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
audit_trail_location_value =>
'AUDIT_TBS');
END;
Error report -
ORA-02002: error while writing to audit trail
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1585
ORA-06512: at line 2
02002. 00000 - "error while writing to audit
trail"
*Cause:
*Action:
From the documentation
All DBMS_AUDIT_MGMT subprograms require the user to have EXECUTE privilege over the DBMS_AUDIT_MGMT package. The SYSDBA and AUDIT_ADMIN roles have EXECUTE privileges on the package by default.
Oracle strongly recommends that only audit administrators should have the EXECUTE privilege on the DBMS_AUDIT_MGMT package and be granted the AUDIT_ADMIN role.
Executions of the DBMS_AUDIT_MGMT subprograms are always audited.
All DBMS_AUDIT_MGMT subprograms require the user to have EXECUTE privilege over the DBMS_AUDIT_MGMT package. The SYSDBA and AUDIT_ADMIN roles have EXECUTE privileges on the package by default.
Oracle strongly recommends that only audit administrators should have the EXECUTE privilege on the DBMS_AUDIT_MGMT package and be granted the AUDIT_ADMIN role. Executions of the DBMS_AUDIT_MGMT subprograms are always audited.
References:
Bug 20088237 - ORA-600 [kzam_move_aud_tablespace] during init audit (Doc ID 20088237.8)
https://juliandontcheff.wordpress.com/2011/05/12/auditing-vs-performance-in-the-oracle-database/
Bug 8236755 : ORA-00060 OCCURS WHILE UPDATING AUD$ TABLE.
Bug 8236755 : ORA-00060 OCCURS WHILE UPDATING AUD$ TABLE.
Version: 11.2.0.1.0 on Windows.
Comments
Post a Comment