oracle如何查看vip漂移,oracle rac vip漂移到私有ip所在的网卡上,什么情况?

inet 100.100.10.11 netmask 0xffffff00 broadcast 100.100.10.255

tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0

lo0: flags=e08084b,c0inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255

inet6 ::1%1/0

tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1

每次vip漂移了之后,我都是使用下属命令使其恢复:

$ srvctl stop nodeapps -n eam02

$ srvctl start nodeapps -n eam02

查看alert日志:

Immediate Kill Session#: 481, Serial#: 10908

Immediate Kill Session: sess: 70000006fa31b80  OS pid: 21364946

Sat May 11 08:38:39 GMT+08:00 2013Process OS id : 21364946 alive after kill

Errors in file /u01/admin/prod/udump/prod2_ora_13369518.trc

Immediate Kill Session#: 483, Serial#: 21309

Immediate Kill Session: sess: 70000006fa34670  OS pid: 24576040

Sat May 11 08:38:40 GMT+08:00 2013Process OS id : 24576040 alive after kill

Errors in file /u01/admin/prod/udump/prod2_ora_13369518.trc

Sat May 11 08:38:45 GMT+08:00 2013ALTER SYSTEM SET service_names='prod' SCOPE=MEMORY SID='prod2';  (这一时刻我用nodeapps命令重启了服务)

Sat May 11 09:31:16 GMT+08:00 2013Thread 2 advanced to log sequence 2972 (LGWR switch)

Current log# 4 seq# 2972 mem# 0: +DATA/prod/onlinelog/group_4.259.789148211

Sat May 11 11:12:15 GMT+08:00 2013Thread 2 advanced to log sequence 2973 (LGWR switch)

Current log# 3 seq# 2973 mem# 0: +DATA/prod/onlinelog/group_3.258.789148211

Sat May 11 16:33:21 GMT+08:00 2013ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='prod2'; (这一点似乎是出问题了)

Sat May 11 16:33:21 GMT+08:00 2013Immediate Kill Session#: 363, Serial#: 12839

Immediate Kill Session: sess: 70000006f993630  OS pid: 17367116

Sat May 11 16:33:21 GMT+08:00 2013Process OS id : 17367116 alive after kill

Errors in file /u01/admin/prod/udump/prod2_ora_13369518.trc

Immediate Kill Session#: 387, Serial#: 166

Immediate Kill Session: sess: 70000006f9b3970  OS pid: 19136708

Sat May 11 16:33:21 GMT+08:00 2013Process OS id : 19136708 alive after kill

Errors in file /u01/admin/prod/udump/prod2_ora_13369518.trc

Immediate Kill Session#: 417, Serial#: 3590

Immediate Kill Session: sess: 70000006f9dbd80  OS pid: 19071122

Sat May 11 16:33:22 GMT+08:00 2013Process OS id : 19071122 alive after kill

Errors in file /u01/admin/prod/udump/prod2_ora_13369518.trc

Immediate Kill Session#: 420, Serial#: 685

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值