One thing I like about 'sync' is it will fail silently. i.e.., if
you don't have privs, it will not complain but pretend that it completed
successfully, which is correct, it completed successfully but didn't do
anything.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
Thanks for all the wonderful and interesting responses - esp. Tim
Gorman. I think that is what I needed. Sorry to resurface that old
issue again. Mladen, you too? Did the nuns hit your knuckles with
a ruler as well?
Hey Tom,
You can send me $111 3 times and I'll be happy!
;o)
-Scott Stefick
how about if I send you $1,111,111.11 3
times.
It's a superstition. Whole christian mithology is based on
the number 3. We have Holy Trinity, we have 3 places to go when we
transcend
into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of
personality, according to Freud (libido, ego,
super-ego),
to make the whole story short, number 3 is sort of a mystical
number in christian mithology. Now, please send me
$3,333,333.33
-- Mladen Gogala Oracle DBA
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 -----
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 [EMAIL PROTECTED]
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:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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.
Note:
This message is for the named person's use only. It may
contain confidential, proprietary or legally privileged
information. No confidentiality or privilege is waived or lost by
any mistransmission. If you receive this message in
error, please immediately delete it and all copies of it from your
system, destroy any hard copies of it and notify the sender. You
must not, directly or indirectly, use, disclose, distribute, print, or
copy any part of this message if you are not the intended
recipient. Wang Trading
LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized
to state them to be the views of any such entity.
|