April 7, 1996
Newsgroups: comp.databases.oracle
Subject: Re: Dead SQL*Net process
References: 
kmku@hkusua.hku.hk (Ku Kam Ming) writes:

>Are there any script or way to kill all dead processes?
>Should I use SHUTDOWN ABORT instead of SHUTDOWN IMMEDIATE in order to 
>kill all processes remained?

>Thanks,
>--
>**********************************************************************
>Kam-ming Ku (kmku)	          GB: 
>*********************************************************************
> 

Kam-ming,
If you have dead, or "zombie" processes, then sometimes shutting the
database down will not get rid of the processes. This includes either 
SHUTDOWN ABORT or SHUTDOWN IMMEDIATE.

To get rid of the dead processes that cannot be stopped from SHUTDOWN, 
first try a "kill -15 {process-id}". Substitute the process-id with 
{process-id} in the examples included here.
If that fails, then try "kill -9 {process-id}". Make sure that you logged 
in as the owner of the process (most likely it will be the "oracle" id).

Now, if the process still exists after a "kill -9 {process-id}", then do 
one of the following:
1) login as root and kill the process.
2) Physically shut down the system and restart. 

Best of luck,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: www.arikaplan.com                          <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page m">Back to Ari Kaplan's Home Page