Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: was RE: core_dump_dest = /dev/null? --> audit_file_dest

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

From: S. Anthony Sequeira <Sequeira_at_lineone.net>
Date: Wed, 31 May 2000 06:41:00 +0100
Message-Id: <10513.107208@fatcity.com> 





Ok thanks.  I will try it out with Unix when I can.



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: <Sequeira_at_lineone.net>
Cc: <ORACLE-L_at_fatcity.com>
Sent: 31 May 2000 02:13
Subject: RE: was RE: core_dump_dest = /dev/null? --> audit_file_dest




> Hi Tony

>

> No, it does not mean that the sysdba cannot connect to shut it down.

> I had the problem when I was trying to shut the database  down (either

> immediate or abort).

> As you said '... probably a kill of the Oracle processes should

work...'


> (you'll tell when you test it yourself :)), but I prefer a cleaner way

that


> is why I relinked /dev/null to the file system, so shutdown immediate

was


> successful.

>

> Also I must admit that I cannot replicate the problem now as starting

up and


> shutting down the instance with

> audit_file_dest = /dev/null does not introduce the problem at all as

Oracle


> writes the audit file to the default destination

($ORACLE_HOME/rdbms/aduit)


>

> All above is on Oracle 7.3.4.3 and 8.1.6 on Solaris 2.6

>

> See example below

>

> Database mounted.

> Database opened.

> SVRMGR> show parameter audit_

> NAME                                TYPE    VALUE

> ----------------------------------- ------- --------------------------

----


> audit_file_dest                     string  /dev/null

> audit_trail                         string  NONE

> SVRMGR> !ls -lt /dev/null

> lrwxrwxrwx   1 root     other         27 Jan  5 14:21 /dev/null ->

> ../devices/pseudo/mm_at_0:null

> SVRMGR> !date

> Wed May 31 11:01:18 EST 2000

> SVRMGR> shutdown immediate

> Database closed.

> Database dismounted.

> ORACLE instance shut down.

> SVRMGR> !ls -lt $ORACLE_HOME/rdbms/audit

> total 4

> -rw-r-----   1 oracle   dba         1727 May 31 11:01 ora_11182.aud

> SVRMGR>

>

>

>

> 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: S. Anthony Sequeira [SMTP:Sequeira_at_lineone.net]

> > Sent: Wednesday, May 31, 2000 6:14 AM

> > To: Multiple recipients of list ORACLE-L

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

> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

> > Sent: 30 May 2000 04:48

> >

> >

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

> > > (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: S. Anthony Sequeira

> >   INET: Sequeira_at_lineone.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



Received on Wed May 31 2000 - 00:41:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US