Re: Oracle Auditing

From: The Magnet <art_at_unsu.com>
Date: Tue, 16 Mar 2010 09:46:21 -0700 (PDT)
Message-ID: <ae94188b-7e82-462b-bba6-03275429e22f_at_u9g2000yqb.googlegroups.com>

On Mar 16, 10:54 am, Eric <e..._at_deptj.eu> wrote:
> gazzag <gar..._at_jamms.org> wrote:
> > On 16 Mar, 13:21, The Magnet <a..._at_unsu.com> wrote:
>
> > Are you sure that you're checking the right database?  The error is:
>
> >  RMAN-04005: error from target database:
> >  ORA-09925: Unable to create audit trail file
> >  Linux-x86_64 Error: 2: No such file or directory
>
> > Which database are you running the "show parameter" command on?  The
> > error appears to be coming from your RMAN repository.
>
> > HTH
> > -g
>
> "error from target database"?? This is the database to be backed up, not
> the repository. The OP may not even have a repository.
>
> What ve definitely does not have is a writable directory at the location
> specified by the audit_file_dest parameter.
>
> Nothing to do with turning auditing on or off either.
>
> Eric

Well, the directory where all the audit files are appearing is not the default Oracle audit directory. So, he changed the location when he enabled auditing. We never had this before he switched the auditing on and off. We are using a control file, not a repository.

Is it possible that RMAN needs some sort of change also? And, the database has been bounced since then.

Worst case, put it back and remove the files daily, do not want that solution though.

Arthur Received on Tue Mar 16 2010 - 11:46:21 CDT