oracle数据库日志中Immediate Kill Session错误解决方法
数据库日志中Immediate Kill Session错误解决方法
环境:hp_unix + oracle 10.2.0.3 rac
客户一套rac数据库日志中节点1日志错误如下:
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='ORCL1';
...
Immediate Kill Session#: 1606, Serial#: 23
Immediate Kill Session: sess: 0x447e141c0 OS pid: 21802
Immediate Kill Session#: 1607, Serial#: 25
Immediate Kill Session: sess: 0x446e27580 OS pid: 21751
Immediate Kill Session#: 1608, Serial#: 32
Immediate Kill Session: sess: 0x447e15670 OS pid: 21804
Immediate Kill Session#: 1610, Serial#: 56
Immediate Kill Session: sess: 0x447e16b20 OS pid: 20036
Immediate Kill Session#: 1611, Serial#: 21
Immediate Kill Session: sess: 0x446e29ee0 OS pid: 19893
...
ALTER SYSTEM SET service_names='ORCL' SCOPE=MEMORY SID='ORCL1';
从上面信息可以看出,连接在节点1上的会话全部被kill掉,这个时候查看操作系统日志
Jun 17 07:25:18 sbka cmnetd[6358]: lan1 failed
Jun 17 07:25:18 sbka cmnetd[6358]: lan1 switching to lan2
Jun 17 07:25:18 sbka cmnetd[6358]: Subnet 17.16.6.0 switching from lan1 to lan2
Jun 17 07:25:18 sbka cmnetd[6358]: Subnet 17.16.6.0 switched from lan1 to lan2
Jun 17 07:25:18 sbka cmnetd[6358]: lan1 switched to lan2
Jun 17 07:25:18 sbka cmcld[6350]: Local switch has occurred since net_id 0x3 was not found on subnet 172.16.6.0.
Jun 17 07:25:58 sbka cmnetd[6358]: lan1 recovered
Jun 17 07:25:58 sbka cmnetd[6358]: Subnet 17.16.6.0 switching from lan2 to lan1
Jun 17 07:25:58 sbka cmnetd[6358]: Subnet 17.16.6.0 switched from lan2 to lan1
Jun 17 07:25:58 sbka cmnetd[6358]: lan2 switched to lan1
绑定在lan1公网的vip 地址发生漂移,导致节点1上的所有会话转移到节点2上,应用连接正常
但这时数据库日志不应该报这些错误,通过查metalink ID为730315.1
要解决这个报错信息,以下两种解决方法:
第一.升级到10.2.0.5
第二.修改service_name,不要和db_name名称相同。