Disable Oracle Audit Trail for event viewer in Windows
First need to disable the AUDIT_TRAIL parameter in Oracle for disable the AUDIT log.
1. Check the parameter details
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string C:\ORACLE18C\ADMIN\XE\ADUMP
audit_sys_operations boolean TRUE
audit_trail string DB
unified_audit_sga_queue_size integer 1048576
unified_audit_systemlog boolean FALSE
2. If AUDIT_TRAIL parameter value is (DB | OS | db,extended | xml | xml,extended ) then its enabled.
For disable make it NONE.
ALTER SYSTEM SET AUDIT_TRAIL=NONE SCOPE=SPFILE;
Note: You need to restart the Oracle DB for making the parameter effective.
3. For disable the Audit in Event viewer, you should also make the AUDIT_SYS_OPERATIONS parameter to false.
ALTER SYSTEM SET AUDIT_SYS_OPERATIONS =FALSE SCOPE=SPFILE;
Note: You need to restart the Oracle DB for making the parameter effective.
4. Restart the Database for make the parameter in effect.
Shutdown immediate;
Startup;