Re: orakill.exe problem !!

Hi,

I realise that it doesn't really help but I get exactly the same message. You are using the program in an incorrect way, I think.

If you do orakill ? you will get the following help message.

  where sid = the Oracle instance to target

        thread = the thread id of the thread to kill

  The thread id should be retrieved from the spid column of a query such as:

        select spid, osuser, s.program from
        v$process p, v$session s where p.addr=s.paddr

************************************************************

so sid is the instance system identifier, often the same name as the database, nothing to do with session IDs. However if I try with my sid I get the same error as you. I am using 8.1.6 on Windows/2000.

/M

"gorgeous" <good.omen_at_msa.hinet.net> wrote in message news:<9fgaro$4c7_at_netnews.hinet.net>...
> hi,I am tring to use the command 'orakill.exe' ,but there was a problem
> happend,for example,
> c> orakill 13 988
> error message :could not attach to oracle instance 13 :err=2
> select sid,spid, osuser, s.program from
> v$process p, v$session s where p.addr=s.paddr
> sid=13 and spid=988
> is anybody can help me ,thanks (newbie)
> tony
Received on Wed Jun 13 2001 - 13:52:25 CEST