Home » Infrastructure » Windows » Using orakill
Using orakill [message #167962] Tue, 18 April 2006 02:20 Go to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Hi all,

How to kill a process using orakill?
What is thread id ?

Thanks in Advance
SALIH KM
Re: Using orakill [message #168238 is a reply to message #167962] Wed, 19 April 2006 07:14 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Salim ,

I never used it but i got the following link. I hope it will help you.

http://www.oracleutilities.com/OSUtil/orakill.html

It's a nice explanation.
Re: Using orakill [message #168955 is a reply to message #168238] Mon, 24 April 2006 06:20 Go to previous messageGo to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
hi tarundua

thanks

It's working fine.

orakill orcl spid


After the orakill I am getting

ERROR at line 1:
ORA-03113: end-of-file on communication channel


But the killed session is available in the V$session for a few seconds say 30 seconds.

Regards
SALIH KM
Re: Using orakill [message #169086 is a reply to message #168955] Tue, 25 April 2006 00:39 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Salim,

Really not sure why you got this error but generally we get this error when there is a connection failure.

I tried to replicate your problem but received a different error.

Re: Using orakill [message #169119 is a reply to message #169086] Tue, 25 April 2006 03:15 Go to previous message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Actullay the error is not a question.

That error shows that the session is killed.

Thanks for your immediate response.

Salih Km
Previous Topic: connect to oracle (in remote system) using visual basic
Next Topic: Uninstall Oracle 9i from Windows PC (XP) (merged threads)
Goto Forum:
  


Current Time: Fri Nov 22 01:25:41 CST 2024