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

[Tanel Poder]

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



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 
  
  To: Multiple recipients of list ORACLE-L 
  
  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 
immediateApril 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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consWhich 
  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 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have 
trouble getting them to shutdown elegantly... and they sometimes 
crashApril 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 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consBTW, 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 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consThere 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

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

[Hemant K Chitale]

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 
To: Multiple recipients of
list ORACLE-L 
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.


Hemant K Chitale
Oracle 9i

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

[Mladen Gogala]

Title: Message



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 GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel 
  PoderSent: Thursday, August 21, 2003 12:05 PMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i 
  databases are not shutting down cleanly/cons
  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 

To: Multiple recipients of list ORACLE-L 

Sent: Thursday, August 21, 2003 12:04 
AM
Subject: Re: URGENT!!! My 9i databases 
are not shutting down cleanly/cons
Id 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 
  immediateApril 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 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consWhich 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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we 
  have trouble getting them to shutdown elegantly... and they sometimes 
  crashApril 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 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consBTW, 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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consThere 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

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

[John Kanagaraj]

Title: Message



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:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 9:19 AMTo: Multiple 
recipients of list ORACLE-LSubject: 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"HemantAt 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 
  To: Multiple recipients of 
  list ORACLE-L 
  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 inte

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

[Joe Testa]

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:[EMAIL PROTECTED]
*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:[EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L
mailto:[EMAIL PROTECTED] 
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]
mailto:[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

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

[Mercadante, Thomas F]

Title: Message



how 
about if I send you $1,111,111.11 3 times.


  -Original Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  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 GogalaOracle DBA 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Tanel PoderSent: Thursday, August 21, 2003 12:05 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
URGENT!!! My 9i databases are not shutting down 
cleanly/cons
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 
  
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, August 21, 2003 12:04 
  AM
  Subject: Re: URGENT!!! My 9i 
  databases are not shutting down cleanly/cons
  Id 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 immediateApril 
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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWhich 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 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we 
have trouble getting them to shutdown elegantly... and they 
sometimes crashApril 
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 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consBTW, 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 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consThere 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

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

[Stefick Ronald S Contr ESC/HRIDD]

Title: Message



Hey 
Tom, 
You 
can send me $111 3 times and I'll be happy! ;o)

-Scott 
Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 
  21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how 
  about if I send you $1,111,111.11 3 times.
  
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
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 GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  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 
To: Multiple recipients of list 
ORACLE-L 
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 immediateApril 
  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 PMTo: Multiple recipients of list 
    ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
    shutting down cleanly/consWhich 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 PMTo: Multiple recipients of list 
      ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
      shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 
  we have trouble getting them to shutdown elegantly... and they 
  sometimes crashApril 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 AMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consBTW, 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 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: URGENT!!! 
      My 9i databases are not shutting down 
  cleanly/consThere seems to be a problem with consistent shutdowns 
  i

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

[Mladen Gogala]

I will not object to anything. You can send me $1 and I'll gladly take it

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

[Paula_Stankus]

Title: Message



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?



  -Original Message-From: Stefick Ronald S Contr 
  ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
  August 21, 2003 2:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  Hey 
  Tom, 
  You 
  can send me $111 3 times and I'll be happy! ;o)
  
  -Scott Stefick
  

-Original Message-From: Mercadante, 
Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 
21, 2003 1:40 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
how about if I send you $1,111,111.11 3 
times.


  -Original Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  2:04 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  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 GogalaOracle DBA 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Tanel PoderSent: Thursday, August 21, 2003 12:05 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Re: URGENT!!! My 9i databases are not shutting down 
cleanly/cons
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 
  To: Multiple recipients of list 
  ORACLE-L 
  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 immediateApril 
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 PMTo: Multiple recipients of list 
      ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
      shutting down cleanly/consWhich 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 PMTo: Multiple recipients of list 
    ORACLE-LSubject: RE: URGENT!!! My 9i databases are 
    not shutting down cleanly/consWe do, Paula... both in 
9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown 
elegantly... and they sometimes 
crashApril 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 AMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: URGENT!!! 
      My 9i databases are not shutting down 
  cleanly/consBTW, nothing happening i

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

[Jamadagni, Rajendra]

Title: Message



One thingI 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 ! 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  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?
  
  
  
-Original Message-From: Stefick Ronald S Contr 
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
August 21, 2003 2:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
Hey Tom, 
You can send me $111 3 times and I'll be happy! 
;o)

-Scott Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, 
  August 21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how about if I send you $1,111,111.11 3 
  times.
  
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
2003 2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/cons
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 GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not 
  shutting down cleanly/cons
  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 
To: Multiple recipients of list 
ORACLE-L 
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 
  immediateApril 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 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consWhich 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 
 

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

[Mercadante, Thomas F]

Title: Message



"Did 
the nuns hit your knuckles with a ruler as well?"

three 
times for the father, son and holy ghost!


PS - 
Jared, is this enough???

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  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?
  
  
  
-Original Message-From: Stefick Ronald S Contr 
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
August 21, 2003 2:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
Hey Tom, 
You can send me $111 3 times and I'll be happy! 
;o)

-Scott Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, 
  August 21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how about if I send you $1,111,111.11 3 
  times.
  
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
2003 2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
    shutting down cleanly/cons
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 GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not 
  shutting down cleanly/cons
  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 
To: Multiple recipients of list 
ORACLE-L 
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 
  immediateApril 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 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
    9i databases are not shutting down 
cleanly/consWhich 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 PMTo: Multiple recipients of list 
          ORACLE-LSubject: RE: URGENT!!! My 9i databases are 
  not shutting down cleanly/consWe do, Paula... both 
  in 9.0.1.3 and 9.2.0.

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

[Jared . Still]

Um, yeah.








Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2003 12:39 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: URGENT!!! My 9i databases are not shutting down cleanly/cons


Did the nuns hit your knuckles with a ruler as well?

three times for the father, son and holy ghost!


PS - Jared, is this enough???
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

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?


-Original Message-
From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Hey Tom, 
You can send me $111 3 times and I'll be happy! ;o)

-Scott Stefick
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

how about if I send you $1,111,111.11  3 times.

-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

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 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder
Sent: Thursday, August 21, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

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 
To: Multiple recipients of list ORACLE-L 
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

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

[Mladen Gogala]

Title: Message



Yes 
they did, despite the fact that Croatia had communism while I was growing 
up.


--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/consUm, 
  yeah. 
  


  
  "Mercadante, Thomas F" 
[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
08/21/2003 12:39 PM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] cc:

 Subject:RE: URGENT!!! My 9i 
    databases are not shutting down 
  cleanly/cons"Did the nuns hit your knuckles with a ruler as 
  well?"  three times for the father, son and holy 
  ghost!   PS - Jared, is this enough??? -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consThanks 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?   -Original Message-From: Stefick Ronald S Contr 
  ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
  August 21, 2003 2:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consHey Tom, 
  You can send me $111 3 times and 
  I'll be happy! ;o)  -Scott 
  Stefick -Original 
  Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 
  1:40 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/conshow about if I 
  send you $1,111,111.11  3 times.  -Original 
  Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/consIt'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 
  GogalaOracle DBA -Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: 
  Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting 
  down cleanly/consHi!  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 To: Multiple recipients of list ORACLE-L 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 
  immediateApril 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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consWhich 
  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 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 
  9.2.0.2 we have trouble getting them to shutdown elegantly... and they 
  sometimes crashApril Wells 
  Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo Texas 
  Few people reall

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

[Thater, William]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  4:04 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  Um, yeah. [Shrek]
  sync
  sync
  sync
  
  move 
  thread to [EMAIL PROTECTED]
  
  --
  Bill 
  "Shrek" Thater ORACLE 
  DBA BAARF Party member #25
   
  [EMAIL PROTECTED]
  
  A 
  good intention but fixed and resolute - bent on high and holy ends, we shall 
  find means to them on every side and at every moment; and even obstacles and 
  opposition will but make us "like the fabled spectre-ships," which sail the 
  fastest in the very teeth of the wind. - Ralph Waldo 
  Emerson
  

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

[Paul Baumgartel]

A couple of corrections are in order here.  First, some Christians
might object to your characterizing the Holy Trinity, et. al. as
mythology.  Second, I thought we became food for worms, not ants.


--- Mladen Gogala [EMAIL PROTECTED] wrote:
 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 
 
 
 -Original Message-
 Tanel Poder
 Sent: Thursday, August 21, 2003 12:05 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 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 - 
 To: Multiple recipients of list ORACLE-L
 mailto:[EMAIL PROTECTED]  
 Sent: Thursday, August 21, 2003 12:04 AM
 
 
 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-
 ]
 Sent: Wednesday, August 20, 2003 12:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
 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-
 Sent: Wednesday, August 20, 2003 1:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 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-
 ]
 Sent: Wednesday, August 20, 2003 11:50 AM
 To: Multiple recipients of list ORACLE-L
 
 
 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-
 ]
 Sent: Wednesday, August 20, 2003 12:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 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 

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

[Stephane Faroult]

Paul Baumgartel wrote:
 
 A couple of corrections are in order here.  First, some Christians
 might object to your characterizing the Holy Trinity, et. al. as
 mythology. 

I don't believe Andrei Rublev to be on this list.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

[Nelson, Allan]

Oh, we're used to it.  It's the predominant mythos of the current
society.  Everybody gets their own opinion unitl either death or
judgment.

Allan

-Original Message-
Sent: Thursday, August 21, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
cleanly/cons


Paul Baumgartel wrote:
 
 A couple of corrections are in order here.  First, some Christians 
 might object to your characterizing the Holy Trinity, et. al. as 
 mythology.

I don't believe Andrei Rublev to be on this list.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

[Paul Baumgartel]

Wow--that one sent me scrambling to Google.  Nice riposte!


--- Stephane Faroult [EMAIL PROTECTED] wrote:
 Paul Baumgartel wrote:
  
  A couple of corrections are in order here.  First, some Christians
  might object to your characterizing the Holy Trinity, et. al. as
  mythology. 
 
 I don't believe Andrei Rublev to be on this list.
 
 -- 
 Regards,
 
 Stephane Faroult
 Oriole Software
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephane Faroult
   INET: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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).
 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

[Tim Gorman]

Title: 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...

Ive known people who would keep repeating sync until their fingers started tripping over one another, so I tend to see three syncs as the minimum. At least, thats 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] 
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

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

[Mladen Gogala]

$ su  - root
Password:
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]# sync
[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]
 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

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

[Paula_Stankus]

Title: RE: URGENT!!!  My 9i databases are not shutting down cleanly/consistently like they used to or starting up





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?

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

[Paula_Stankus]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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? 

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

[April Wells]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



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 AMTo: Multiple recipients of list 
  ORACLE-LSubject: 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 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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.

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

[DENNIS WILLIAMS]

Paula - Haven't noticed an issue. What command are you using to shut down?
SHUTDOWN IMMEDIATE? Are you receiving an error message? Anything in
alert_log? Which Oracle version are you on? Most of my databases are
9.2.0.1.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, August 20, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L



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? 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

[Paula_Stankus]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



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 
  PMTo: Multiple recipients of list ORACLE-LSubject: 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 AMTo: Multiple recipients of list 
ORACLE-LSubject: 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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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.

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

[Paula_Stankus]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



No 
errors in the alert logs, no traces no ORA- but they don't shutdown cleanly 
and so I don't get consistent backups (this is every once in awhile). 


  -Original Message-From: Josh Collier 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 
  12:50 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  What 
  exactly "goes wrong"?
  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
  2003 9:25 AMTo: Multiple recipients of list 
  ORACLE-LSubject: 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? 

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

[April Wells]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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 
PMTo: Multiple recipients of list ORACLE-LSubject: 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 AMTo: Multiple recipients of list 
  ORACLE-LSubject: 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 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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.

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

[Murali_Pavuloori/Claritas]

Are you sure there are no jobs running during the time you are trying to
shutdown.

Murali.




   
   
[EMAIL PROTECTED]  
 
tate.fl.usTo: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED] 
Sent by:  cc:  
   
[EMAIL PROTECTED]   Subject: RE: URGENT!!!  My 9i 
databases are not shutting down cleanly/cons  
om 
   
   
   
   
   
08/20/2003 01:59 PM
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




No errors in the alert logs, no traces no ORA- but they don't shutdown
cleanly and so I don't get consistent backups (this is every once in
awhile).
 -Original Message-
 From: Josh Collier [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, August 20, 2003 12:50 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: URGENT!!! My 9i databases are not shutting down
 cleanly/cons

 What exactly goes wrong?
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, August 20, 2003 9:25 AM
 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?







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Murali_Pavuloori/[EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

[Mercadante, Thomas F]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



...wait...for...it...


  -Original Message-From: Josh Collier 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 
  12:50 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  What 
  exactly "goes wrong"?
  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
  2003 9:25 AMTo: Multiple recipients of list 
  ORACLE-LSubject: 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? 

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

[April Wells]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



Wait...and... wait... and  w.a.i.t

In our case, a lot of the problemwas 'supposed' to be a bug fixed 
in 9.2 (for a while it was EMN0 waking up... but now that error seems to have 
mysteriously disappeared)... oh and Oracle's position is... shutdown abort is a 
perfectly legitimate means of shutting down the database. So is just 
cycling the box but an option that I am comfortable with as a problem 
solution? NOT.

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: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 
  1:20 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  ...wait...for...it...
  
  
-Original Message-From: Josh Collier 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
2003 12:50 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
What exactly "goes wrong"?
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
2003 9:25 AMTo: Multiple recipients of list 
ORACLE-LSubject: 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.

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

[Caldwell, Robert A]

Do you see any OS processes with high CPU usage?

Rob Caldwell
DBA - United Space Alliance
www.unitedspacealliance.com


-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
cleanly/cons



Are you sure there are no jobs running during the time you are trying to
shutdown.

Murali.




   
   
[EMAIL PROTECTED]  
 
tate.fl.usTo: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED] 
Sent by:  cc:  
   
[EMAIL PROTECTED]   Subject: RE: URGENT!!!  My 9i 
databases are not shutting down cleanly/cons  
om 
   
   
   
   
   
08/20/2003 01:59 PM
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




No errors in the alert logs, no traces no ORA- but they don't shutdown
cleanly and so I don't get consistent backups (this is every once in
awhile).
 -Original Message-
 From: Josh Collier [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, August 20, 2003 12:50 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: URGENT!!! My 9i databases are not shutting down
 cleanly/cons

 What exactly goes wrong?
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, August 20, 2003 9:25 AM
 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?







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Murali_Pavuloori/[EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Caldwell, Robert A
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

[Mladen Gogala]

Title: Message



April, it;s a bug. Below is bug description. Advice: 
upgrade to 9.2.0.4 ASAP. May the farce be with you.

Bug:1841387 
Fixed: 8173 9011 9201 

  Hangs 
  / Spins Shutdown immediate sometimes takes more than 60 seconds even if
there is no active transaction if PMON is busy when the shutdown
is issued.



--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April 
  WellsSent: Wednesday, August 20, 2003 2:09 PMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i 
  databases are not shutting down cleanly/cons
  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 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  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 AMTo: Multiple recipients of list 
ORACLE-LSubject: 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 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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

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

[Jamadagni, Rajendra]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



Any errors ?? what does alert log say?

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 ! 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
  2003 12:25 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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? 
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

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

[Tim Gorman]

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



Id 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.

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

[Josh Collier]

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up



What 
exactly "goes wrong"?
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
2003 9:25 AMTo: Multiple recipients of list 
ORACLE-LSubject: 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? 

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

[Henry Poras]

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



sync, 
sync sync always reminded me of Benny Goodman.

Henry


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Tim GormanSent: 
  Wednesday, August 20, 2003 5:04 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting 
  down cleanly/consI'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 
immediateApril 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 PMTo: Multiple recipients of list 
      ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consWhich 
  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 PMTo: Multiple recipients of list 
    ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
    shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have 
trouble getting them to shutdown elegantly... and they sometimes 
crashApril 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 AMTo: Multiple recipients of list 
      ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
      shutting down cleanly/consBTW, 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 PMTo: Multiple recipients of list 
    ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
    shutting down cleanly/consThere 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 attac