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: URGENT!!! My 9i databases are not shutting down cleanly/cons

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Thu, 21 Aug 2003 20:49:25 -0800
Message-ID: <F001.005CC128.20030821204925@fatcity.com>


$ su - root
Password:

[root_at_medo root]#
[root_at_medo root]#
[root_at_medo root]#
[root_at_medo root]#
[root_at_medo root]# sync
[root_at_medo root]#

On 2003.08.22 00:34, Tim Gorman wrote:
> I think the reasoning falls somewhere between the utterly rational and the
> insanely superstitious...
>
> Iıve known people who would keep repeating ³sync² until their fingers
> started tripping over one another, so I tend to see three ³sync²s as the
> minimum. At least, thatıs how it was explained to me 20 years ago: ³by the
> time you type it in for the third time, the first one has done the job²...
>
> Go ahead, type in ³sync² just once. I dare ya...
>
>
>
> on 8/21/03 9:04 AM, Tanel Poder at tanel.poder.003_at_mail.ee wrote:
>
> > Hi!
> >
> > I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3*
> > syncs everything has been written to disk? Or it more like that after that
> > number of syncs, most of the changes should be on disk? (sounds stupid)
> >
> > Tanel.
> >> ----- Original Message -----
> >> From: Tim Gorman <mailto:tim_at_sagelogix.com>
> >> To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com>
> >> Sent: Thursday, August 21, 2003 12:04 AM
> >> Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
> >>
> >> I’d suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior
> to
> >> the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to
> make
> >> me feel better)...
> >>
> >> Does anyone remember the UNIX mantra of entering “sync; sync; sync” before
> >> “halt”? :-)
> >>
> >>
> >>
> >> on 8/20/03 11:09 AM, April Wells at awells_at_csedge.com wrote:
> >>
> >>> We have started waiting 90 min then do shutdown abort, startup, shutdown
> >>> immediate
> >>>
> >>> April Wells
> >>> Oracle DBA/Oracle Apps DBA
> >>> Corporate Systems
> >>> Amarillo Texas
> >>>
> >>> Few people really enjoy the simple pleasure of flying a kite
> >>> Adam Wells age 11
> >>>>
> >>>> -----Original Message-----
> >>>> From: Paula_Stankus_at_doh.state.fl.us
> [mailto:Paula_Stankus_at_doh.state.fl.us]
> >>>> Sent: Wednesday, August 20, 2003 12:54 PM
> >>>> To: Multiple recipients of list ORACLE-L
> >>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
> cleanly/cons
> >>>>
> >>>> Which brings up that thread of - if they are hard to shutdown and
> possibly
> >>>> going to crash anyway then ..... why not just wait some period of time
> and
> >>>> do the old shutdown abort.
> >>>>> -----Original Message-----
> >>>>> From: April Wells [mailto:awells_at_csedge.com]
> >>>>> Sent: Wednesday, August 20, 2003 1:00 PM
> >>>>> To: Multiple recipients of list ORACLE-L
> >>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
> cleanly/cons
> >>>>>
> >>>>> We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting
> them
> >>>>> to shutdown elegantly... and they sometimes crash
> >>>>>
> >>>>> April Wells
> >>>>> Oracle DBA/Oracle Apps DBA
> >>>>> Corporate Systems
> >>>>> Amarillo Texas
> >>>>>
> >>>>> Few people really enjoy the simple pleasure of flying a kite
> >>>>> Adam Wells age 11
> >>>>>>
> >>>>>> -----Original Message-----
> >>>>>> From: Paula_Stankus_at_doh.state.fl.us
> >>>>>> [mailto:Paula_Stankus_at_doh.state.fl.us]
> >>>>>> Sent: Wednesday, August 20, 2003 11:50 AM
> >>>>>> To: Multiple recipients of list ORACLE-L
> >>>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
> cleanly/cons
> >>>>>>
> >>>>>> BTW, nothing happening in terms of processes that would hang-up the
> >>>>>> system. Also, I have check alert and trace files and there are no
> >>>>>> obvious errors.
> >>>>>>> -----Original Message-----
> >>>>>>> From: Paula_Stankus_at_doh.state.fl.us
> >>>>>>> [mailto:Paula_Stankus_at_doh.state.fl.us]
> >>>>>>> Sent: Wednesday, August 20, 2003 12:25 PM
> >>>>>>> To: Multiple recipients of list ORACLE-L
> >>>>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
> >>>>>>> cleanly/cons
> >>>>>>>
> >>>>>>>
> >>>>>>> There seems to be a problem with consistent shutdowns in 9i
> >>>>>>>
> >>>>>>> Oracle 9i 64bit
> >>>>>>>
> >>>>>>> 9.0.1.3.0 - infrastructure database that comes with the application
> >>>>>>> server
> >>>>>>> 9.2.0.1.0 - that is the version of RDBMS we are running.
> >>>>>>>
> >>>>>>> Does anyone have problems shutting down their databases consistently
> >>>>>>> with 9i?????
> >>>>>
> >>>>> The information contained in this communication, including attachments,
> is
> >>>>> strictly
> >>>>> confidential and for the intended use of the addressee only; it may
> also
> >>>>> contain
> >>>>> proprietary, price sensitive, or legally privileged information. Notice
> is
> >>>>> hereby given that
> >>>>> any disclosure, distribution, dissemination, use, or copying of the
> >>>>> information by anyone
> >>>>> other than the intended recipient is strictly prohibited and may be
> >>>>> illegal. If you have
> >>>>> received this communication in error, please notify the sender
> immediately
> >>>>> by reply e-mail,
> >>>>> delete this communication, and destroy all copies.
> >>>>>
> >>>>>
> >>>>> Corporate Systems, Inc. has taken reasonable precautions to ensure that
> >>>>> any attachment to
> >>>>> this e-mail has been swept for viruses. We specifically disclaim all
> >>>>> liability and will
> >>>>> accept no responsibility for any damage sustained as a result of
> software
> >>>>> viruses and advise
> >>>>> you to carry out your own virus checks before opening any attachment.
> >>> The information contained in this communication, including attachments,
> is
> >>> strictly
> >>> confidential and for the intended use of the addressee only; it may also
> >>> contain
> >>> proprietary, price sensitive, or legally privileged information. Notice
> is
> >>> hereby given that
> >>> any disclosure, distribution, dissemination, use, or copying of the
> >>> information by anyone
> >>> other than the intended recipient is strictly prohibited and may be
> illegal.
> >>> If you have
> >>> received this communication in error, please notify the sender
> immediately
> >>> by reply e-mail,
> >>> delete this communication, and destroy all copies.
> >>>
> >>>
> >>> Corporate Systems, Inc. has taken reasonable precautions to ensure that
> any
> >>> attachment to
> >>> this e-mail has been swept for viruses. We specifically disclaim all
> >>> liability and will
> >>> accept no responsibility for any damage sustained as a result of software
> >>> viruses and advise
> >>> you to carry out your own virus checks before opening any attachment.
> >>>
> >>
> >
>
>
>

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Aug 21 2003 - 23:49:25 CDT

Original text of this message

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