Enable Audit in Oracle Database

 To enable audit in Oracle database, follow the below steps

Database Steps:

      ·        Check parameter file is pfile or spfile

·        Note down the audit parameters before change

·        Create pfile from spfile and make the below audit parameter changes

·        Shutdown the database

·        Change the audit parameters in pfile.

a.      audit_file_dest =   <provide audit path on O/S>

b.      audit_trail  = os

c.      audit_sys_operations=true

       ·    Create spfile from pfile

       ·     Enable audit on the required users  using the below command.

                audit all by <user name>  by access