| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
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: >>
>>>> >>>> -----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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: tim_at_sagelogix.com 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:34:24 CDT
 |
 |