Ask the Expert

Disabling default auditing

Oracle 8i creates audit trace files in the oracle_home/audit directory by default for some actions like startup and shutdown. How to disable this default auditing?

    Requires Free Membership to View

There is no published parameter to stop this type of auditing. And in my opinion, you probably should not stop this auditing. If someone ever shuts down your instance without permission, you'd like to know who did this action.

Unfortunately, this means you may have many audit files out there. I set up a weekly script to delete all files more than one month old in this directory. In Unix, this is very easy. The following command will remove these files that are more than 30 days old:

find /home/oracle/9.2.0/rdbms/audit/*.aud -type f -mtime +30 -exec rm
-f {} ;
Simply schedule this command in cron. If you are not running Unix or Linux, then I do have an alternative for any platform that runs Perl. I have a Perl script on my Web site under the "scripts" section titled "delete_old.zip." This Perl script can be modified to perform the same thing as the above Unix command. So you can do this on Windows as well. Simply modify the script to suit your needs and schedule it on a regular basis.

This was first published in November 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: