很多时候,由于网络环境的变化需要修改子网掩码,本文将介绍在Oracle10G RAC环境下修改子网掩码。
修改前后子网掩码列表:主机名
修改前子网掩码
修改后子网掩码
Node1
255.255.255.0
255.255.254.0
Node2
一、关闭相关服务
1.1关闭数据库
在2个节点做同样操作,把2个实例都关闭
[oracle@node2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 22 23:03:19 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
sSQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
1.2停止节点应用
[oracle@node2 ~]$ srvctl stop nodeapps -n NODE1
[oracle@node2 ~]$ srvctl stop nodeapps -n NODE2
1.3查看crs状态
必须确保该节点的所有资源都已停止
[oracle@node2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....e1.inst application OFFLINE OFFLINE
ora....e2.inst application OFFLINE OFFLINE
ora.dave.db application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application OFFLINE OFFLINE
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application OFFLINE OFFLINE
ora.node1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....E2.lsnr application OFFLINE OFFLINE
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application OFFLINE OFFLINE
ora.node2.vip application OFFLINE OFFLINE
二、修改子网掩码
2.1修改配置文件ifcfg-eth0
2个节点都需要修改
原ifcfg-eth0信息如下:
[root@node2 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
# Intel Corporation 82540EM Gigabit Ethernet Controller
HWADDR=08:00:27:bc:36:49
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.15.255
IPADDR=192.168.15.20
NETMASK=255.255.255.0
NETWORK=192.168.15.0
ONBOOT=yes
修改为:
[root@node2 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
# Intel Corporation 82540EM Gigabit Ethernet Controller
HWADDR=08:00:27:bc:36:49
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.15.255
IPADDR=192.168.15.20
NETMASK=255.255.254.0
NETWORK=192.168.15.0
ONBOOT=yes
修改完成之后重启网卡
[root@node1 ~]# service network restart
Shutting down interface eth0: [ OK ]
Shutting down interface eth1: [ OK ]
Shutting down loopback interface: [ OK ]
Disabling IPv4 packet forwarding: net.ipv4.ip_forward = 0
[ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
Bringing up interface eth1: [ OK ]
查看网络信息,子网掩码为修改后的255.255.254.0
[root@node1 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 08:00:27:DF:34:C4
inet addr:192.168.15.10 Bcast:192.168.15.255 Mask:255.255.254.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:197 errors:0 dropped:0 overruns:0 frame:0
TX packets:82 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:21983 (21.4 KiB) TX bytes:10650 (10.4 KiB)
eth1 Link encap:Ethernet HWaddr 08:00:27:C2:B7:07
inet addr:10.10.10.1 Bcast:10.10.10.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:167565 errors:0 dropped:0 overruns:0 frame:0
TX packets:184108 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:110808826 (105.6 MiB) TX bytes:129047139 (123.0 MiB)
2.2更改VIP配置
只需要在一个节点执行,且必须以root用户
[root@node1 ~]# cd /u01/ora10g/10.2.0/db_1/bin/
[root@node1bin]# ./srvctl modify nodeapps -n node1 -A 192.168.15.11/255.255.254.0/eth0 -o /u01/ora10g/10.2.0/db_2
[root@node1bin]#./srvctl modify nodeapps -n node2 -A 192.168.15.22/255.255.254.0/eth0 -o /u01/ora10g/10.2.0/db_2
2.3重启CRS
重启crs:
[root@node1 bin]# ./crs_start –all
检查状态:
所有资源状态为Online,一切正常。
[root@node1 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....e1.inst application ONLINE ONLINE node1
ora....e2.inst application ONLINE ONLINE node2
ora.dave.db application ONLINE ONLINE node2
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
至此,子网掩码修改完成。