RE: Problems Killing Sessions

Maybe two things have happened. First, you probably kill it when it was busy. Or second, you kill it through Oracle first and then when you've seen that it hasn't died, you insisted issuing a kill stmt. Sometimes killing through OS, gets you the same result.

So now, you must wait for PMON finishing its tasks. Or if you can do it, bounce the database.

Sometimes it helps an oradebug wakeup:

oradebug wakeup 2 <-----------the orapid of PMON

to post PMON and help it to its labour.

Regards.

> -----Mensaje original-----
> De: Eriovaldo do Carmo Andrietta [SMTP:eca_at_widesoft.com.br]
> Enviado el: jueves 8 de marzo de 2001 18:36
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Problems Killing Sessions
>
>
> Friends :
>
> We have a problem for kill a session :
>
> We did :
>
> select * from v$session and got the result bellow :
>
> USERNAME SID SERIAL# STATUS SERVER
> ------------------------------ ---------- ---------- -------- ---------
> 1 1 ACTIVE DEDICATED
> 2 1 ACTIVE DEDICATED
> 3 1 ACTIVE DEDICATED
> 4 1 ACTIVE DEDICATED
> 5 1 ACTIVE DEDICATED
> USER01 35 55317 ACTIVE DEDICATED
>
>
> We applyed the command :
>
> alter system kill session '35,55317';
> alter system kill session '35,55317'
> *
> ERROR at line 1:
> ORA-00030: user session ID does not exist
>
> and also, by Instance Manager we finished with kill immediate
>
> but the session is showed in the Instance Manager and v$session ..
>
> Why ?
>
>
> Eriovaldo do Carmo Andrietta
> eca_at_widesoft.com.br
> Limeira/SP - Brasil
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eriovaldo do Carmo Andrietta
> INET: eca_at_widesoft.com.br
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).