Wednesday, December 14, 2011

Enabling Auditing in the database

The auditing option once enabled tells oracle where to put the auditing information. It can be in either OS or in database (sys.AUD$).

Sending the audit information to the database or OS is controlled by AUDIT_TRAIL parameter.

SQL> alter system set AUDIT_TRAIL = DB scope=SPFILE;

When this parameter is set to OS, XML or XML_EXTENDED the exact location of the audit data is controlled by AUDIT_FILE_DEST and  AUDIT_SYSLOG_LEVEL

 SQL> show parameter AUDIT_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/oracle/admin/wh2/adump

'/u01/app/oracle/admin/wh2/adump' is the location where audit information is written at the OS level

No comments:

Post a Comment