ITPub博客

首页 > 数据库 > Oracle > Oracle 11.2 RAC改IP步骤

Oracle 11.2 RAC改IP步骤

原创 Oracle 作者:shytodear 时间:2015-12-03 08:42:12 0 删除 编辑
Oracle 11.2 RAC改IP步骤


参考文档:
How to Modify Public Network Information including VIP in Oracle Clusterware (Doc ID 276434.1)
How to update the IP address of the SCAN VIP resources (ora.scan{n}.vip) (Doc ID 952903.1)


一、检查当前配置:
grid@liuqi2:/home/grid> srvctl config nodeapps
Network exists: 1/132.78.213.0/255.255.255.0/en6, type static
VIP exists: /liuqi1-vip/132.78.213.38/132.78.213.0/255.255.255.0/en6, hosting node liuqi1
VIP exists: /liuqi2-vip/132.78.213.40/132.78.213.0/255.255.255.0/en6, hosting node liuqi2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016


grid@liuqi2:/home/grid> srvctl config scan
SCAN name: liuqi-cluster-scan, Network: 1/132.78.213.0/255.255.255.0/en6
SCAN VIP name: scan1, IP: /liuqi-cluster-scan/132.78.213.41


grid@liuqi2:/home/grid> srvctl config network
Network exists: 1/132.78.213.0/255.255.255.0/en6, type static


grid@liuqi2:/home/grid> oifcfg getif
en6  132.78.213.0  global  public
en7  192.168.1.0  global  cluster_interconnect


grid@liuqi2:/home/grid> cat /etc/hosts
127.0.0.1               loopback localhost      # loopback (lo0) name/address
::1                     loopback localhost      # IPv6 loopback (lo0) name/address


132.78.213.37   liuqi1
132.78.213.38   liuqi1-vip
192.168.1.37    liuqi1-priv


132.78.213.39   liuqi2
132.78.213.40   liuqi2-vip
192.168.1.39    liuqi2-priv


132.78.213.41   liuqi-cluster-scan






-------Netbackup-----/
10.13.107.8     MSSM4KA
10.13.107.9     MSSM4KB
10.13.107.88    MSSM4KC
10.13.107.16    NBUMaster


#######NIM#######
132.77.135.4    DS_NIM




二、检查当前状态:
[grid@liuqi1: /home/grid]$crsctl stat res -t
[grid@liuqi1: /home/grid]$cs
确认VIP均ONLINE


grid@liuqi1:/home/grid> ifconfig -a
en5: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 192.168.128.12 netmask 0xffffff00 broadcast 192.168.128.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en6: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 132.78.213.37 netmask 0xffffff00 broadcast 132.78.213.255
        inet 132.78.213.38 netmask 0xffffff00 broadcast 132.78.213.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en7: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 192.168.1.37 netmask 0xffffff00 broadcast 192.168.1.255
        inet 169.254.38.160 netmask 0xffff0000 broadcast 169.254.255.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 1
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
        inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
        inet6 ::1%1/0
         tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1


grid@liuqi2:/home/grid> ifconfig -a
en4: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 192.1.2.39 netmask 0xffffff00 broadcast 192.1.2.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en5: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 192.168.128.22 netmask 0xffffff00 broadcast 192.168.128.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en6: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 132.78.213.39 netmask 0xffffff00 broadcast 132.78.213.255
        inet 132.78.213.41 netmask 0xffffff00 broadcast 132.78.213.255
        inet 132.78.213.40 netmask 0xffffff00 broadcast 132.78.213.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en7: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 192.168.1.39 netmask 0xffffff00 broadcast 192.168.1.255
        inet 169.254.10.107 netmask 0xffff0000 broadcast 169.254.255.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 1
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
        inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
        inet6 ::1%1/0
         tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1


三、准备:
停数据库全部实例(以oracle用户):
使用srvctl或sqlplus


停SCAN及其LISTENER(以grid用户):
$GRID_HOME/bin/srvctl stop scan_listener
$GRID_HOME/bin/srvctl stop scan


停VIP及其LISTENER(以grid用户):
$GRID_HOME/bin/srvctl stop vip -n liuqi1 -f
$GRID_HOME/bin/srvctl stop vip -n liuqi2 -f


确认数据库已停、SCANIP、VIP、所有LISTENER为offline状态


修改OCR中的网卡定义(以grid用户):
#grid用户,对于11gR2需要在所有节点CRS均RUNNING状态下进行,否则会报PRIF-33 and PRIF-32
$GRID_HOME/bin/oifcfg delif -global en6/132.78.213.0
$GRID_HOME/bin/oifcfg delif -global en6/132.77.134.0
$GRID_HOME/bin/oifcfg setif -global en6/132.77.134.128:public




四、操作系统层面修改(以root用户):
修改网卡上的IP地址为新地址
修改/etc/hosts,全部对应新地址:
127.0.0.1               loopback localhost      # loopback (lo0) name/address
::1                     loopback localhost      # IPv6 loopback (lo0) name/address


132.77.134.135   liuqi1
132.77.134.136   liuqi1-vip
192.168.1.37    liuqi1-priv


132.77.134.137   liuqi2
132.77.134.138   liuqi2-vip
192.168.1.39    liuqi2-priv


132.77.134.145   liuqi-cluster-scan




-------Netbackup-----/
10.13.107.8     MSSM4KA
10.13.107.9     MSSM4KB
10.13.107.88    MSSM4KC
10.13.107.16    NBUMaster


#######NIM#######
132.77.135.4    DS_NIM




五、修改VIP及SCAN IP (以root用户):
#srvctl modify nodeapps -n <node> -A <new_vip_address or new_vip_hostname>/<netmask>/<[if1[if2...]]>
srvctl modify nodeapps -n liuqi1 -A liuqi1-vip/255.255.255.128/en6
srvctl modify nodeapps -n liuqi2 -A liuqi2-vip/255.255.255.128/en6
srvctl modify scan -n liuqi-cluster-scan


六、启动VIP、SCAN等 (以grid用户):
$GRID_HOME/bin/srvctl start vip -n liuqi1
$GRID_HOME/bin/srvctl start listener -n liuqi1
$GRID_HOME/bin/srvctl start vip -n liuqi2
$GRID_HOME/bin/srvctl start listener -n liuqi2
$GRID_HOME/bin/srvctl start scan
$GRID_HOME/bin/srvctl start scan_listener


检查确认修改
srvctl config nodeapps -a
lsnrctl stat listener_scan1


七、启动 (以oracle用户):
启动数据库
检查local_listener及remote_listener设置,必要的话修改
连接测试

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

请登录后发表评论 登录
全部评论

注册时间:2013-11-05

  • 博文量
    66
  • 访问量
    238109