设为首页 加入收藏

TOP

IP冲突导致的ORA-12170(五)
2014-11-23 21:50:08 来源: 作者: 【 】 浏览:59
Tags:冲突 导致 ORA-12170
niomapnserror: exit
[24-3月 -2014 09:41:20:813] niotns: Couldn't connect, returning 12170

大致明白了到NODE2的连接有问题,但前面步骤已经对NODE2进行了检查,没发现异常状况,再看看日志,发现crsd.log持续不断的报这种错:
2014-03-22 15:19:58.318: [ CRSRES][1532291392] Attempting to start `ora.bssdb02.vip` on member `bssdb02`
2014-03-22 15:20:20.592: [ CRSAPP][1532291392] StartResource error for ora.bssdb02.vip error code = 1
2014-03-22 15:20:20.990: [ CRSRES][1532291392] Start of `ora.bssdb02.vip` on member `bssdb02` failed.
2014-03-22 15:25:21.452: [ CRSRES][1532291392] startRunnable: setting CLI values
/var/log/messages也是持续不断报错:
Mar 23 04:05:02 bssdb02 avahi-daemon[7483]: Registering new address record for 10.0.23.136 on eth2.
Mar 23 04:05:02 bssdb02 avahi-daemon[7483]: Withdrawing address record for 10.0.23.136 on eth2.
看来VIP有问题,但ifconfig显示VIP是正常的。
[root@bssdb02 ~]# ifconfig
eth1 Link encap:Ethernet HWaddr A4:BA:DB:13:EA:C2
inet addr:192.168.127.102 Bcast:192.168.127.255 Mask:255.255.255.0
inet6 addr: fe80::a6ba:dbff:fe13:eac2/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:385015102 errors:0 dropped:0 overruns:0 frame:0
TX packets:447034056 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:231813004471 (215.8 GiB) TX bytes:322103900599 (299.9 GiB)
Interrupt:146 Memory:d8000000-d8012800

eth2 Link encap:Ethernet HWaddr A4:BA:DB:13:EA:C4
inet addr:10.0.23.132 Bcast:10.0.15.255 Mask:255.255.255.0
inet6 addr: fe80::a6ba:dbff:fe13:eac4/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:362482320 errors:0 dropped:0 overruns:0 frame:0
TX packets:322680748 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:60578409873 (56.4 GiB) TX bytes:322706932324 (300.5 GiB)
Interrupt:154 Memory:da000000-da012800

eth2:1 Link encap:Ethernet HWaddr A4:BA:DB:13:EA:C4
inet addr:10.0.23.136 Bcast:10.0.15.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:154 Memory:da000000-da012800

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:107105620 errors:0 dropped:0 overruns:0 frame:0
TX packets:107105620 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:183491493683 (170.8 GiB) TX bytes:183491493683 (170.8 GiB)

[root@bssdb02 ~]#
既然客户端连接NODE2有问题,那么抓下包呢,用tcpdump配合客户端的连接,但显示到NODE2-VIP没有包过来:
[root@bssdb02 ~]# tcpdump -i eth2 -Z oracle src host 10.25.192.23 and dst host 10.0.23.136 and port 1521
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth2, link-type EN10MB (Ethernet), capture size 96 bytes

0 packets captured
0 packets received by filter
0 packets dropped by kernel
修改下tcpdump设置,但从NODE2-PUBLICIP还是有网路包过来的,如下:
[root@bssdb02 ~]# tcpdump -i eth2 -Z oracle src host 10.25.192.23 and port 1521
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth2, link-type EN10MB (Ethernet), capture size 96 bytes
11:47:41.951599 IP bpit-10003657.sany.com.cn.63079 > bssdb02.ncube-lm: S 1037287069:1037287069(0) win 8192
11:47:42.451180 IP bpit-10003657.sany.com.cn.63079 > bssdb02.ncube-lm: S 1037287069:1037287069(0) win 8192
11:47:42.951154 IP bpit-10003657.sany.com.cn.63079 > bssdb02.ncube-lm: S 103
首页 上一页 2 3 4 5 下一页 尾页 5/5/5
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle创建定时任务 下一篇Oracle数据库案例整理-导入导出Or..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: