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

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

  1. #21
    Join Date
    Jul 2007
    Posts
    1

    Change the 1st parameter as database Instance name.

    That's true. The orakill does not works and it shows the error like "could not attach ......"

    The command should be
    orakill ;
    i.e., if sidname (name of the database(instance name)) is INS and spid is 2576 then the command should be,

    orakill INS 2576

    I have tested it on Oracle 8.1.5 and that works.

  2. #22
    Join Date
    Aug 2007
    Posts
    1

    Building the ORAKILL from SQL Plus

    Give this a try:

    SET BUFFER 300
    SET linesize 300
    SET PAGESIZE 75

    column sid format 999
    column serial# format 9999999
    column username format A20
    column user# format 99999
    column osuser format A15
    column ORAKILL_DBSID_THREAD format A25
    column MACHINE format a25

    Prompt ****** c:\oracle9i\bin\ORAKILL ORACLE_DATABASE_SID THREAD_NUMBER
    SELECT 'ORAKILL '||(SELECT instance_name FROM v$instance)||' '||SPID||'' "ORAKILL_DBSID_THREAD",
    s.sid, s.serial#, STATUS, s.username, OSUSER, MACHINE, s.TERMINAL
    FROM v$session s, v$session_wait w, V$PROCESS p
    WHERE s.SERIAL# <> 1
    AND s.sid = w.sid
    AND s.paddr = p.addr;

  3. #23
    Join Date
    Jul 2009
    Posts
    1

    Ora Kill

    Naresh,

    You need to mention the Oracle SID after orakill syntax.

    example:

    C:\orakill spid;

    Best Regards
    Lakshmi Narayana

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