Error:
ORA-12012: error on auto execute of job “SYS”.”DAILY_OS_AUDIT_PURGE_JOB”
ORA-46269: Conflicting operation on audit files
ORA-06512: at “SYS.DBMS_AUDIT_MGMT”, line 177
ORA-06512: at “SYS.DBMS_AUDIT_MGMT”, line 3543
Solution:
Check the audit jobs timing scheduled in Oracle database. you can choose the different timing of the scheduled jobs from rest of jobs:
Check the timing of jobs:
select OWNER,JOB_NAME,to_char(last_start_date,'DD-MM-YY HH24:MI:SS') Last_date_time, to_char(next_run_date,'DD-MM-YY HH24:MI:SS') Next_Date_Time, JOB_ACTION from DBA_SCHEDULER_JOBS;
OWNER JOB_NAME LAST_DATE_TIME NEXT_DATE_TIME JOB_ACTION
----- ---------------------------- ----------------- ----------------- -------------------------------------------------------
SYS DAILY_XML_AUDIT_PURGE_JOB 03-08-21 08:36:49 04-02-21 08:36:49 BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(8, TRUE, 1); END;
SYS DAILY_OS_AUDIT_PURGE_JOB 03-08-21 08:36:49 04-02-21 08:36:49 BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(4, TRUE, 1); END;
SYS DAILY_FGA_AUDIT_PURGE_JOB 03-02-21 08:36:49 04-02-21 08:36:49 BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(2, TRUE, 1); END;
SYS DAILY_STD_AUDIT_PURGE_JOB 03-02-21 08:36:49 04-02-21 08:36:49 BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(1, TRUE, 1); END;
You can change the timing on dbms_Scheduler for the job:
--- Scheduled job with new timing
BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE (
name => 'DAILY_OS_AUDIT_PURGE_JOB',
attribute => 'repeat_interval',
value => 'freq=daily; byhour=2');
END;
DISABLE THE JOB:
you can also disable the job temporary for see error occurred again on next scheduled timing:
begin
dbms_scheduler.disable( '"SYS"."DAILY_OS_AUDIT_PURGE_JOB"' );
END;
/