How to enable AUDIT_TRIAL in DB 19c
Hi,
We are using the application 12.2.10 and DB 19C. We need to enable the AUDIT_TRIAL in database. For this enable we got the below document in oracle support.
In that document, we have updated the sql which is mentioned below,
The following statement sets the db value for the AUDIT_TRAIL parameter. The new value takes effect after the database is restarted.
CopySQL> alter system set AUDIT_TRAIL=db scope=spfile;System altered.
But when we check the below sql for audit is enable or not,
To Confirm if you have enabled Pure Unified Auditing:
SQL> select parameter,value from v$option where parameter='Unified Auditing'; (it should say TRUE)
0