MAJOR ISSUE! Cannot shutdown, or startup [message #59522] |
Fri, 28 November 2003 12:29 |
Mark K
Messages: 18 Registered: October 2003
|
Junior Member |
|
|
We got ourselves in a mess here.
There was a sqlplus process running in background doind a shutdown immediate.
This process was killed at the UNIX level.
Now oracle thinks it's shutting down, but itsn't, and I can't start it up because it thinks it's shutting down.
What to do??!?!?!?!??!???
kill -9 the processes? shutdown abort?
Thanks in advance.
-- Mark K.
|
|
|
No urgency -- got through. [message #59523 is a reply to message #59522] |
Fri, 28 November 2003 13:42 |
Mark K
Messages: 18 Registered: October 2003
|
Junior Member |
|
|
Because of other issues that came up, I had no choice but to SHUTDOWN ABORT and pray it comes back up.
...
It did.
<sigh of relief>
Thank you for the bandwidth.
-- Mark K.
|
|
|
|
Re: MAJOR ISSUE! Cannot shutdown, or startup [message #59545 is a reply to message #59522] |
Tue, 02 December 2003 11:54 |
Sanjay
Messages: 236 Registered: July 2000
|
Senior Member |
|
|
Usually, Oracle is good in 'recovery' after a 'shutdown abort'. This is fairly true when there are no other major issues like loss of data files and other worse scenarious.
But if you are doing a 'abort' just to get the database down and start it up, it recovers well. The big bucks you paid has not gone waste.
Later.
|
|
|