How to kill Oracle Process on Win NT/2000 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 23

Thread: How to kill Oracle Process on Win NT/2000

  1. #11
    Join Date
    Aug 2002
    Posts
    1
    Originally posted by ctcyl
    Dear friends..

    I have tried by ORAKILL, but I got the following error. and unable to kill the process.

    Firstly I have query for the process by the following query.
    1 select sid, spid as thread, osuser, s.program
    2 from sys.v_$process p, sys.v_$session s
    3* where p.addr = s.paddr
    SQL>/
    1 193 SYSTEM ORACLE.EXE
    2 263 SYSTEM ORACLE.EXE
    3 267 SYSTEM ORACLE.EXE
    4 216 SYSTEM ORACLE.EXE
    5 254 SYSTEM ORACLE.EXE
    6 259 SYSTEM ORACLE.EXE
    7 233
    8 250
    9 257
    10 290
    13 113 DOMAIN\Administrator SQLPLUSW.EXE

    Then I have tried to kill the process 13 and thread 113 by the following commands -

    Microsoft(R) Windows NT(TM)
    (C) Copyright 1985-1996 Microsoft Corp.

    C:\>orakill 13 113

    Could not attach to Oracle instance 13: err = 2

    C:\>

    and got the above error "Could not attach to Oracle instance 13: err = 2 "

    Please advise.

    Thanks & Regards
    Naresh


    yes,I have the same problem:
    C:\>orakill 8 616

    Could not attach to Oracle instance 8: err = 2

    can someone give the answer?
    thanks !
    Auling

  2. #12
    Join Date
    Aug 2002
    Posts
    1

    Arrow

    hi...

    try that...

    c:\orakill %sid% spid

    example:

    c:\orakill test 113

    mfg blackswan


  3. #13
    Join Date
    Aug 2002
    Posts
    1
    The usage of orakill is

    orakill sid thread

    sid here means Oracle SID




  4. #14
    Join Date
    Sep 2002
    Posts
    40

    signalled but process not killed

    Well i tried
    orakill "instance_name" thread
    it says
    kill of thread id instance successfully signalled.
    I did this for a user using sqlplus, but even after receining this message the user continued to use sqlplus and access the database without any hinderance for the same session !!!!!

    WHY ?

  5. #15
    Join Date
    Sep 2002
    Posts
    40

    am i alone

    Hi,
    Is everybody or shall i say anybody not facing the same results as i did ?
    Anyone out there ?
    OCP DBA 7.3,8,8i,9i

  6. #16
    Join Date
    Sep 2002
    Posts
    4
    I realize that Im novice but this code looks to me have more bugs than windows ME ...
    1) there are really no such views as sys.v_$process p, sys.v_$session s

    probably v$process & v$session are good choices

    1 select sid, spid as thread, osuser, s.program
    2 from v$process p, v$session s
    3* where p.addr = s.paddr;
    SQL> /
    where p.addr = s.paddr;
    *
    ERROR at line 3:
    ORA-00911: invalid character

    since it quite late I said I have enough with bugging this script (for exam Ill remember
    ALTER SYSTEM KILL SESSION 'SID, THREAD#';

    Thnx but no THANKS!!



    Originally posted by sreddy
    Win NT/2000 is a thread based Operating System and not process based Operating System like Unix. Oracle user and background processes are not multiple processes but, threads with in oracle.exe process. 'orakill' is oracle provided utility to kill a particular resource intensive thread under oracle.exe process. For help type in at the DOS prompt C:\>orakill /?

    The following query can be used to get the sid, thread id of a particular resource intensive thread.

    SQL> select sid, spid as thread, osuser, s.program
    2 from sys.v_$process p, sys.v_$session s
    3 where p.addr = s.paddr;

    SID THREAD OSUSER PROGRAM
    -------- --------- --------------- -------------------------------------
    1 000C5 UNKNOWN ORACLE73.EXE
    2 0013F UNKNOWN ORACLE73.EXE
    3 00140 UNKNOWN ORACLE73.EXE
    4 0005F UNKNOWN ORACLE73.EXE
    5 0011C UNKNOWN ORACLE73.EXE
    6 0009A UNKNOWN ORACLE73.EXE
    7 00101
    8 000C0
    12 00148 SYSTEM D:\ORANT805\agentbin\DBSNMP.EXE
    18 001FC scott SQLPLUS.EXE
    9 001F2 adam C:\WINNT\Profiles\All Users\Start Menu\AFF_PFC.LNK
    36 00206 mark SVRMGR.EXE
    31 000E1 cathy AFFAIRS.EXE
    15 00204 Julie C:\Documents and Settings\julie\Start Menu\Programs\AFFS.lnk


    Say the query from user scott is consuming lot resources and it can be killed by running orakill utility as follows.

    C:\>orakill 18 001FC


    [Edited by sreddy on 03-29-2001 at 10:49 AM]

  7. #17
    Join Date
    Sep 2002
    Posts
    40

    Question ora kill

    So when u execute the above command, that particular process for user scott will be termintaed... But is the user scott still supposed to be connected to the database and can work with the same sql plus session ?
    OCP DBA 7.3,8,8i,9i

  8. #18
    Join Date
    Aug 2001
    Location
    Manchester, UK
    Posts
    86
    I tried the above but could still work in my sql session.

    Could some one please explain
    what is happening.

    --A
    -- Anurag.
    OCP Application Developer
    ---------------------------------------------------------
    "Be not afraid of growing slowly. Be afraid only of standing still."

  9. #19
    Join Date
    May 2003
    Posts
    1

    orakill error 2

    Hi
    Actully ORAKILL command expects the SID and THREADID

    SID is the name of the databse itself
    if the database name is xyz and the psid(thread id) = 510 then

    c:\orakill
    means
    c:\orakill xyz 510

    it will work
    Thanks

  10. #20
    Join Date
    Jul 2007
    Location
    india
    Posts
    3

    Smile

    this 13 isnt the SID

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width