Re: orakill failure

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 10 May 2003 18:26:00 -0700
Message-ID: <92eeeff0.0305101726.842513@posting.google.com>

"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message news:<b9i3cl$f77$1_at_news.is.net.tw>...
> Dear all,
>
> To kill the pending thread (session marked as 'KILLED') with shutting down the instance.
>
> orakill <sid> <thread id>
>
> Could not attach to Oracle instance 1: err = 2
>
> Version: Oracle 8.1.7 on Windows NT server
>
> Anyone any comments? thanks.
>
> Regards,
> Dino

On Windows, Oracle threads are wrapped inside a parent Oracle process (Multithreaded architecture). Using orakill, you can kill an individual thread at the OS level (if you know the thread id or session spid) ONLY when the Oracle process is still active. Once the process is terminated, all threads inside it are also killed with it. You are trying to run orakill after the Oracle process is terminated so you will keep getting this error.

What you are trying to do would be valid on a Unix OS where you may end up with a pending process (even though database is shutdown) and would like to kill it at the OS level.

Regards
/Rauf Sarwar Received on Sat May 10 2003 - 20:26:00 CDT