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