Re: Fw: RE: Can the Diag_Dest filesystem fill up??
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: po04541@xxxxxxxxx
- Date: Mon, 9 Feb 2009 08:43:25 +0100
It doesn't matter if auditing has explicitly been turned on or not. Oracle
automatically creates an audit file for every connect made AS SYSDBA, as
well as other operations, such as a startup or shutdown. And lack of space
in the audit_file_dest will prevent these from succeeding.
Cheers
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Mon, Feb 9, 2009 at 8:22 AM, patrick obrien <po04541@xxxxxxxxx> wrote:
> Hello All,
>
> Auditing is not turned on.
> And redo and archiving is handled in 2 more separate filesystems.
> So, diag_dest is on its own.
> Admittedly, adump holds *aud files; I really need to look closely at what
> those are.
>
> / The real problem is this; I clean out the *aud and *trc files and this
> darn filesystem will not release the space. Doing a 'du' shows something
> like 500Megs, df shows 2 Gigs.
>
>
> Patrick.
>
>
>
> --- On *Sun, 2/8/09, Mark W. Farnham <mwf@xxxxxxxx>* wrote:
>
> From: Mark W. Farnham <mwf@xxxxxxxx>
> Subject: RE: Can the Diag_Dest filesystem fill up??
> To: cicciuxdba@xxxxxxxxx, po04541@xxxxxxxxx
> Cc: "'Oracle L'" <oracle-l@xxxxxxxxxxxxx>
> Date: Sunday, February 8, 2009, 10:37 PM
>
> And of course the file system being full wouldn't prevent re-writing the
> contents of the existing on line logs (not to be considered a recommendation
> to share .../diag/... and online logs, just acknowledging the possibility).
>
> If arch is shared with /diag/, then that would get the archiver stuck.
> (again, not a recommendation). It might also mean that news that the
> archiver is stuck might not get printed. But if you were to share arch and
> diag, diag getting full should tip you off...
>
> mwf
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Guillermo Alan Bort
> Sent: Sunday, February 08, 2009 4:34 PM
> To: po04541@xxxxxxxxx
> Cc: Oracle L
> Subject: Re: Can the Diag_Dest filesystem fill up??
>
> yes, Oracle wouldn't hang up because logs cannot be written. (this is
> not true fro online redo logfiles,
>
> obviously.
>
> hth
> Alan Bort
> Oracle Certified Professional
>
>
>
> On Sun, Feb 8, 2009 at 6:40 PM, patrick obrien <po04541@xxxxxxxxx> wrote:
> > Hello Oracle fans,
> >
> > Can the Diag_Dest filesystem fill up and Oracle 10g still work fine?
> >
> > I'm running Oracle 10G in an AIX Virtual SAN environment. My
> > /u01/app/oracle/*/admin/*dump filesystem likes to fill up with *.trc files
> > etc. I do NOT have auditing turned on.
> >
> > Will Oracle continue to run fine if this filesystem fills up?
> >
> > Thank you All.
> > Patrick.
> >
> >
> >
> >
> >
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
Other related posts:
