Yes, I
WHOLE heartedly agree, and we do a shutdown immediate now, but the point
is... Oracle SUPPORT seems to be of the opinion that rather than trying to
figure out what is 'wrong' we should just do a shutdown abort it 'Is a valid
solution'. I'm guessing there IS a REASON it is doing this... and that it
is only doing it in one of my three financials instances CONSISTENTLY... and NOT
the one that was the source of the recent clone.
ajw
-----Original Message-----
From: Ishrat Jehan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immThe differences are1. shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted.2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactions terminated are rollbacked, recovery would not happen at restart3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever.So shutdown immediate is much quicker and safer....Ishrat-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 9:53 PM
To: Multiple recipients of list ORACLE-L
Subject: shutdown abort / startup restrict / shutdown vs. shutdown immedia> -----Original Message-----
> From: April Wells [mailto:[EMAIL PROTECTED]]
>
> The solutions (the ones that I got) aren't good ones.
>
> Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID
> solution'???)This might be a naive question, but why is
-> shutdown immediate
better than
-> shutdown abort / startup restrict / shutdown normal ?(That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail.
Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment.
