Database - RAC/Scalability (MOSC)

MOSC Banner

Changing Audit_trail from DB to OS.

edited Oct 27, 2019 5:08AM in Database - RAC/Scalability (MOSC) 9 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center