on 2014 Nov 26 7:19 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.