Re: Database Process Hanging

pepe9400_at_hotmail.com (pepe) wrote in news:5d8eec5c.0303041501.7990988b_at_posting.google.com:

> I am trying to run the analyze/index, and because of the temp space is
> unextendable, the processes are hanging. I stopped analyze/index the
> processes and try to shutdown and startup the database. The shutdown
> process is hanging as well, so I manually killed all of the processes
> belonged to that database. Now, I try to startup the database, the
> message said 'ORA-01081: Cannot start already running ORACLE. Shut it
> down first.' but when I shut down the database, the message said
> 'ORA-1034: ORACLE not availble'.
>
> I don't want to blow away the database and rebuild it. Is there any
> other way that I can save/restore it????
>
> Thanks so much.
>
> pepe
>

No Oracle version.
No OS
No OS version.

My crystal ball is in for repair so YOYO. (You're On Your Own!) Received on Wed Mar 05 2003 - 01:45:23 CET