DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23
  1. #21
    Join Date
    Jul 2007

    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

    Building the ORAKILL from SQL Plus

    Give this a try:

    SET BUFFER 300
    SET linesize 300

    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

    Ora Kill


    You need to mention the Oracle SID after orakill syntax.


    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.