Q

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?

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?
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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close