Disable Oracle Audit Trail for event viewer in Windows

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;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply