startup after shutdown abort
currently I have a db startup problem. We are not experienced dba and would like to ask for help.
We are still in Oracle 8.0.6. and situation is :
Our user was working in a application and was having hangup problem due to file/record locking up.
We have tried to cleanup by killing the lock by manager console but the console session hangs and has not feed back. It seems not successful (not known the reason but we still found the locking in the manager console.).
Then we try to shutdown by "shutdown immediate" but it wait for long time without exiting. Afterwards we shutdown db by "shutdown abort" and the instance is shut down.
But when we start up the db again, the db just go to the "alter database mount" state (see from alert.log) and then we are still waiting. It has been 3.5 hr long and the db is still not open yet.
Any experts can advise what can I do now?
Johnson