Fw: was RE: core_dump_dest = /dev/null? --> audit_file_dest

Alex,

    This is interesting. I do not have access to a Unix machine right now, else I would try it out.

    Does this mean that the sysdba cannot connect to shut it down, as it is trying to write the audit file?

    If not I do not see why a shutdown abort will not bring it down.

    Probably a kill of the Oracle processes should work?

    Regards.

Tony

--
S. Anthony Sequeira

Wait for the ricochet

Opinions expressed herein are my own and do
not necessarily represent those of my employer
----- Original Message -----
From: Afanassiev, Alex <Alex.Afanassiev_at_team.telstra.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: 30 May 2000 04:48
Subject: RE: was RE: core_dump_dest = /dev/null? --> audit_file_dest




> 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

> > 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