Home » RDBMS Server » Server Administration » MAJOR ISSUE! Cannot shutdown, or startup
MAJOR ISSUE! Cannot shutdown, or startup [message #59522] Fri, 28 November 2003 12:29 Go to next message
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 Go to previous messageGo to next message
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: No urgency -- got through. [message #59526 is a reply to message #59523] Fri, 28 November 2003 20:37 Go to previous messageGo to next message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Hello Mark,

Thats good. But make sure you do a shutdown normal after that and take backup.

Regards,

Vikas.
Re: MAJOR ISSUE! Cannot shutdown, or startup [message #59545 is a reply to message #59522] Tue, 02 December 2003 11:54 Go to previous message
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.
Previous Topic: Partitioning tables
Next Topic: ORA-00600 -- internal error
Goto Forum:
  


Current Time: Fri Sep 20 08:26:45 CDT 2024