Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-09945: Unable to initialize the audit trail file

Re: ORA-09945: Unable to initialize the audit trail file

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Sun, 14 Dec 2003 20:19:24 +0000
Message-ID: <8SyfsoAMXM3$Qxyx@peterfinnigan.demon.co.uk>


Hi

the error you have below tells you the issue, you have exceeded the quota on a file system, the one that hosts the audit trail. Whether you delete the files depends on what you do with them as an organisation? If you wish to use this audit trail implement a save and purge strategy. Also you should consider a policy for reviewing the files to detect unauthorised  access to your databases. This should be part of an overall organisation security policy.

If i were you i would compress / tar / zip the files up and move to a safe location for now and remove them from the directory / file system in question to free up the space.

I have a paper on auditing Oracle - "An introduction to simple Oracle auditing" see http://www.petefinnigan.com/orasec.htm if you are interested, its primarily about database audit trail though.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
Received on Sun Dec 14 2003 - 14:19:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US