Kill session on specific node of RAC
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Kill session on specific node of RAC

Threaded View

  1. #1
    Join Date
    Jun 2007
    Posts
    59

    Kill session on specific node of RAC

    I am trying to kill session on RAC 10g Oracle on the specific instance
    and for some reason it fails. I am on the node 2.

    SQL> ALTER SYSTEM KILL SESSION '119, 35553, @1';
    ALTER SYSTEM KILL SESSION '119, 35553, @1'
    *
    ERROR at line 1:
    ORA-00026: missing or invalid session ID

    If I just run
    SQL> ALTER SYSTEM KILL SESSION '119, 35553'
    2 ;
    ALTER SYSTEM KILL SESSION '119, 35553'
    *
    ERROR at line 1:
    ORA-00030: User session ID does not exist.
    Which is expected .

    According to docs:
    To terminate sessions, follow these steps:

    *

    Query the value of the INST_ID column in the GV$SESSION dynamic performance view to identify which session to terminate
    *

    Issue the ALTER SYSTEM KILL SESSION and specify the session index number (SID) and serial number of a session that you identified with the GV$SESSION dynamic performance view.

    KILL SESSION 'integer1, integer2[, @integer3]'

    o

    For integer1, specify the value of the SID column.
    o

    For integer2, specify the value of the SERIAL# column.
    o

    For the optional integer3, specify the ID of the instance where the session to be killed exists. You can find the instance ID by querying the GV$ tables.

    To use this statement, your instance must have the database open, and your session and the session to be terminated must be on the same instance unless you specify integer3.
    Thanks
    Last edited by zam; 01-29-2008 at 09:41 PM.

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