Tuesday, February 22, 2011

Manage Oracle 11gR2 ASM and RDBMS audit logs on Linux.

If you don't change anything after a new 11gR2 ASM and RDBMS installation, your system's local file systems will slowly fill up with several thousands of audit log files. To fix this problem, you can either:

  1. Modify the system's crontab to clean the audit logs directory periodically
  2. Configure both the ASM and the RDBMS audit parameters to use syslog.
The crontab solution is easy, but I prefer the syslog solution because: