[h2title]问题现象[/h2title]
云主机内Oracle不能对外服务,本地只能访问127.0.0.1,访问分配的192.168.1.5也不能行,主机内1522服务监听状态如下:
[h2title]问题分析[/h2title]
通过抓包可看到访问请求已到达主机内,防火墙也确认是关闭状态,可排除测试终端到主机间拦截屏蔽等问题,可缩小问题范围在主机内软件问题,抓包发现果不其然,tcp握手syn后立马回复rst复位消息,问题点在主机内数据库服务端。
13:05:13.424654 IP 192.168.1.4.51244 > 192.168.1.5.ricardo-lm: Flags [S], seq 2728405579, win 64240, options [mss 1356,nop,wscale 8,nop,nop,sackOK], length 0 13:05:13.424959 IP 192.168.1.5.ricardo-lm > 192.168.1.4.51244: Flags [R.], seq 0, ack 2728405580, win 0, length 0 13:05:14.246391 IP 192.168.1.4.51244 > 192.168.1.5.ricardo-lm: Flags [S], seq 2728405579, win 64240, options [mss 1356,nop,wscale 8,nop,nop,sackOK], length 0 13:05:14.246655 IP 192.168.1.5.ricardo-lm > 192.168.1.4.51244: Flags [R.], seq 0, ack 1, win 0, length 0 13:05:15.084438 IP 192.168.1.4.51244 > 192.168.1.5.ricardo-lm: Flags [S], seq 2728405579, win 64240, options [mss 1356,nop,wscale 8,nop,nop,sackOK], length 0 13:05:15.084757 IP 192.168.1.5.ricardo-lm > 192.168.1.4.51244: Flags [R.], seq 0, ack 1, win 0, length 0 13:05:15.964799 IP 192.168.1.4.51244 > 192.168.1.5.ricardo-lm: Flags [S], seq 2728405579, win 64240, options [mss 1356,nop,wscale 8,nop,nop,sackOK], length 0 13:05:15.965106 IP 192.168.1.5.ricardo-lm > 192.168.1.4.51244: Flags [R.], seq 0, ack 1, win 0, length 0 13:05:16.764594 IP 192.168.1.4.51244 > 192.168.1.5.ricardo-lm: Flags [S], seq 2728405579, win 64240, options [mss 1356,nop,wscale 8,nop,nop,sackOK], length 0 13:05:16.764873 IP 192.168.1.5.ricardo-lm > 192.168.1.4.51244: Flags [R.], seq 0, ack 1, win 0, length 0
#消息说明:
S=SYN , 发起连接标志。
ack 表示确认包。
RST=RESET , 异常关闭连接。
. 表示没有任何标志。
() 括号中的数字是包的长度,建立连接和关闭连接时,包长都为0,括号前面的都是序列号。
结合127.0.0.1访问可正常连接数据库,则数据库本身服务应该是正常的,区别在于访问127.0.0.1和ip网卡,正好吻合主机监听是127.0.0.1。
[h2title]问题解决[/h2title]
继续缩小问题范围是监听ip问题,百度解决办法。
核查listener.ora配置需要将localhost改成主机名,这样访问ip才能正常。
E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
调整配置后,重启对应服务还是不行,不清楚具体管控监听的服务,后重启云主机后实测效果明显,状态核查也正常,问题解决。
15:22:10.530264 IP 192.168.1.4.59580 > 192.168.1.5.ricardo-lm: Flags [S], seq 594150587, win 8192, options [mss 1460,nop,nop,sackOK], length 0 15:22:10.530503 IP 192.168.1.5.ricardo-lm > 192.168.1.4.59580: Flags [R.], seq 0, ack 1, win 0, length 0 15:22:19.239187 IP 192.168.1.4.59595 > 192.168.1.5.ricardo-lm: Flags [S], seq 2129424090, win 8192, options [mss 1460,nop,nop,sackOK], length 0 15:22:19.239468 IP 192.168.1.5.ricardo-lm > 192.168.1.4.59595: Flags [S.], seq 2782445094, ack 2129424091, win 8192, options [mss 1460,nop,nop,sackOK], length 0 15:22:19.239825 IP 192.168.1.4.59595 > 192.168.1.5.ricardo-lm: Flags [.], ack 1, win 64240, length 0 15:22:19.240372 IP 192.168.1.4.59595 > 192.168.1.5.ricardo-lm: Flags [P.], seq 1:215, ack 1, win 64240, length 214 15:22:19.279141 IP 192.168.1.5.ricardo-lm > 192.168.1.4.59595: Flags [P.], seq 1:9, ack 215, win 64240, length 8 15:22:19.279516 IP 192.168.1.4.59595 > 192.168.1.5.ricardo-lm: Flags [P.], seq 215:429, ack 9, win 64232, length 214 15:22:19.279802 IP 192.168.1.5.ricardo-lm > 192.168.1.4.59595: Flags [P.], seq 9:33, ack 429, win 64026, length 24 15:22:19.280197 IP 192.168.1.4.59595 > 192.168.1.5.ricardo-lm: Flags [P.], seq 429:581, ack 33, win 64208, length 152 15:22:19.280448 IP 192.168.1.5.ricardo-lm > 192.168.1.4.59595: Flags [P.], seq 33:160, ack 581, win 63874, length 127
分类:数据库
标签: