Chinaunix首页 | 论坛 | 认证专区 | 博客 登录 | 注册
  • 博客访问: 1929126
  • 博文数量: 581
  • 博客积分: 10716
  • 博客等级: 上将
  • 技术积分: 7231
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-01 22:35
文章分类

全部博文(581)

文章存档

2017年(35)

2016年(22)

2015年(1)

2013年(12)

2012年(20)

2011年(18)

2010年(18)

2009年(271)

2008年(183)

微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题
gntp profile修复RAC节点问题 2017-08-12 22:19:04

分类: Oracle

SSD上的一个11.2 RAC的其中一个节点OS不能起来了,鼓捣半天还是不行
想想这个是2013年买的,才两年啊……,不知道是不是这个原因,反正很无语……
另一个10多年前的活动硬盘上那个RedHat 2上的Oracle 8.0.6都还可以使用
.
就这个环境,从其他活动硬盘上复制了节点1的老的备份到SSD上,尝试修复整个RAC。
由于只修改了节点1的IP跟我现在VBOX中的配置一致即可,且节点2是正常的,因此,无需大招。
只要两件事情;
1,在OS层面修改节点1的网络配置:

/etc/hosts 
/etc/sysconfig/network-sritps/oifcfg-eth1
/etc/sysconfig/network

2,把节点2的gpnp profile传给节点1
.
具体如下:
1,将2个节点的crsd都关闭,把节点2的profile.xml复制到节点1:
确认节点2的crs是关闭的:

[root@RAC2 ~]# ps -ef|grep d.bin
root      5026  3697  0 22:49 pts/4    00:00:00 grep d.bin
[root@RAC2 ~]#

2,确认当前的节点2的gpnp profile信息是正确的:
我这里主要是私有网络的IP地址应该为192.168.20.0网段:

可见这里是正确的。

[root@RAC2 ~]# gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
         /u01/11.2.0/grid/bin/gpnptool.bin get -o-
 
Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
GPnP service is not running on localhost. Found locally cached profile...
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="12" ClusterUId="4c62524e6a7dff62ffdae005dc6a08d6" ClusterName="racdb" PALocation="">http://www.w3.org/2000/09/xmldsig#">http://www.w3.org/2001/10/xml-exc-c14n#"/>http://www.w3.org/2000/09/xmldsig#rsa-sha1"/>http://www.w3.org/2000/09/xmldsig#enveloped-signature"/>http://www.w3.org/2001/10/xml-exc-c14n#"> http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/>http://www.w3.org/2000/09/xmldsig#sha1"/>s+dn2dL74Wsg58TpBl1wukYt3JM=hGmm6px+trv2uYThXOlkXUvuMjSJng7ZXgcWdwGeOugAXWRd58f/cHvHbioeKi2XK0kcUnh5OW2a9Mlhpy52Xi8+QdZdHNh5DSZ02HggiEJf0o0T29TZJr2mafTYyNKqzhHRv3aidAxwrPjLPr80rk6tEhB60hY9Ew+G15Do7D4=
Success.
 
Error CLSGPNP_NO_DAEMON getting profile.
[root@RAC2 ~]#

注意这里,当所有CRS进程都不启动时,gpnp的信息来自于他自己的一个cache(猜测这个是从文件上保存的profile中读取到他自己的所谓cache的)
.
3,查看节点1当前的gpnp profile,注意,其中的net2的信息,是错误的:

[root@RAC1 bin]# ./gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
         ./gpnptool.bin get -o-
 
Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
GPnP service is not running on localhost. Found locally cached profile...
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="8" ClusterUId="4c62524e6a7dff62ffdae005dc6a08d6" ClusterName="racdb" PALocation="">http://www.w3.org/2000/09/xmldsig#">http://www.w3.org/2001/10/xml-exc-c14n#"/>http://www.w3.org/2000/09/xmldsig#rsa-sha1"/>http://www.w3.org/2000/09/xmldsig#enveloped-signature"/>http://www.w3.org/2001/10/xml-exc-c14n#"> http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/>http://www.w3.org/2000/09/xmldsig#sha1"/>oNh4/PhSSqqj2jARHJa0GCNngHE=WThZxj2jGML+m+UrGrPBGZztS5xw6KJMb4eFL5l2MURoPAZCso5Ld9uTJ/taYpZAnamwYNYvkpouc/g/PuTI1WJGc2IBzFmF0ECnWXGGEPcS/8Sm4iiVvkyAYc/kNUA/DLzCvq1hozOopVgmQgfJZ/B+WVP423mBrnPFKYaFRKY=
Success.
 
Error CLSGPNP_NO_DAEMON getting profile.
[root@RAC1 bin]#

4,确认节点1的crs全部都是关闭的:

[root@RAC1 bin]# ps -ef|grep d.bin
root      3523  2865  0 22:48 pts/1    00:00:00 grep d.bin
[root@RAC1 bin]#

5,备份节点1当前的gpnp profile:

[root@RAC1 bin]# mkdir /home/oracle/gpnp
[root@RAC1 bin]# export GPNPDIR=/home/oracle/gpnp
[root@RAC1 bin]# env|grep GPNPDIR
GPNPDIR=/home/oracle/gpnp
[root@RAC1 bin]# ./gpnptool get -o=$GPNPDIR/profile.original
Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
GPnP service is not running on localhost. Found locally cached profile...
Resulting profile written to "/home/oracle/gpnp/profile.original".
Success.
 
Error CLSGPNP_NO_DAEMON getting profile.
[root@RAC1 bin]# ll /home/oracle/gpnp/profile.original
-rw-r--r-- 1 root root 1878 Apr 11 22:52 /home/oracle/gpnp/profile.original
[root@RAC1 bin]#

6,将节点2的gpnp profile复制到节点1:

[root@RAC2 ~]# ll $GRID_HOME/gpnp/rac2
total 8
drwxr-x--T 6 grid oinstall 4096 May  3  2013 wallets
drwxr-x--- 3 grid oinstall 4096 May  3  2013 profiles
[root@RAC2 ~]# scp $GRID_HOME/gpnp/rac2/profiles/peer/profile.xml rac1:$GRID_HOME/gpnp/rac1/profiles/peer/profile.xml
root@rac1's password:
profile.xml                                                                                                                                                 100% 1900     1.9KB/s   00:00   
[root@RAC2 ~]#

7,启动节点1和节点2的crs(正常启动即可):

[root@RAC1 bin]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@RAC1 bin]#

8,可以看到,节点1已经可以正常启动了:

[root@RAC1 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMDATA.dg
               ONLINE  ONLINE       rac1                                        
ora.DATA.dg
               ONLINE  ONLINE       rac1                                        
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                                        
ora.LISTENER_DG.lsnr
               ONLINE  ONLINE       rac1                                        
ora.asm
               ONLINE  ONLINE       rac1                     Started            
ora.gsd
               OFFLINE OFFLINE      rac1                                        
ora.net1.network
               ONLINE  ONLINE       rac1                                        
ora.net2.network
               ONLINE  ONLINE       rac1                                        
ora.ons
               ONLINE  ONLINE       rac1                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                                        
ora.cvu
      1        ONLINE  ONLINE       rac1                                        
ora.oc4j
      1        ONLINE  ONLINE       rac1                                        
ora.r-dg1-vip.vip
      1        ONLINE  ONLINE       rac1                                        
ora.r-dg2-vip.vip
      1        ONLINE  INTERMEDIATE rac1                     FAILED OVER        
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                                        
ora.rac2.vip
      1        ONLINE  INTERMEDIATE rac1                     FAILED OVER        
ora.racdb.db
      1        ONLINE  ONLINE       rac1                     Open               
      2        ONLINE  OFFLINE                                                  
ora.scan1.vip
      1        ONLINE  ONLINE       rac1                                        
[root@RAC1 ~]# gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
         /u01/11.2.0/grid/bin/gpnptool.bin get -o-
 
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="12" ClusterUId="4c62524e6a7dff62ffdae005dc6a08d6" ClusterName="racdb" PALocation="">http://www.w3.org/2000/09/xmldsig#">http://www.w3.org/2001/10/xml-exc-c14n#"/>http://www.w3.org/2000/09/xmldsig#rsa-sha1"/>http://www.w3.org/2000/09/xmldsig#enveloped-signature"/>http://www.w3.org/2001/10/xml-exc-c14n#"> http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/>http://www.w3.org/2000/09/xmldsig#sha1"/>s+dn2dL74Wsg58TpBl1wukYt3JM=hGmm6px+trv2uYThXOlkXUvuMjSJng7ZXgcWdwGeOugAXWRd58f/cHvHbioeKi2XK0kcUnh5OW2a9Mlhpy52Xi8+QdZdHNh5DSZ02HggiEJf0o0T29TZJr2mafTYyNKqzhHRv3aidAxwrPjLPr80rk6tEhB60hY9Ew+G15Do7D4=
Success.
[root@RAC1 ~]#

这里看到节点1的网络信息也正常了

再启动节点2:

[root@RAC2 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@RAC2 ~]#

除了network2(用于ADG的网络,还没有修改相应的配置),其他都正常了。

[root@RAC2 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMDATA.dg
               ONLINE  ONLINE       rac1                                        
               ONLINE  ONLINE       rac2                                        
ora.DATA.dg
               ONLINE  ONLINE       rac1                                        
               ONLINE  ONLINE       rac2                                        
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                                        
               ONLINE  ONLINE       rac2                                        
ora.LISTENER_DG.lsnr
               ONLINE  ONLINE       rac1                                        
               ONLINE  OFFLINE      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.net2.network
               ONLINE  ONLINE       rac1                                        
               ONLINE  OFFLINE      rac2                                        
ora.ons
               ONLINE  ONLINE       rac1                                        
               ONLINE  ONLINE       rac2                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                                        
ora.cvu
      1        ONLINE  ONLINE       rac1                                        
ora.oc4j
      1        ONLINE  ONLINE       rac1                                        
ora.r-dg1-vip.vip
      1        ONLINE  ONLINE       rac1                                        
ora.r-dg2-vip.vip
      1        ONLINE  INTERMEDIATE rac1                     FAILED OVER        
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                                        
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                                        
ora.racdb.db
      1        ONLINE  ONLINE       rac1                     Open               
      2        ONLINE  ONLINE       rac2                     Open               
ora.scan1.vip
      1        ONLINE  ONLINE       rac1                                        
[root@RAC2 ~]#
阅读(1882) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册