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:[EMAIL PROTECTED]]
> 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
> [EMAIL PROTECTED]
> Limeira/SP - Brasil
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eriovaldo do Carmo Andrietta
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).