Application process are not killeg after DB crash

[Former Member]

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

[srinivasan_vinayagam]

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

[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.