Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ora.netn.network 反复重启
发新帖
boyboyman

0

积分

1

好友

2

主题

[Exadata硬件] ora.netn.network 反复重启

1#
发表于 2013-4-5 02:36:01 | 查看: 5823| 回复: 5
平台：solaris 11
数据库：11.2.0.3 RAC
时常发现连接的会话断开后，尝试再连接数据库需要等很久才能连上

ip 地址：

10.102.105.21 db1
10.102.105.22 db2
10.102.105.17 db1-vip
10.102.105.18 db2-vip
10.102.105.19 scan-ip


查看GI 日志发现报错信息：

/oracle/11.2.0/grid/log/hyundai-db2/agent/crsd/orarootagent_root/orarootagent_root.log

不知道为什么ora.netn.network 会 NetworkAgent::checkLink returned false？



2013-04-03 09:29:30.782: [ default][1245]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:30.782: [ora.net1.network][1245] {0:3:910} [check] NetInterface::sCheckLink }
2013-04-03 09:29:31.780: [ default][1245]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:31.781: [ default][1245]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:31.781: [ora.net1.network][1245] {0:3:910} [check] NetInterface::sCheckLink }
2013-04-03 09:29:32.796: [ default][1245]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:33.799: [ora.net1.network][1245] {0:3:910} [check] NetworkAgent::checkLink returned false
2013-04-03 09:29:33.800: [    AGFW][11] {0:3:910} ora.net1.network hyundai-db2 1 state changed from: ONLINE to: OFFLINE
2013-04-03 09:29:33.800: [    AGFW][11] {0:3:910} Switching online monitor to offline one
2013-04-03 09:29:33.800: [    AGFW][11] {0:3:910} Started implicit monitor for [ora.net1.network hyundai-db2 1] interval=60000 delay=60000
2013-04-03 09:29:33.800: [    AGFW][11] {0:9:2178} Generating new Tint for unplanned state change. Original Tint: {0:3:910}
2013-04-03 09:29:33.800: [    AGFW][11] {0:9:2178} Agent sending message to PE: RESOURCE_STATUS[Proxy] ID 20481:1571265
2013-04-03 09:29:33.801: [CLSFRAME][1] TM [MultiThread] is changing desired thread # to 3. Current # is 2
2013-04-03 09:29:33.831: [    AGFW][11] {0:9:2178} Agent received the message: RESOURCE_START[ora.net1.network hyundai-db2 1] ID 4098:55181
2013-04-03 09:29:33.831: [    AGFW][11] {0:9:2178} Preparing START command for: ora.net1.network hyundai-db2 1
2013-04-03 09:29:33.831: [    AGFW][11] {0:9:2178} ora.net1.network hyundai-db2 1 state changed from: OFFLINE to: STARTING
2013-04-03 09:29:33.833: [ora.net1.network][1249] {0:9:2178} [start] (:CLSN00107:) clsn_agent::start {
2013-04-03 09:29:33.833: [ora.net1.network][1249] {0:9:2178} [start] NetworkAgent::init enter {
2013-04-03 09:29:33.833: [    AGFW][11] {0:9:2178} Agent received the message: RESOURCE_PROBE[ora.scan1.vip 1 1] ID 4097:55186
2013-04-03 09:29:33.833: [    AGFW][11] {0:9:2178} Preparing CHECK command for: ora.scan1.vip 1 1
2013-04-03 09:29:33.837: [    AGFW][11] {0:9:2178} Agent sending last reply for: RESOURCE_PROBE[ora.scan1.vip 1 1] ID 4097:55186
2013-04-03 09:29:33.973: [ora.net1.network][1249] {0:9:2178} [start] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:34.027: [ora.net1.network][1249] {0:9:2178} [start] Checking if net0 Interface is fine
2013-04-03 09:29:34.159: [ora.net1.network][1249] {0:9:2178} [start] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:34.184: [ora.net1.network][1249] {0:9:2178} [start] ifname=net0
2013-04-03 09:29:34.184: [ora.net1.network][1249] {0:9:2178} [start] subnetmask=255.255.255.0
2013-04-03 09:29:34.184: [ora.net1.network][1249] {0:9:2178} [start] subnetnumber=10.102.105.0
2013-04-03 09:29:34.184: [ora.net1.network][1249] {0:9:2178} [start] Interface Name = net0
2013-04-03 09:29:34.184: [ora.net1.network][1249] {0:9:2178} [start] Primary IP = 10.102.105.22
2013-04-03 09:29:34.184: [ora.net1.network][1249] {0:9:2178} [start] NetworkAgent::init exit }
2013-04-03 09:29:34.184: [ USRTHRD][1249] {0:9:2178} Thread:[VipRelocate:]stop {
2013-04-03 09:29:34.184: [ USRTHRD][1249] {0:9:2178} Thread:[VipRelocate:]stop }
2013-04-03 09:29:34.190: [ora.net1.network][1249] {0:9:2178} [start] Ocr Context init default level 1078853744
2013-04-03 09:29:34.194: [ora.net1.network][1249] {0:9:2178} [start] Ocr Context init default level 1078853744
2013-04-03 09:29:34.197: [ora.scan1.vip][1245] {0:3:910} [check] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:34.208: [ora.net1.network][1249] {0:9:2178} [start] (:CLSN00107:) clsn_agent::start }
2013-04-03 09:29:34.208: [    AGFW][1249] {0:9:2178} Command: start for resource: ora.net1.network hyundai-db2 1 completed with status: SUCCESS
2013-04-03 09:29:34.209: [    AGFW][11] {0:9:2178} Agent sending reply for: RESOURCE_START[ora.net1.network hyundai-db2 1] ID 4098:55181
2013-04-03 09:29:34.209: [CLSFRAME][1] TM [MultiThread] is changing desired thread # to 4. Current # is 3
2013-04-03 09:29:34.246: [ default][1249]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:34.247: [ora.scan1.vip][1245] {0:3:910} [check] InterfaceName = net0
2013-04-03 09:29:34.247: [ora.scan1.vip][1245] {0:3:910} [check] NetworkMask = 255.255.255.0
2013-04-03 09:29:34.247: [ora.scan1.vip][1245] {0:3:910} [check] NetworkAuto = static
2013-04-03 09:29:34.247: [ora.scan1.vip][1245] {0:3:910} [check] Checking if net0 Interface is fine
2013-04-03 09:29:34.343: [ora.scan1.vip][1245] {0:3:910} [check] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:34.378: [ora.scan1.vip][1245] {0:3:910} [check] ifname=net0
2013-04-03 09:29:34.378: [ora.scan1.vip][1245] {0:3:910} [check] subnetmask=255.255.255.0
2013-04-03 09:29:34.378: [ora.scan1.vip][1245] {0:3:910} [check] subnetnumber=10.102.105.0
2013-04-03 09:29:34.378: [ora.scan1.vip][1245] {0:3:910} [check] InterfaceName = net0
2013-04-03 09:29:34.378: [ora.scan1.vip][1245] {0:3:910} [check] HostName 10.102.105.19 translated to 10.102.105.19
2013-04-03 09:29:34.378: [ora.scan1.vip][1245] {0:3:910} [check] Interface Name = net0
2013-04-03 09:29:34.379: [ora.scan1.vip][1245] {0:3:910} [check] Ip Address = 10.102.105.19
2013-04-03 09:29:35.248: [ora.net1.network][1249] {0:9:2178} [check] NetworkAgent::checkLink returned false
2013-04-03 09:29:35.248: [    AGFW][11] {0:9:2178} ora.net1.network hyundai-db2 1 state changed from: STARTING to: OFFLINE
2013-04-03 09:29:35.248: [    AGFW][11] {0:9:2178} Switching online monitor to offline one
2013-04-03 09:29:35.249: [    AGFW][11] {0:9:2178} Started implicit monitor for [ora.net1.network hyundai-db2 1] interval=60000 delay=60000
2013-04-03 09:29:35.249: [    AGFW][11] {0:9:2178} Agent sending last reply for: RESOURCE_START[ora.net1.network hyundai-db2 1] ID 4098:55181
2013-04-03 09:29:35.925: [    AGFW][11] {0:3:916} Agent received the message: RESOURCE_START[ora.net1.network hyundai-db2 1] ID 4098:55193
2013-04-03 09:29:35.925: [    AGFW][11] {0:3:916} Preparing START command for: ora.net1.network hyundai-db2 1
2013-04-03 09:29:35.925: [    AGFW][11] {0:3:916} ora.net1.network hyundai-db2 1 state changed from: OFFLINE to: STARTING
6#
发表于 2013-4-13 11:08:28
I want to ask a problem about PSU5. which user should unzip p14727347_112030_SOLARIS64.zip
and what means "status file location" in readme

回复 只看该作者 道具 举报

5#
发表于 2013-4-5 14:34:58
$GRID_HOME/bin/crsctl modify res ora..vip -attr “STOP_DEPENDENCIES=hard(intermediate:ora..network)”

仍需要的

回复 只看该作者 道具 举报

4#
发表于 2013-4-5 12:57:37
Maclean Liu(刘相兵 发表于 2013-4-5 09:33
2013-04-03 09:29:33.799: [ora.net1.network][1245] {0:3:910} [check] NetworkAgent::checkLink returned ...

嗯，网络瞬断这个的确是存在的，不过我想问下现在最新的是PSU5 ，如果我打完PSU5，# $GRID_HOME/bin/crsctl modify res ora..vip -attr “STOP_DEPENDENCIES=hard(intermediate:ora..network)” 这类vip,scan-vip 还需要做么

回复 只看该作者 道具 举报

3#
发表于 2013-4-5 09:33:56
2013-04-03 09:29:33.799: [ora.net1.network][1245] {0:3:910} [check] NetworkAgent::checkLink returned false
2013-04-03 09:29:33.800: [    AGFW][11] {0:3:910} ora.net1.network hyundai-db2 1 state changed from: ONLINE to: OFFLINE
2013-04-03 09:29:33.800: [    AGFW][11] {0:3:910} Switching online monitor to offline one


对network检测超时 导致的network资源offline，很正常的。

因为11.2中对该Network资源的检测很敏感， 每秒发生一次，所以任何的网络打嗝都会造成问题。


你需要做的：

1. 检查为什么 网络出现瞬断 =》　部署一个ping脚本证明这一问题

2.  follow 这个文档 11gR2 RAC vip和network资源的依赖性与频繁failover http://www.askmaclean.com/archiv ... twork-failover.html

回复 只看该作者 道具 举报

2#
发表于 2013-4-5 02:36:42
2013-04-03 09:29:35.927: [ora.net1.network][1250] {0:3:916} [start] (:CLSN00107:) clsn_agent::start {
2013-04-03 09:29:35.927: [ora.net1.network][1250] {0:3:916} [start] NetworkAgent::init enter {
2013-04-03 09:29:36.084: [ora.net1.network][1250] {0:3:916} [start] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:36.142: [ora.net1.network][1250] {0:3:916} [start] Checking if net0 Interface is fine
2013-04-03 09:29:36.253: [ora.net1.network][1250] {0:3:916} [start] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:36.285: [ora.net1.network][1250] {0:3:916} [start] ifname=net0
2013-04-03 09:29:36.285: [ora.net1.network][1250] {0:3:916} [start] subnetmask=255.255.255.0
2013-04-03 09:29:36.285: [ora.net1.network][1250] {0:3:916} [start] subnetnumber=10.102.105.0
2013-04-03 09:29:36.285: [ora.net1.network][1250] {0:3:916} [start] Interface Name = net0
2013-04-03 09:29:36.285: [ora.net1.network][1250] {0:3:916} [start] Primary IP = 10.102.105.22
2013-04-03 09:29:36.285: [ora.net1.network][1250] {0:3:916} [start] NetworkAgent::init exit }
2013-04-03 09:29:36.290: [ora.net1.network][1250] {0:3:916} [start] Ocr Context init default level 1078853744
2013-04-03 09:29:36.294: [ora.net1.network][1250] {0:3:916} [start] Ocr Context init default level 1078853744
2013-04-03 09:29:36.305: [ora.net1.network][1250] {0:3:916} [start] (:CLSN00107:) clsn_agent::start }
2013-04-03 09:29:36.305: [    AGFW][1250] {0:3:916} Command: start for resource: ora.net1.network hyundai-db2 1 completed with status: SUCCESS
2013-04-03 09:29:36.307: [    AGFW][11] {0:3:916} Agent sending reply for: RESOURCE_START[ora.net1.network hyundai-db2 1] ID 4098:55193
2013-04-03 09:29:36.342: [ default][1250]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:36.343: [ default][1250]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:36.343: [ora.net1.network][1250] {0:3:916} [check] NetInterface::sCheckLink }
2013-04-03 09:29:36.343: [ USRTHRD][1250] {0:3:916} Thread:[VipRelocate:]start {
2013-04-03 09:29:36.343: [ USRTHRD][1250] {0:3:916} Thread:[VipRelocate:]start }
2013-04-03 09:29:36.344: [    AGFW][11] {0:3:916} ora.net1.network hyundai-db2 1 state changed from: STARTING to: ONLINE
2013-04-03 09:29:36.344: [    AGFW][11] {0:3:916} Switching offline monitor to online one
2013-04-03 09:29:36.344: [    AGFW][11] {0:3:916} Started implicit monitor for [ora.net1.network hyundai-db2 1] interval=1000 delay=1000
2013-04-03 09:29:36.344: [    AGFW][11] {0:3:916} Agent sending last reply for: RESOURCE_START[ora.net1.network hyundai-db2 1] ID 4098:55193
2013-04-03 09:29:36.469: [ USRTHRD][1251] {0:3:916} Thread:[VipRelocate:]isRunning is reset to false here
2013-04-03 09:29:37.177: [ora.scan1.vip][1250] {0:3:910} [check] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:37.228: [ora.scan1.vip][1250] {0:3:910} [check] InterfaceName = net0
2013-04-03 09:29:37.228: [ora.scan1.vip][1250] {0:3:910} [check] NetworkMask = 255.255.255.0
2013-04-03 09:29:37.228: [ora.scan1.vip][1250] {0:3:910} [check] NetworkAuto = static
2013-04-03 09:29:37.228: [ora.scan1.vip][1250] {0:3:910} [check] Checking if net0 Interface is fine
2013-04-03 09:29:37.315: [ora.scan1.vip][1250] {0:3:910} [check] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:37.339: [ora.scan1.vip][1250] {0:3:910} [check] ifname=net0
2013-04-03 09:29:37.339: [ora.scan1.vip][1250] {0:3:910} [check] subnetmask=255.255.255.0
2013-04-03 09:29:37.339: [ora.scan1.vip][1250] {0:3:910} [check] subnetnumber=10.102.105.0
2013-04-03 09:29:37.339: [ora.scan1.vip][1250] {0:3:910} [check] InterfaceName = net0
2013-04-03 09:29:37.339: [ora.scan1.vip][1250] {0:3:910} [check] HostName 10.102.105.19 translated to 10.102.105.19
2013-04-03 09:29:37.340: [ora.scan1.vip][1250] {0:3:910} [check] Interface Name = net0
2013-04-03 09:29:37.340: [ora.scan1.vip][1250] {0:3:910} [check] Ip Address = 10.102.105.19
2013-04-03 09:29:37.394: [ default][1250]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:37.395: [ default][1250]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:37.395: [ora.net1.network][1250] {0:3:916} [check] NetInterface::sCheckLink }
2013-04-03 09:29:38.260: [    AGFW][11] {0:3:916} Agent received the message: RESOURCE_START[ora.hyundai-db1.vip 1 1] ID 4098:55230
2013-04-03 09:29:38.260: [    AGFW][11] {0:3:916} Preparing START command for: ora.hyundai-db1.vip 1 1
2013-04-03 09:29:38.260: [    AGFW][11] {0:3:916} ora.hyundai-db1.vip 1 1 state changed from: OFFLINE to: STARTING
2013-04-03 09:29:38.262: [ora.hyundai-db1.vip][1250] {0:3:916} [start] (:CLSN00107:) clsn_agent::start {
2013-04-03 09:29:38.366: [ora.hyundai-db1.vip][1250] {0:3:916} [start] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:38.381: [ default][1245]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:38.382: [ default][1245]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:38.382: [ora.net1.network][1245] {0:3:916} [check] NetInterface::sCheckLink }
2013-04-03 09:29:38.410: [ora.hyundai-db1.vip][1250] {0:3:916} [start] InterfaceName = net0
2013-04-03 09:29:38.410: [ora.hyundai-db1.vip][1250] {0:3:916} [start] NetworkMask = 255.255.255.0
2013-04-03 09:29:38.410: [ora.hyundai-db1.vip][1250] {0:3:916} [start] NetworkAuto = static
2013-04-03 09:29:38.410: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Checking if net0 Interface is fine
2013-04-03 09:29:38.494: [ora.hyundai-db1.vip][1250] {0:3:916} [start] /usr/sbin/ifconfig -a | /usr/bin/grep  groupname returned non existent IPMP
2013-04-03 09:29:38.524: [ora.hyundai-db1.vip][1250] {0:3:916} [start] ifname=net0
2013-04-03 09:29:38.524: [ora.hyundai-db1.vip][1250] {0:3:916} [start] subnetmask=255.255.255.0
2013-04-03 09:29:38.524: [ora.hyundai-db1.vip][1250] {0:3:916} [start] subnetnumber=10.102.105.0
2013-04-03 09:29:38.524: [ora.hyundai-db1.vip][1250] {0:3:916} [start] InterfaceName = net0
2013-04-03 09:29:38.525: [ora.hyundai-db1.vip][1250] {0:3:916} [start] HostName hyundai-db1-vip translated to 10.102.105.17
2013-04-03 09:29:38.525: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Interface Name = net0
2013-04-03 09:29:38.525: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Ip Address = 10.102.105.17
2013-04-03 09:29:38.525: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Utils::getCrsHome crsHome /oracle/11.2.0/grid
2013-04-03 09:29:38.526: [ default][1250]ICMP Ping from 10.102.105.22 to 10.102.105.17
2013-04-03 09:29:39.394: [ default][1249]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:39.395: [ default][1249]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:39.395: [ora.net1.network][1249] {0:3:916} [check] NetInterface::sCheckLink }
2013-04-03 09:29:39.527: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Trying to plumb  10.102.105.17 on net0
2013-04-03 09:29:39.528: [ora.hyundai-db1.vip][1250] {0:3:916} [start] VipActions::startIp {
2013-04-03 09:29:39.528: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Adding 10.102.105.17 on net0
2013-04-03 09:29:40.386: [ default][1245]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:40.388: [ default][1245]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:40.388: [ora.net1.network][1245] {0:3:916} [check] NetInterface::sCheckLink }
2013-04-03 09:29:40.576: [ora.hyundai-db1.vip][1250] {0:3:916} [start] VipActions::startIp }
2013-04-03 09:29:40.576: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Flushing neighbours ARP Cache
2013-04-03 09:29:40.579: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Succeed to bind udp://10.102.105.17:0
2013-04-03 09:29:40.581: [ora.hyundai-db1.vip][1250] {0:3:916} [start] Succeed to bind udp://10.102.105.17:0
2013-04-03 09:29:40.582: [ora.hyundai-db1.vip][1250] {0:3:916} [start] (:CLSN00107:) clsn_agent::start }
2013-04-03 09:29:40.582: [    AGFW][1250] {0:3:916} Command: start for resource: ora.hyundai-db1.vip 1 1 completed with status: SUCCESS
2013-04-03 09:29:40.584: [    AGFW][11] {0:3:916} Agent sending reply for: RESOURCE_START[ora.hyundai-db1.vip 1 1] ID 4098:55230
2013-04-03 09:29:40.586: [    AGFW][11] {0:3:916} ora.hyundai-db1.vip 1 1 state changed from: STARTING to: PARTIAL
2013-04-03 09:29:40.586: [    AGFW][11] {0:3:916} Started implicit monitor for [ora.hyundai-db1.vip 1 1] interval=1000 delay=1000
2013-04-03 09:29:40.587: [    AGFW][11] {0:3:916} Agent sending last reply for: RESOURCE_START[ora.hyundai-db1.vip 1 1] ID 4098:55230
2013-04-03 09:29:41.403: [ default][1249]ICMP Ping from 10.102.105.22 to 10.102.105.36
2013-04-03 09:29:41.404: [ default][1249]clsicmp_pingdecode recvd from 0.0.0.0 Response type 0
2013-04-03 09:29:41.404: [ora.net1.network][1249] {0:3:916} [check] NetInterface::sCheckLink }

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 13:06 , Processed in 0.054880 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569