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
Please provide more detail -
1. What version of Oracle and OS you are running?
2. In what setup you are running your database (parellel server, stand by, replication etc.)
3. What infastructure you have? I mean, how much memory, size of SGA wanting to start, swap etc.
4. have you ever managed to start the same database successfully? or it is first time after installation?
5. If it is first time startup, did you install it correcty as guided by Oracle docos? did you set kernal correctly?
Sounds weired. Oracle DB will not mount without the background process starts. If this is so, pls report as a bug. AFAIK, Oracle database will not be accessible without any of background process running.
A Winner never Quits, A Quitter never Wins