Changing Audit_trail from DB to OS.
Hi Colleagues
I am planing to change the DB audit_trail from DB to OS value on my DB that is build on RAC two nodes connect to remote physical data guard . I wan't to implement this with minimum user interruption. My GRID/DB version is 12.2.0.1 , the below is going to be my steps :
1- ALTER SYSTEM SET AUDIT_TRAIL=OS sid='*' SCOPE=SPFILE;
2- ALTER SYSTEM SET AUDIT_SYSLOG_LEVEL="local1.warning" sid='*' SCOPE=SPFILE;
3- local1.warning/var/log/audit.log ( this will in OS level, for example in Solaris 11.3 this shall be in "vi /etc/syslog.conf") and restart syslog.