4 Replies Latest reply on Jun 22, 2013 8:00 AM by user11688837

    Killing session on remote session are not working

    user11688837

      Hi Friends,

       

      I have RAC 10gr2 last patch 10.2.0.5 over two nodes on OEL 5.5.

      I unable to kill session from node1 to node2

      but i can kill session from node2 to node1

       

      declare

      v_job binary_integer;

      begin

      DBMS_JOB.submit ( job     =>v_job,

      what    =>'begin execute immediate ''ALTER SYSTEM KILL SESSION ''''819,7159'''' IMMEDIATE''; end; ',

      instance=>2 );

      commit;

      end;

      /

      I do not have metalink


      Please any one would like to help me,