Re: PMON killed, I can't start Oracle

Try shutting down your oracle instance by specifying abort command.

I had instances where if you have processes still hanging it takes long time before it shuts down. If your oracle already terminated and will not let you re-start try using "shutdown abort" from sqldba.

Good luck.

Nalini Vallampati <> wrote:

>Hi all, I am a newbie DBA, please bear with me.
 

>This morning I accidentally killed the PMON ( hurriedly used the wrong PID ).
>Now my Oracle instance won't start. I get the following messages:
 

>SQLDBA > connect internal
>Connected.
>SQLDBA > startup mount
>DBA-00342: unable to complete internal login
>ORA-00472: PMON process terminated with error
>SQLDBA >
 
>The server messages and codes manual asks me to check the background process
>trace file, and then shutdown and restart the instance. But I am not able to
>shutdown the database. Any command I execute gives me the above two
>error messages. What went wrong ?
 

>I am running Oracle 7.1.4 on AT&T SVR4 Rel 2.03.01.
 

>I would appreciate any help. Thanks
 

>Nalini Vallampati
>AT&T Credit
>Maimisburg, Ohio 45342
Received on Mon Aug 14 1995 - 00:00:00 CEST