RE: KIll Session in - RAC DB
- From: "Johnson, William L \(TEIS\)" <WLJohnson@xxxxxxxxxxxxxxxxxxx>
- To: <kaygopal@xxxxxxxxx>, <shivaswamykr@xxxxxxxxx>
- Date: Fri, 13 Apr 2007 07:25:01 -0400
OK - I should have tested before replying...while you can see all
sessions across all nodes, I was unable to kill a session initiated in
another instance of the RAC environment...
EurekaLog 5.1.6
Application:
-------------------------------------------------------
1.1 Start Date : Fri, 13 Apr 2007 07:20:36 -0400
1.2 Name/Description: TOAD
1.3 Version Number : 9.0.0.160
1.4 Parameters :
1.5 Compilation Date: Thu, 19 Oct 2006 16:23:05 -0400
Exception:
----------------------------------------------------
2.1 Date : Fri, 13 Apr 2007 07:21:58 -0400
2.2 Address: 0061FC7C
2.3 Module : TOAD.exe
2.4 Type : EOraError
2.5 Message: ORA-12560: TNS:protocol adapter error
.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johnson, William L
(TEIS)
Sent: Friday, April 13, 2007 7:13 AM
To: kaygopal@xxxxxxxxx; shivaswamykr@xxxxxxxxx
Cc: Oracle-L Freelists
Subject: RE: KIll Session in - RAC DB
While I have not tried to kill a session from the second node of a RAC
environment, I do know that Quest's TOAD software shows you all sessions
in a RAC environment while using their session browser utility...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of K Gopalakrishnan
Sent: Thursday, April 12, 2007 8:37 PM
To: shivaswamykr@xxxxxxxxx
Cc: Oracle-L Freelists
Subject: Re: KIll Session in - RAC DB
Shiva,
You may have to wait for another year (approx) to have this in the
database. It is going be a 11g(!) feature.
-Gopal
On 4/12/07, Shivaswamy Raghunath <shivaswamykr@xxxxxxxxx> wrote:
> Hello.
>
> We do not seem to have a switch INST_ID for ALTER SYSTEM KILL SESSION
> command. So, if I need to kill the session, I necessarily need to
login to
> the same instance in RAC.
>
> Has any of you have any other method so that you can kill the session
from
> any of the instance of the RAC database?
>
> Thanks,
> Shiva
>
>
>
--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
