oracle-RAC修改服务器ip

主要实施步骤如下：

• 1.正常关库、监听和CRS
• 2.修改/etc/hosts配置文件
• 3.OS层修改公有网卡地址
• 4.启动crs
• 5.修改Public IP,VIP,SCAN VIP
• 6.修改Private IP
• Reference

环境说明：服务器操作系统centos7.3、oracle RAC 11.2.0.4

说明：服务器实际ip变动，虚拟ip不变

#pub
80.150.20.101     msrkzyk1  
80.150.20.102     msrkzyk2  
#pri 
172.168.1.1        msrkzyk1p
172.168.1.2        msrkzyk2p
#vip
80.150.20.103     msrkzyk1v 
80.150.20.104     msrkzyk2v

#scan 
80.150.20.105      msrkscan

-----
--改后
#pub
80.150.22.101     msrkzyk1  
80.150.22.102     msrkzyk2  
#pri 
172.168.1.1        msrkzyk1p
172.168.1.2        msrkzyk2p
#vip
80.150.22.103     msrkzyk1v 
80.150.22.104     msrkzyk2v

#scan 
80.150.22.105      msrkscan

1、[root@node-1 ~]# crs_stop -all

[root@node-1 ~]# crsctl stop crs -f #强制停止

2、修改服务器的物理ip

3、然后再vi修改/etc/hosts文件

4、重新配置免密ssh

su - grid
ssh-keygen
ssh-copy-id grid@80.150.22.101
ssh-copy-id grid@80.150.22.102
ssh-copy-id grid@172.168.1.1
ssh-copy-id grid@172.168.1.2

ssh grid@172.168.1.1 date
ssh grid@172.168.1.2 date
ssh grid@80.150.22.101 date
ssh grid@80.150.22.102 date

ssh grid@msrkzyk1 date
ssh grid@msrkzyk2 date

ssh grid@msrkzyk1p date
ssh grid@msrkzyk2p date

su - oracle
ssh-keygen
ssh-copy-id oracle@80.150.22.101
ssh-copy-id oracle@80.150.22.102
ssh-copy-id oracle@172.168.1.1
ssh-copy-id oracle@172.168.1.2

ssh oracle@172.168.1.1 date
ssh oracle@172.168.1.2 date
ssh oracle@80.150.22.101 date
ssh oracle@80.150.22.102 date

ssh oracle@msrkzyk1 date
ssh oracle@msrkzyk2 date

ssh oracle@msrkzyk1p date
ssh oracle@msrkzyk2p date

5、启动crs

[root@msrkzyk2 ~]# /u01/grid/11.2/bin/crsctl start crs

注意：这里如果是按照我上面关闭crs的操作，正常数据库和监听是没有启动的，对应target和state都应该是offline：

ora.LISTENER.lsnr
               OFFLINE OFFLINE      msrkzyk1                            
               OFFLINE OFFLINE      msrkzyk2       
ora.msrkzyk.db
      1        OFFLINE OFFLINE                    Instance Shutdown
      2        OFFLINE OFFLINE                    Instance Shutdown

6、修改Public IP,VIP,SCAN VIP

6.1 修改Public IP

[root@msrkzyk1 ~]# find / -name oifcfg #查找命令
/u01/grid/11.2/bin/oifcfg getif  

[root@msrkzyk1 ~]# /u01/grid/11.2/bin/oifcfg getif #查看ip
eno1  80.150.20.0  global  public
eno2  172.168.1.0  global  cluster_interconnect

#节点一设置ip,删除ip 设置ip
[root@msrkzyk1 ~]# /u01/grid/11.2/bin/oifcfg delif -global eno1  #删除原public ip
[root@msrkzyk1 ~]# /u01/grid/11.2/bin/oifcfg setif -global eno1/80.150.22.0:public  #设置新public ip
#两个节点查看ip
[root@msrkzyk1 ~]# /u01/grid/11.2/bin/oifcfg getif
eno2  172.168.1.0  global  cluster_interconnect
eno1  80.150.22.0  global  public
[root@msrkzyk2 ~]# /u01/grid/11.2/bin/oifcfg getif
eno2  172.168.1.0  global  cluster_interconnect
eno1  80.150.22.0  global  public

6.2 修改VIP

需要停止数据库、监听和vip，目前数据库和监听、vip都是停止的查看命令grid用户

srvctl stop vip -n msrkzyk1 #停止命令

#单独查看

[grid@msrkzyk1 ~]$ srvctl status vip -n msrkzyk1
VIP msrkzyk1v is enabled
VIP msrkzyk1v is not running

[grid@msrkzyk1 ~]$ srvctl status vip -n msrkzyk2
VIP msrkzyk2v is enabled
VIP msrkzyk2v is not running
[grid@msrkzyk1 ~]$ srvctl status database -d msrkzyk
Instance msrkzyk1 is not running on node msrkzyk1
Instance msrkzyk2 is not running on node msrkzyk2

[grid@msrkzyk1 ~]$ srvctl status LISTENER -n msrkzyk1
Listener LISTENER is enabled on node(s): msrkzyk1
Listener LISTENER is not running on node(s): msrkzyk1
[grid@msrkzyk1 ~]$ srvctl status LISTENER -n msrkzyk2
Listener LISTENER is enabled on node(s): msrkzyk2
Listener LISTENER is not running on node(s): msrkzyk2

#或者

[grid@msrkzyk1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.DATA.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.FRA.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.LISTENER.lsnr
               OFFLINE OFFLINE      msrkzyk1                                     
               OFFLINE OFFLINE      msrkzyk2                                     
ora.PIC.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.asm
               ONLINE  ONLINE       msrkzyk1                 Started             
               ONLINE  ONLINE       msrkzyk2                 Started             
ora.gsd
               OFFLINE OFFLINE      msrkzyk1                                     
               OFFLINE OFFLINE      msrkzyk2                                     
ora.net1.network
               ONLINE  OFFLINE      msrkzyk1                                     
               ONLINE  OFFLINE      msrkzyk2                                     
ora.ons
               ONLINE  OFFLINE      msrkzyk1                                     
               ONLINE  OFFLINE      msrkzyk2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                                                   
ora.cvu
      1        OFFLINE OFFLINE                                                   
ora.msrkzyk.db
      1        OFFLINE OFFLINE                               Instance Shutdown   
      2        OFFLINE OFFLINE                               Instance Shutdown   
ora.msrkzyk1.vip
      1        OFFLINE OFFLINE                                                   
ora.msrkzyk2.vip
      1        OFFLINE OFFLINE                                                   
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.scan1.vip
      1        OFFLINE OFFLINE 

查看当前vip设置 grid用户

[grid@msrkzyk1 ~]$ olsnodes -s
msrkzyk1        Active
msrkzyk2        Active
[grid@msrkzyk1 ~]$ srvctl config vip -n msrkzyk1
VIP exists: /msrkzyk1v/80.150.22.103/80.150.20.0/255.255.255.0/eno1, hosting node msrkzyk1
[grid@msrkzyk1 ~]$ srvctl config vip -n msrkzyk2
VIP exists: /msrkzyk2v/80.150.22.104/80.150.20.0/255.255.255.0/eno1, hosting node msrkzyk2

修改vip设置 root 用户

[root@msrkzyk1 ~]# find / -name srvctl
/u01/grid/11.2/bin/srvctl

[root@msrkzyk1 ~]# /u01/grid/11.2/bin/srvctl modify nodeapps -n msrkzyk1 -A 80.150.22.103/255.255.255.0/eno1
[root@msrkzyk1 ~]# /u01/grid/11.2/bin/srvctl modify nodeapps -n msrkzyk2 -A 80.150.22.104/255.255.255.0/eno1

再次验证vip设置

[root@msrkzyk1 ~]# /u01/grid/11.2/bin/srvctl config vip -n msrkzyk1
VIP exists: /msrkzyk1v/80.150.22.103/80.150.22.0/255.255.255.0/eno1, hosting node msrkzyk1
[root@msrkzyk1 ~]# /u01/grid/11.2/bin/srvctl config vip -n msrkzyk2
VIP exists: /msrkzyk2v/80.150.22.104/80.150.22.0/255.255.255.0/eno1, hosting node msrkzyk2

启动vip、grid用户

[root@msrkzyk1 ~]# su - grid
Last login: Tue Sep  7 14:52:57 CST 2021 on pts/1
[grid@msrkzyk1 ~]$ srvctl start vip -n msrkzyk1
[grid@msrkzyk1 ~]$ srvctl start vip -n msrkzyk2
[grid@msrkzyk1 ~]$ srvctl status vip -n msrkzyk1
VIP msrkzyk1v is enabled
VIP msrkzyk1v is running on node: msrkzyk1
[grid@msrkzyk1 ~]$ srvctl status vip -n msrkzyk2
VIP msrkzyk2v is enabled
VIP msrkzyk2v is running on node: msrkzyk2

启动监听

[grid@msrkzyk1 ~]$ srvctl start listener
[grid@msrkzyk1 ~]$ srvctl status LISTENER 
Listener LISTENER is enabled
Listener LISTENER is running on node(s): msrkzyk2,msrkzyk1

启动数据库

[grid@msrkzyk1 ~]$ srvctl start database -d msrkzyk
[grid@msrkzyk1 ~]$ srvctl status database -d msrkzyk
Instance msrkzyk1 is running on node msrkzyk1
Instance msrkzyk2 is running on node msrkzyk2

4、检查local_listener信息，不正确就需要修改（我这儿对的不用修改）

[oracle@msrkzyk1 ~]$ sqlplus / as sysdba

SQL> show parameter local_listener

NAME           TYPE                 VALUE
--------      ---------     ----------------
local_listener  string   (ADDRESS=(PROTOCOL=TCP)(HOST=80.150.22.103)(PORT=1521))
#修改的命令
alter system set local_listenner='(ADDRESS=(PROTOCOL=TCP)(HOST=80.150.22.103)(PORT=1521))' sid='msrkzyk1';
alter system set local_listenner='(ADDRESS=(PROTOCOL=TCP)(HOST=80.150.22.104)(PORT=1521))' sid='msrkzyk2';

5、修改scan vip

查看scan vip的配置 grid用户

[root@msrkzyk1 ~]# su - grid
[grid@msrkzyk1 ~]$ srvctl config scan
SCAN name: msrkscan, Network: 1/80.150.22.0/255.255.255.0/eno1
SCAN VIP name: scan1, IP: /msrkscan/80.150.20.105

停止scan_listener和scan资源

[grid@msrkzyk1 ~]$ srvctl stop scan_listener
[grid@msrkzyk1 ~]$ srvctl stop scan

--确认已经停止

[grid@msrkzyk1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
[grid@msrkzyk1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running

使用root用户修改scan vip

[root@msrkzyk1 ~]# /u01/grid/11.2/bin/srvctl modify scan -n msrkscan

注意：root用户执行修改，且确认/etc/hosts映射关系已经修改为新的scan VIP。

修改并启动资源库 grid用户

[grid@msrkzyk1 ~]$ srvctl modify scan_listener -u
[grid@msrkzyk1 ~]$ srvctl start scan_listener

注意：执行后确认scan_listener和scan都已经启动

[grid@msrkzyk1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node msrkzyk1
[grid@msrkzyk1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node msrkzyk1

确认修改成功

[grid@msrkzyk1 ~]$ srvctl config scan
SCAN name: msrkscan, Network: 1/80.150.22.0/255.255.255.0/eno1
SCAN VIP name: scan1, IP: /msrkscan/80.150.22.105
[grid@msrkzyk1 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

6、验证整个集群

[grid@msrkzyk1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.DATA.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.FRA.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.PIC.dg
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.asm
               ONLINE  ONLINE       msrkzyk1                 Started             
               ONLINE  ONLINE       msrkzyk2                 Started             
ora.gsd
               OFFLINE OFFLINE      msrkzyk1                                     
               OFFLINE OFFLINE      msrkzyk2                                     
ora.net1.network
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
ora.ons
               ONLINE  ONLINE       msrkzyk1                                     
               ONLINE  ONLINE       msrkzyk2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       msrkzyk1                                     
ora.cvu
      1        OFFLINE OFFLINE                                                   
ora.msrkzyk.db
      1        ONLINE  ONLINE       msrkzyk1                 Open                
      2        ONLINE  ONLINE       msrkzyk2                 Open                
ora.msrkzyk1.vip
      1        ONLINE  ONLINE       msrkzyk1                                     
ora.msrkzyk2.vip
      1        ONLINE  ONLINE       msrkzyk2                                     
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.scan1.vip
      1        ONLINE  ONLINE       msrkzyk1