ITPub博客

首页 > 数据库 > Oracle > 11G RAC物理IP和VIP的修改

11G RAC物理IP和VIP的修改

原创 Oracle 作者:中奖1000万 时间:2017-06-10 16:08:46 0 删除 编辑
停止数据库:
[grid@yq ~]$ srvctl stop db -d orcl
查看ip信息
#public ip              
192.168.56.120  lzl     eth0
192.168.56.123  yq      eth0
#virtual ip             
192.168.56.121  lzl-vip 
192.168.56.124  yq-vip  
#private ip             
192.168.0.110   lzl-priv
192.168.0.111   yq-priv 
#scan ip                
192.168.56.125  rac-scan        
停掉集群
       [root@lzl ~]# /u01/11.2.0/grid/bin/crsctl stop crs                                             
       CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'lzl'    
       CRS-2673: Attempting to stop 'ora.crsd' on 'lzl'                                               
       CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'lzl'               
       CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'lzl'                                
       CRS-2672: Attempting to start 'ora.net1.network' on 'yq'                                       
       CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'lzl'                                      
       CRS-2673: Attempting to stop 'ora.oc4j' on 'lzl'                                               
       CRS-2673: Attempting to stop 'ora.OCR_VOTE.dg' on 'lzl'                                        
       CRS-2673: Attempting to stop 'ora.registry.acfs' on 'lzl'                                      
       CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'lzl'                                          
       CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'lzl' succeeded                                 
       CRS-2676: Start of 'ora.net1.network' on 'yq' succeeded                                        
       CRS-2672: Attempting to start 'ora.ons' on 'yq'                                                
       CRS-2673: Attempting to stop 'ora.scan1.vip' on 'lzl'                                          
       CRS-2673: Attempting to stop 'ora.lzl.vip' on 'lzl'                                            
       CRS-2673: Attempting to stop 'ora.cvu' on 'lzl'                                                
       CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'lzl' succeeded                                       
       CRS-2677: Stop of 'ora.cvu' on 'lzl' succeeded                                                 
       CRS-2672: Attempting to start 'ora.cvu' on 'yq'                                                
       CRS-2676: Start of 'ora.ons' on 'yq' succeeded                                                 
       CRS-2676: Start of 'ora.cvu' on 'yq' succeeded                                                 
       CRS-2677: Stop of 'ora.lzl.vip' on 'lzl' succeeded                                             
       CRS-2672: Attempting to start 'ora.lzl.vip' on 'yq'                                            
       CRS-2677: Stop of 'ora.scan1.vip' on 'lzl' succeeded                                           
       CRS-2672: Attempting to start 'ora.scan1.vip' on 'yq'                                          
       CRS-2677: Stop of 'ora.registry.acfs' on 'lzl' succeeded                                       
       CRS-2676: Start of 'ora.lzl.vip' on 'yq' succeeded                                             
       CRS-2676: Start of 'ora.scan1.vip' on 'yq' succeeded                                           
       CRS-2673: Attempting to stop 'ora.yq.vip' on 'lzl'                                             
       CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'yq'                                
       CRS-2677: Stop of 'ora.yq.vip' on 'lzl' succeeded                                              
       CRS-2672: Attempting to start 'ora.yq.vip' on 'yq'                                             
       CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'yq' succeeded                                 
       CRS-2676: Start of 'ora.yq.vip' on 'yq' succeeded                                              
       CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'yq'                                      
       CRS-2677: Stop of 'ora.DATADG.dg' on 'lzl' succeeded                                           
       CRS-2676: Start of 'ora.LISTENER.lsnr' on 'yq' succeeded                                       
       CRS-2677: Stop of 'ora.OCR_VOTE.dg' on 'lzl' succeeded                                         
       CRS-2673: Attempting to stop 'ora.asm' on 'lzl'                                                
       CRS-2677: Stop of 'ora.asm' on 'lzl' succeeded                                                 
       CRS-2677: Stop of 'ora.oc4j' on 'lzl' succeeded                                                
       CRS-2672: Attempting to start 'ora.oc4j' on 'yq'                                                                                                                                              
       CRS-2674: Start of 'ora.oc4j' on 'yq' failed                                                   
       CRS-2679: Attempting to clean 'ora.oc4j' on 'yq'                                               
       CRS-2681: Clean of 'ora.oc4j' on 'yq' succeeded                                                
       CRS-2673: Attempting to stop 'ora.ons' on 'lzl'                                                
       CRS-2677: Stop of 'ora.ons' on 'lzl' succeeded                                                 
       CRS-2673: Attempting to stop 'ora.net1.network' on 'lzl'                                       
       CRS-2677: Stop of 'ora.net1.network' on 'lzl' succeeded                                        
       CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'lzl' has completed          
       CRS-2677: Stop of 'ora.crsd' on 'lzl' succeeded                                                
       CRS-2673: Attempting to stop 'ora.mdnsd' on 'lzl'                                              
       CRS-2673: Attempting to stop 'ora.crf' on 'lzl'                                                
       CRS-2673: Attempting to stop 'ora.ctssd' on 'lzl'                                              
       CRS-2673: Attempting to stop 'ora.evmd' on 'lzl'                                               
       CRS-2673: Attempting to stop 'ora.asm' on 'lzl'                                                
       CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'lzl'                                       
       CRS-2677: Stop of 'ora.crf' on 'lzl' succeeded                                                 
       CRS-2677: Stop of 'ora.evmd' on 'lzl' succeeded                                                
       CRS-2677: Stop of 'ora.mdnsd' on 'lzl' succeeded                                               
       CRS-2677: Stop of 'ora.ctssd' on 'lzl' succeeded                                               
       CRS-2677: Stop of 'ora.drivers.acfs' on 'lzl' succeeded                                        
       CRS-2677: Stop of 'ora.asm' on 'lzl' succeeded                                                 
       CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'lzl'                          
       CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'lzl' succeeded                           
       CRS-2673: Attempting to stop 'ora.cssd' on 'lzl'                                               
       CRS-2677: Stop of 'ora.cssd' on 'lzl' succeeded                                                
       CRS-2673: Attempting to stop 'ora.gipcd' on 'lzl'                                              
       CRS-2677: Stop of 'ora.gipcd' on 'lzl' succeeded                                               
       CRS-2673: Attempting to stop 'ora.gpnpd' on 'lzl'                                              
       CRS-2677: Stop of 'ora.gpnpd' on 'lzl' succeeded                                               
       CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'lzl' has completed
       CRS-4133: Oracle High Availability Services has been stopped.                                  
       [root@lzl ~]#                        
      
修改成以下的IP地址
#public ip              
192.168.56.130  lzl     eth0
192.168.56.133  yq      eth0
#virtual ip             
192.168.56.131  lzl-vip 
192.168.56.134  yq-vip  
#private ip             
192.168.0.110   lzl-priv
192.168.0.111   yq-priv 
#scan ip                
192.168.56.125  rac-scan 
停掉集群(我是2个节点都做)
[root@lzl ~]# /u01/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[grid@lzl ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4529: Cluster Synchronization Services is online
CRS-4534: Cannot communicate with Event Manager
修改PUBLIC ip和VIP
[root@lzl bin]# ./oifcfg getif
eth0  192.168.56.0  global  public
eth1  192.168.0.0  global  cluster_interconnect
[root@lzl bin]# ./oifcfg delif -global eth0
[root@lzl bin]# ./oifcfg setif -global eth0/192.168.56.1:public
[root@lzl bin]#
[root@lzl bin]# ./oifcfg getif
eth1  192.168.0.0  global  cluster_interconnect
eth0  192.168.56.1  global  public
[root@lzl bin]# ./oifcfg setif -global eth0/192.168.56.0:public
[root@lzl bin]# ./oifcfg getif
eth1  192.168.0.0  global  cluster_interconnect
eth0  192.168.56.1  global  public
eth0  192.168.56.0  global  public
定义VIP
[root@lzl bin]# ./srvctl config vip -n lzl
VIP exists: /lzl-vip/192.168.56.131/192.168.56.0/255.255.255.0/eth0, hosting node lzl
[root@yq ~]# /u01/11.2.0/grid/bin/srvctl config vip -n yq
VIP exists: /yq-vip/192.168.56.134/192.168.56.0/255.255.255.0/eth0, hosting node yq
停止监听和vip并重设VIP
[root@yq bin]# ./srvctl stop listener -n yq
[root@yq bin]# ./srvctl stop vip -n yq
[root@yq bin]# ./srvctl modify nodeapps -n yq -A 192.168.56.134/255.255.255.0/eth0
[root@lzl bin]# ./srvctl stop listener -n lzl
[root@lzl bin]# ./srvctl stop vip -n lzl
[root@lzl bin]# ./srvctl modify nodeapps -n lzl -A 192.168.56.131/255.255.255.0/eth0
[root@yq bin]# ./srvctl config vip -n lzl
VIP exists: /lzl-vip/192.168.56.131/192.168.56.0/255.255.255.0/eth0, hosting node lzl
[root@yq bin]# ./srvctl config vip -n yq
VIP exists: /yq-vip/192.168.56.134/192.168.56.0/255.255.255.0/eth0, hosting node yq
[root@yq bin]#

[root@lzl bin]# ./srvctl start vip -n lzl
[root@lzl bin]# ./srvctl start vip -n yq
[root@lzl bin]# ./srvctl start listener -n lzl
[root@lzl bin]# ./srvctl start listener -n yq
[root@lzl bin]# ./srvctl start database -d orcl
VIP已经自动注册
[oracle@lzl ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 5 18:09:26 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
SQL>
SQL> show parameter local_listener
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string       (ADDRESS=(PROTOCOL=TCP)(HOST=
                                                 192.168.56.131)(PORT=1521))
SQL> show parameter local_listener
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string       (ADDRESS=(PROTOCOL=TCP)(HOST=
                                                 192.168.56.134)(PORT=1521))
                                                

                                                         

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31467250/viewspace-2140574/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 闪回表
请登录后发表评论 登录
全部评论

注册时间:2017-06-09

  • 博文量
    25
  • 访问量
    40578