hi,
I killed the user session with kill -9 pid command, as I can't kill it using alter system kill session, when a user session hung up.
Then the user session still appears in the session list. I tried to shutdown the database with shutdown immediate. I could not. then I used shutdown abort. Then restarted the database. It gave the message as usual. i.e instance started, database mounted and opened. When I tried to connect the database from sqlplus, it gave the ora-1034 oracle not available error message. I chceked the database from unix prompt with ps -ef command. Surprisingly, I did not find any back ground process which should be there when the database is running .I shutdown again and restarted the database. But it is still in the same condition.
Any help is apprecited and thanks in advance.
Srinivasa Rao Chava