Skip to Content
avatar image
Former Member

Application process are not killeg after DB crash

Hi all,

We have Oracle 11g RAC with 3 DB nodes and 4 SAP Application servers. One node crashed due to network issue. The sessions are then relocated to other node due to high availability of oracle. After the node came up. We can see many application sessions which were running on the node. It is not automatically killed. I went through alert log of SAP instances. But still no luck. Kindly suggest on it.

Regards,

Karthik.R

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 26, 2014 at 08:08 AM

    Hi Karthik,

    Please try this.

    In a RAC environment, you optionally specify the INST_ID, shown when querying the GV$SESSION view. This allows you to kill a session on different RAC node.

    SQL> ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id';

    Regards,

    V Srinivasan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Srinivasan,

      Thanks for the reply. I already killed it manually. My question is that why it is not getting automatically killed after server reboot. Why it is getting hung. It should have gone by itself during the reboot.