Home » Infrastructure » Windows » Unable to kill a session using Orakill (10.2.3.0 standard edition,Microsoft Windows server 2003)
icon9.gif  Unable to kill a session using Orakill [message #567219] Tue, 25 September 2012 07:09 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear All,

Please note today i faced one issue i unable to kill one database session,Today i killed one session

alter system kill session '418,12499'

but status shows as killed but process still exits in OSLevel

SQL> select sid,serial#,status from gv$session where sid=418;

SID SERIAL# STATUS
---------- ---------- --------
418 12499 KILLED

we all know we can kill by using ORAKIL but still we unable to kill

SQL> select spid from v$process a, v$session b where a.addr = b.paddr and b.sid = '418';

SPID
------------
5644

i killed using orakill

C:\Documents and Settings\Administrator>orakill oraci 5644

Kill of thread id 5644 in instance oraci successfully signalled.

but still process exits in os level also i notice below error in alert log

orakill: ssthreadkill(tid=5644) unable to get the thread list mutex: err=0

please advice on above error.

Thanks&Regards,
Anil



Re: Unable to kill a session using Orakill [message #567221 is a reply to message #567219] Tue, 25 September 2012 07:23 Go to previous messageGo to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear All,

Please update on my above request.

Regards,
Anil
Re: Unable to kill a session using Orakill [message #567233 is a reply to message #567221] Tue, 25 September 2012 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 59062
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please be patient.
We do not owe you any fast answer; actually we do not owe you any answer.

Regards
Michel
Re: Unable to kill a session using Orakill [message #567236 is a reply to message #567233] Tue, 25 September 2012 08:53 Go to previous message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Thanks,I am waiting on this.

Regards,
Anil
Previous Topic: Oracle Database 11g R2 enterprise manager configuration warnings
Next Topic: Can not create database PACKS and create a user PACKS (merged)
Goto Forum:
  


Current Time: Sun Sep 14 23:25:28 CDT 2014

Total time taken to generate the page: 0.08650 seconds