Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
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 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 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
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 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. Hemant K Chitale Oracle 9i
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
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
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
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
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
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
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
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
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
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
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
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
-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
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
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
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
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
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 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
Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
$ 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 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
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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