Script to enable Unified Auditing at Db level

Please find the below steps to enable the same.

create audit policy audit_all actions all only toplevel;

audit policy audit_all by user1,user2,user3;

audit policy audit_all by sys,system;

CONNECT / AS SYSDBA

SELECT VALUE FROM V$OPTION WHERE PARAMETER = ‘Unified Auditing’; – FALSE

SHOW PARAMETER unified_audit_common_systemlog

ALTER SYSTEM SET unified_audit_common_systemlog=’local0.info’ SCOPE=SPFILE;

ALTER SYSTEM SET UNIFIED_AUDIT_SYSTEMLOG =’local1.info’ SCOPE=SPFILE;

ALTER SYSTEM SET audit_trail = ‘XML’,’EXTENDED’ SCOPE=SPFILE;

shut immediate

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk uniaud_on ioracle

SELECT VALUE FROM V$OPTION WHERE PARAMETER = ‘Unified Auditing’; – TRUE