I was NOT advising to redirect /dev/null to the file system.
I said in case if the database is started with audit_file_dest=/dev/null
and
cannot be shutdown - ' to resolve the problem TEMPORARY ...' relink
/dev/null to the file system to shut down the database.
With regards
Alex Afanassiev
Oracle DBA, TOC Operations Support/IDO
Tel: (03) 8 661 20 61
Fax: (03) 9 650 36 74
> -----Original Message-----
> From: Dax Mickelson [SMTP:dax.mickelson_at_lightcom.net]
> Sent: Tuesday, May 30, 2000 12:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: was RE: core_dump_dest = /dev/null? --> audit_file_dest
>
>
> Isn't it bad to write to /dev/null? I thought /dev/null was just an empty
>
> file that you used to copy over other files (i.e. cp /dev/null
> /home/luser/big_file.txt).
>
> If you attempt to write to /dev/null it will still take up hard drive
> space
> (I think).
>
> Maybe set your core dump to a specific directory as you are supposed to
> and
> then have the cron rm the dir and then recreate it.
>
> At 17:44 2000-05-29 -0800, you wrote:
> >Hi Leng
> >
> >I think is not quite correct to state '...was never able to startup the
> >database again...' .
> >It is possible to startup the database having pointed audit_file_dest to
> >/dev/null.
> >The difficult part is to shut it down. It is possible to resolve the
> >problem linking temporary /dev/null to the any file system (example
> /tmp)
> >instead of ../devices/pseudo/...
> >
> >With regards
> >Alex Afanassiev
> >Oracle DBA, TOC Operations Support/IDO
> >Tel: (03) 8 661 20 61
> >Fax: (03) 9 650 36 74
> >
> >
> > > -----Original Message-----
> > > From: Leng Kaing [SMTP:lkaing_at_yahoo.com]
> > > Sent: Monday, May 29, 2000 6:56 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: core_dump_dest = /dev/null?
> > >
> > > Ok, pointing core_dump_dest may be ok, but not
> > > audit_file_dest.
> > >
> > > I know of a friend who had pointed audit_file_dest to
> > > /dev/null and was never able to startup the database
> > > again.
> > >
> > > For those of you who would like to experiment, just
> > > try and see what you get.
> > >
> > > Leng.
> > >
> > > =====
> > > Leng M Kaing
> > > Email: lkaing_at_yahoo.com
> > > Mobile: +61-3-411-020-781
> > > AUSOUG-Vic: http://www.ausoug.org/vic/
> > > Web: http://dingo.vu.edu.au/~leng/
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Kick off your party with Yahoo! Invites.
> > > http://invites.yahoo.com/
> > > --
> > > Author: =?iso-8859-1?q?Leng=20Kaing?=
> > > INET: lkaing_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >--
> >Author: Afanassiev, Alex
> > INET: Alex.Afanassiev_at_team.telstra.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> --------------------------------------------------------------------------
> ------------
> Dax Mickelson -- CCNA, CCAI, OCP/DBO, CNA
>
> ____EFGH_JKLM___QRSTUVWXYZ
> --------------------------------------------------------------------------
> -----------
> -
>
> --
> Author: Dax Mickelson
> INET: dax.mickelson_at_lightcom.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Mon May 29 2000 - 21:32:59 CDT