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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.