Re: Fw: RE: Can the Diag_Dest filesystem fill up??

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Mon, 9 Feb 2009 08:43:25 +0100
Message-ID: <486b2b610902082343t4f46cdbdp95e6ad9dcfbb0ea9_at_mail.gmail.com>



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_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch


On Mon, Feb 9, 2009 at 8:22 AM, patrick obrien <po04541_at_yahoo.com> 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_at_rsiz.com>* wrote:
>
> From: Mark W. Farnham <mwf_at_rsiz.com>
> Subject: RE: Can the Diag_Dest filesystem fill up??
> To: cicciuxdba_at_gmail.com, po04541_at_yahoo.com
> Cc: "'Oracle L'" <oracle-l_at_freelists.org>
> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Guillermo Alan Bort
> Sent: Sunday, February 08, 2009 4:34 PM
> To: po04541_at_yahoo.com
> 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_at_yahoo.com> 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.
> >
> >
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 09 2009 - 01:43:25 CST

Original text of this message