oracle 11G R2 RAC 心跳网络异常处理

最新推荐文章于 2023-04-04 15:07:14 发布
最新推荐文章于 2023-04-04 15:07:14 发布
阅读量5.4k 收藏 3
点赞数
分类专栏： rac 文章标签： oracle 11g
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hzcyhujw/article/details/79168486
版权

概述：在rac中心跳网络承载着重要的作用，当心跳网络的ip配置不正确亦或网卡名字不对都将使得rac启动等异常；运气不好时，心跳网卡都坏了，更换了一个网卡后是不是只能重装解决呢？


实验内容：

1、心跳网络IP网段配置错误；

2、心跳网络网卡更改或者是修改不正确；


实验一：

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.OCR.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.asm
               ONLINE  ONLINE       rac1                     Started             
               ONLINE  ONLINE       rac2                     Started             
ora.gsd
               OFFLINE OFFLINE      rac1                                         
               OFFLINE OFFLINE      rac2                                         
ora.net1.network
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.ons
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.registry.acfs
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                                         
ora.cube.db
      1        ONLINE  ONLINE       rac1                     Open                
      2        ONLINE  ONLINE       rac2                     Open                
ora.cvu
      1        ONLINE  ONLINE       rac1                                         
ora.oc4j
      1        ONLINE  ONLINE       rac1                                         
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                                         
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                                         
ora.scan1.vip
      1        ONLINE  ONLINE       rac1    

 

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/oifcfg getif
eth1  100.100.100.0  global  cluster_interconnect
bond0  192.168.100.0  global  public


[root@rac1 ~]# ifconfig eth1
eth1      Link encap:Ethernet  HWaddr 08:00:27:F7:67:C6  
          inet addr:100.100.100.100  Bcast:100.100.100.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fef7:67c6/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:15346 errors:0 dropped:0 overruns:0 frame:0
          TX packets:39482 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:7218263 (6.8 MiB)  TX bytes:40006495 (38.1 MiB)

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/oifcfg setif -global eth1/100.100.200.0:cluster_interconnect
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/oifcfg getif
eth1  100.100.100.0  global  cluster_interconnect
bond0  192.168.100.0  global  public
eth1  100.100.200.0  global  cluster_interconnect
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/oifcfg delif -global eth1/100.100.100.0:cluster_interconnect
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/oifcfg getif
bond0  192.168.100.0  global  public
eth1  100.100.200.0  global  cluster_interconnect


重新启动群集

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.cube.db' on 'rac1'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'
CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2674: Start of 'ora.cvu' on 'rac2' failed
CRS-2674: Start of 'ora.scan1.vip' on 'rac2' failed
CRS-2677: Stop of 'ora.cube.db' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.


[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t 
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.

查看集群启动日志：

[/u01/app/11.2.0/grid/bin/orarootagent.bin(6592)]CRS-5818:Aborted command 'start' for resource 'ora.cluster_interconnect.haip'. Details at (:CRSAGF00113:) {0:0:2} in /u01/app/11.2.0/grid/log/rac1/agent/ohasd/orarootagent_root/orarootagent_root.log.
2018-01-26 09:16:47.206: 
[ohasd(6215)]CRS-2757:Command 'Start' timed out waiting for response from the resource 'ora.cluster_interconnect.haip'. Details at (:CRSPE00111:) {0:0:2} in /u01/app/11.2.0/grid/log/rac1/ohasd/ohasd.log


vi /u01/app/11.2.0/grid/log/rac1/ohasd/ohasd.log

85ed0 [0000000000000010] { gipchaContext : host 'rac1', name 'CLSFRAME_cluster', luid '31303692-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd
2018-01-26 09:17:58.681: [GIPCHDEM][3556767488]gipchaDaemonInfRequest: sent local interfaceRequest,  hctx 0x1e85ed0 [0000000000000010] { gipchaContext : host 'rac1', name 'CLSFRAME_cluster', luid '31303692-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd
2018-01-26 09:18:04.689: [GIPCHDEM][3556767488]gipchaDaemonInfRequest: sent local interfaceRequest,  hctx 0x1e85ed0 [0000000000000010] { gipchaContext : host 'rac1', name 'CLSFRAME_cluster', luid '31303692-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd
2018-01-26 09:18:09.698: [GIPCHDEM][3556767488]gipchaDaemonInfRequest: sent local interfaceRequest,  hctx 0x1e85ed0 [0000000000000010] { gipchaContext : host 'rac1', name 'CLSFRAME_cluster', luid '31303692-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd
2018-01-26 09:18:14.714: [GIPCHDEM][3556767488]gipchaDaemonInfRequest: sent local interfaceRequest,  hctx 0x1e85ed0 [0000000000000010] { gipchaContext : host 'rac1', name 'CLSFRAME_cluster', luid '31303692-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd

种种日志表明，rac的心跳网络出现异常，此时我们可以借助gpnptool  工具进行修改心跳网络的配置：

查看心跳网络配置信息：

[root@rac1 ~]# ifconfig eth1
eth1      Link encap:Ethernet  HWaddr 08:00:27:F7:67:C6  
          inet addr:100.100.100.100  Bcast:100.100.100.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fef7:67c6/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:39324 errors:0 dropped:0 overruns:0 frame:0
          TX packets:63992 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:21550499 (20.5 MiB)  TX bytes:54030781 (51.5 MiB


查看gpnp profile的配置信息：

[grid@rac1 gpnp]$ gpnptool get
Warning: some command line parameters were defaulted. Resulting command line: 
         /u01/app/11.2.0/grid/bin/gpnptool.bin get -o-


<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="20" ClusterUId="afd4fb8a969e6ff0ff47999b3fa206d6" ClusterName="cluster" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" Adapter="bond0" IP="192.168.100.0" Use="public"/><gpnp:Network id="net2" Adapter="eth1" IP="100.100.200.0" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/asm*" SPFile="+OCR/cluster/asmparameterfile/registry.253.963054397"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>/+xj6ziNHXD2LxYcgnH83yVYWns=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>mh8+ulXRy6AgsgBB3AwJ6zdfmZzPTuvHbehpK97FMerHluIoQpmZmsKR0kwkrU03Bx8myEjwRfgz1XMJCZoNwAlvRfihxvQnV8kPAHRdrVOcz+HcYw/yvfkCS7WQJUTXpZwHzqM04xtmP5BgadE5AOxyDuI+hNfcgDeR24V0UhY=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.

对比发现实际网卡的心跳网络ip是100.100.100.X而profile 文件中的记录是100.100.200.X。


以排他模式及不启动crsd进程启动crs

[root@rac1 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/11.2.0/grid
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded

CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac1'
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2676: Start of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded
CRS-5017: The resource action "ora.cluster_interconnect.haip start" encountered the following error: 
Start action for HAIP aborted. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/rac1/agent/ohasd/orarootagent_root/orarootagent_root.log".
CRS-2674: Start of 'ora.cluster_interconnect.haip' on 'rac1' failed
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-4000: Command Start failed, or completed with errors.


[grid@rac1 ~]$ mkdir gpnp
[grid@rac1 ~]$ gpnptool get -o=/home/grid/gpnp/p.xml
Resulting profile written to "/home/grid/gpnp/p.xml".
Success.
[grid@rac1 ~]$ cd gpnp/

[grid@rac1 gpnp]$ cp p.xml profile.xml

[grid@rac1 gpnp]$ gpnptool getpval -p=/home/grid/gpnp/p.xml -prf_sq -o-
20

[grid@rac1 gpnp]$ gpnptool getpval -p=/home/grid/gpnp/p.xml -net -o-
net1 net2

[grid@rac1 gpnp]$ gpnptool edit -p=/home/grid/gpnp/p.xml -o=/home/grid/gpnp/p.xml -ovr -prf_sq=21 -net2:net_ip=100.100.100.0
Resulting profile written to "/home/grid/gpnp/p.xml".
Success.

查看修改成功没：

[grid@rac1 gpnp]$ cat p.xml 
<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="21" ClusterUId="afd4fb8a969e6ff0ff47999b3fa206d6" ClusterName="cluster" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" Adapter="bond0" IP="192.168.100.0" Use="public"/><gpnp:Network id="net2" Adapter="eth1" IP="100.100.100.0" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/asm*" SPFile="+OCR/cluster/asmparameterfile/registry.253.963054397"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>/+xj6ziNHXD2LxYcgnH83yVYWns=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>mh8+ulXRy6AgsgBB3AwJ6zdfmZzPTuvHbehpK97FMerHluIoQpmZmsKR0kwkrU03Bx8myEjwRfgz1XMJCZoNwAlvRfihxvQnV8kPAHRdrVOcz+HcYw/yvfkCS7WQJUTXpZwHzqM04xtmP5BgadE5AOxyDuI+hNfcgDeR24V0UhY=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>


[grid@rac1 gpnp]$ gpnptool getpval -p=/home/grid/gpnp/p.xml -prf_sq -o-
21
[grid@rac1 gpnp]$ gpnptool sign -p=/home/grid/gpnp/p.xml -o=/home/grid/gpnp/p.xml -ovr -w=cw-fs:peer
Resulting profile written to "/home/grid/gpnp/p.xml".
Success.

[grid@rac1 gpnp]$ gpnptool put -p=/home/grid/gpnp/p.xml 

Success.

[grid@rac1 gpnp]$ gpnptool find -c=cluster


Found 1 instances of service 'gpnp'.
        mdns:service:gpnp._tcp.local.://rac1:37760/agent=gpnpd,cname=cluster,host=rac1,pid=8419/gpnpd h:rac1 c:cluster
[grid@rac1 gpnp]$ gpnptool rget -c=cluster
Warning: some command line parameters were defaulted. Resulting command line: 
         /u01/app/11.2.0/grid/bin/gpnptool.bin rget -c=cluster -o-




Found 1 gpnp service instance(s) to rget profile from.


RGET from tcp://rac1:37760 (mdns:service:gpnp._tcp.local.://rac1:37760/agent=gpnpd,cname=cluster,host=rac1,pid=8419/gpnpd h:rac1 c:cluster):


<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="21" ClusterUId="afd4fb8a969e6ff0ff47999b3fa206d6" ClusterName="cluster" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" Adapter="bond0" IP="192.168.100.0" Use="public"/><gpnp:Network id="net2" Adapter="eth1" IP="100.100.100.0" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/asm*" SPFile="+OCR/cluster/asmparameterfile/registry.253.963054397"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>fF43VW1hAMTBFOZ+tuw3qbQSQDo=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>pYENVeL1XgZ2/fYmDY7xxMw+qY4AOYu+RApbJtVfIUA2muPuDmKVLYDddQOrX0XfwRdS3fFdO77cJuv1ApFUEQIDVjQdxVnzQWK+QhJUOvfsl1oE1g+rMNuJq3S6VWoRXLt4pr4wzY7CBkKdnoCdqsRu6u3yECWFiECUr6guk2Y=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.

重新启动群集

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.OCR.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.asm
               ONLINE  ONLINE       rac1                     Started             
               ONLINE  ONLINE       rac2                     Started             
ora.gsd
               OFFLINE OFFLINE      rac1                                         
               OFFLINE OFFLINE      rac2                                         
ora.net1.network
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.ons
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.registry.acfs
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                                         
ora.cube.db
      1        ONLINE  ONLINE       rac1                     Open                
      2        ONLINE  ONLINE       rac2                     Open                
ora.cvu
      1        ONLINE  ONLINE       rac1                                         
ora.oc4j
      1        ONLINE  ONLINE       rac1                                         
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                                         
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                                         
ora.scan1.vip
      1        ONLINE  ONLINE       rac1


总结：这篇文章针对修改心跳ip修改错误后导致群集启动不了，进而通过gpnptool 工具来实现。如果是网卡修改的改进，套路一样自行测试吧。




hzcyhujw
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ORACLE RAC心跳&&网络
数据库
02-14 7205
1、 RAC默认心跳时间         版本 misscount disktimeout reboottime 10.2.0.1 60s \ \ 10.2.0.1+p4896338/10.2.0.2 60s 200s 3s
oracle rac对心跳要求_oracle rac心跳线 Oracle RAC的心跳线断重启 - 硬件设备 - 服务器之家...
weixin_42478330的博客
12-28 1383
oracle rac心跳线 Oracle RAC的心跳线断重启发布时间：2017-05-23来源：服务器之家Oracle RAC的心跳线断重启主机环境：P5 570 2台 每台机器配备了2块光纤网卡AIX 5.3.0.5-00HACMP 5.2 (2007年4月的补丁)Oracle 10.2.0.3+RAC每台机器的2块光线网卡分别用作Oralce 的服务地址和Oracle RAC的心跳线地址用了...
交换机配置oracle心跳网络,AIX6.1 oracle 11g 11.2.0.4,网络心跳交叉线直连和交换机连接区别...
weixin_35133464的博客
04-09 418
关于oracle RAC心跳线的连接方式，各个论坛，包括网上文章的说法是：官方说是不建议直连，建议采用交换机连接的方式！首先说说心跳线的作用：oracle RAC不得不提的概念：健忘 和 脑裂健忘=》OCR脑裂=》VOTE下面谈谈直连的方式:在oracle9i rac的时侯采用直连的要比走交换机的要多。走交换机的优点是如果其中rac其中的一台掉电此时好的那台的网卡还是有信号的这样oracle会很容...
ORACLE RAC 心跳网卡配置网关，导致无法跨网段连接数据库
dsc1245的博客
03-24 3657
环境： RHEL 6.5      RAC 11.2.0.4 偶然现象，后来模拟不出来了，所以无日志，只是写症状和原因 我们平时可能会经常在RHEL6 上配置两个或多个不同网段的网卡和IP地址，并且每个网卡上的网关都是不同的，在正常情况下这很好，我们不会发现什么异常。 因为NetworkManager会为每个不同网段的访问请求指引相对应的网关，这符合我们的需求。 # rou
RAC环境集群组件gipc无法正确识别心跳网络状态问题分析
还不算晕的专栏
04-08 2332
近期，某用户环境出现集群数据库一个节点无法启动、加入集群的问题。集群版本为11.2版本，检查集群日志，问题比较明显，集群alert日志中让看CSSD进程日志，CSSD中显示无心跳网络:has a disk HB, but no network HB;按如下步骤排查处理： 1.首先通过hosts文件确认了数据库心跳网络IP，并在操作系统层面确认心跳网卡状态正常并且可以互相PING通、SSH联通。 2.通过gpnptool get确认集群使用的心跳网络即为上一步检查的。 3.根据11.2集群组件功能，GI
oracle 11G R2 RAC 心跳网络异常处理（二）
hzcyhujw的博客
01-26 2294
实验：心跳网络网卡更换或者修改错误重启后不可用恢复。 调整配置：心跳eth1:100.100.100.X修改为心跳eth2:10.10.10.X。日常中有可能是网卡损坏更换网卡。 eth1      Link encap:Ethernet  HWaddr 08:00:27:F7:67:C6             inet addr:100.100.100.100  Bcast:10
关于ORACLE RAC心跳问题的释疑
weixin_34372728的博客
02-03 865
1、rac心跳的作用：检测集群节点间的网络健康状态，还可用做缓存同步刷新及全局资源维护。在grid control出现后还传输数据块，其内联数据通信量比较大，通常是千兆网，当然使用万兆更好。2、rac心跳能否用直连网线？直连网线限制RAC至两节点，另外直连网线不稳定，由此造成的BUG和技术问题，ORACLE不提供相应的技术支持。具体看ORACLE官方解释：RAC: Frequently Asked...
oracle10g集群心跳断开,处理oracle 10g rac心跳网卡变更一例
weixin_39789206的博客
04-10 180
一天sa打电话来说有台机器宕了，问我们是不是有数据库出问题了，引起了主机的宕机，赶紧登上去，tail一下alter.log，发现数据库启动时报下面错误：Interface type 1 eth1 192.168.11.0 configured from OCR for use as a cluster interconnectWARNING 192.168.11.0 could not be tr...
ora.crsd服务offline状态处理
最新发布
kevinyu998的博客
04-04 751
立刻使用crsctl status res -t -init，发现ora.crsd服务online了。昨晚处理的，oracle 11g rac环境的 ora.crsd服务异常，今天想起来了log下，查看数据库实例正常，也对外提供服务，通常的做法就是关闭主机上的实例，重启集群使得环境恢复正常。3、步骤2操作后稍等2~3分钟，使用crsctl stat res -t命令输出，已全部恢复正常。使用asmcmd -p lsdg查看磁盘组，意料之中的事情，之前遇到过多次。2、使用root用户启动crsd服务。
心跳丢失造成RAC节点驱逐
yangjunfeng0604的博客
10-11 277
赶上了迁库风，我们的一套再建生产业务库发生了主机重启，什么原因呢[root@nqzeyddb2 ~]# uptime 15:42:46 up 5 days, 22:29, 4 users, load average: 0.08, 0.09, 0.10 alert日志里面没有明显告警，crs里面是有明显的超时告警的，怀...
关于Oracle实例之间的心跳,关于ORACLE RAC心跳问题的释疑
weixin_35361584的博客
04-04 561
1、rac心跳的作用：检测集群节点间的网络健康状态，还可用做缓存同步刷新及全局资源维护。在grid control出现后还传输数据块，其内联数据通信量比较大，通常是千兆网，当然使用万兆更好。2、rac心跳能否用直连网线？直连网线限制RAC至两节点，另外直连网线不稳定，由此造成的BUG和技术问题，ORACLE不提供相应的技术支持。具体看ORACLE官方解释：RAC: Frequently Asked...
安装oracle11g r2 RAC时遭遇无法启动scan ip的错误（crs-5005）
雨花石
03-01 7311
Oracle rac scan ip crs-5005
对于RAC心跳以及仲裁机制的理解
weixin_33800463的博客
02-22 405
1、节点1网卡损坏，无法接受到其他节点的心跳。 节点2能够接受到节点三的心跳，节点3能够接收到节点2的心跳。 节点1，心跳信息给votingdisk说：“只有我活着！” 节点2、3，心跳信息给votingdisk说：“我和2，我和3，都活着”。 votingdisk将在自身节点1的部分上写一个“赐死块”（kill block），节点1读取到...
关于ORACLE的一点总结
cjfcxf010101的博客
05-20 232
[每天进步一点点]关于RAC心跳线：1、心跳线的作用是用来同步实例1和实例2之间数据的；2、故障点转移；3、负载均衡，两个节点同时工作。在RMAN备份时，在实例1分配一个通道，另一个通道分配在实例2上，两个节点同时工作，速度更快...
GRID下sqlnet.ora 设置错误导致ASM访问不了
jnrjian的博客
09-21 817
--sqlnet.ora 错了启动不了，启动后打开也没有用。--------------正常情况。
rac 11g服务器监听配置文件,11gR2 RAC监听器配置
weixin_34025386的博客
08-06 715
11g里面，默认监听端口1521已经被GI配置ASM实例时所占据，本文采用1537端口，为RAC实现负载均衡配置监听器。一、先通过vi listener.ora和tnsname.ora文件配置监听器。rac01:vi$ORACLE_HOME/network/admin/listener.ora:HOST: rac01vip, rac01(利用rac01的VIP和Public IP配置)vi$ORA...
Oracle 11gR2 RAC 常用维护操作 说明
maco的博客
07-21 924
之前整理了2篇Oracle 10gRAC的启动与关闭相关的文章，参考：Oracle 10gRAC 启动与关闭http://blog.csdn.net/tianlesoftware/article/details/5349003 Oracle RAC 常用维护工具和命令http://blog.csdn.net/tianlesoftware/article/details/5358573 一．启动和停止
红旗linux下的 CRS-2674: Start of 'ora.registry.acfs' on '4a' failed
Dillon Oracle博客
10-12 2745
记一次红旗linux下安装，遇到的问题   在红旗linux下安装11grac的时候，遇到这样一个报错信息 [root@4A ~]# /u02/app/11.2.0/grid/root.sh Performing root user operation for Oracle 11g   The following environment variables are set as:
CRS-2674: Start of ‘ora.cssd‘ on ‘rac2‘ failed 引发的rac集群服务起不来问题
m0_38048955的博客
03-26 1625
问题背景：客户反馈Oracle rac集群节点宕机 1、首先查看宕机原因，归档日志满导致服务重启，查看归档日志路径是USE_DB_RECOVERY_FILE_DEST （默认路径）， 安装的时候没有做调整，应该调整单独的归档目录，首先清理归档日志然后修改归档路径 2、节点一正常启动，节点二起不来 没有cluster服务 检查集群服务 在rac2节点上检查集群服务的状态报错 1 [grid@rac2 ~]# /u01/app/11.2.0/grid/bin/crs_stat -t 2 CR...
虚拟机中构建Oracle11g R2 RAC学习环境指南
"如何使用虚拟机搭建Oracle11g R2 RAC学习环境" 搭建Oracle 11g R2 RAC (Real Application Clusters) 学习环境通常需要昂贵的硬件，包括共享存储设备，这对于许多个人或学习者来说可能难以实现。然而，通过虚拟化...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值