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

John, thats just hilarious, i remember doing sync;sync;sync all the time and still once in a while type sync on a unix box :)

joe

John Kanagaraj wrote:

> Tanel,
>
> It is more like 'two is company, three is a crowd'. The 'sync; sync;
> sync' was used in the days of yore when the disk controller was flaky
> and you had a few seconds of 'think time' on your hand in between
> commands. As Hemant says, it became a habit which still dogs me after
> 19 years - I have my (younger) colleagues here asking 'what is sync'?
>
> This was far better than my initial days when we used 8" AC Floppy
> drives whose speed varied with the electricity supply frequency and we
> had to use a frequency meter to note down the frequency during a
> floppy recording. [Btw - the term 'floppy' came from this media which
> was a flexible plastic based magnetic disk enclosed in a flexible -
> floppy - cover. And there was a 5 1/4" version before it finally
> became the 3 1/2" 'firm' disk]. I also worked on card punch IBM
> machines with 64 Kb RAM and 2 Mb (that right 2 MB!) system drives.
>
> Now back to Oracle stuff before Jared bears down on us :)
>
> John
>
> -----Original Message-----
> *From:* Hemant K Chitale [mailto:hkchital_at_singnet.com.sg]
> *Sent:* Thursday, August 21, 2003 9:19 AM
> *To:* Multiple recipients of list ORACLE-L
> *Subject:* Re: URGENT!!! My 9i databases are not shutting down
>
>
> Habit. The "sync" command is picked up by the scheduler "sched"
> and may not be executed immediately.
> With three "sync" calls, at least one goes through by the time you
> are ready to type in "shutdown" or "init 0"
>
> Hemant
> At 08:04 AM 21-08-03 -0800, you 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
>> <mailto: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.
>>
> Hemant K Chitale
> Oracle 9i Database Administrator Certified Professional
> My personal web site is : http://hkchital.tripod.com
>
> <http://hkchital.tripod.com/>-- Please see the official ORACLE-L
> FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET:
> hkchital_at_singnet.com.sg 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).
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.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).