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
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
Received on Tue May 30 2000 - 20:13:05 CDT
