实验中数据库版本是10.2.0.5,此实验使用于10grac 和11gr1rac(其中10.2.0.3版本修改vip要停instance和asm资源)
修改10grac public ip 为不同网段,此例从56 网段变为215网段。
同网段修改及11gR2rac同网段修改请参考11gR2rac修改同网段
11gr2rac的public ip vip 修改不同网段请参考11gR2rac修改不同网段
查看一下目前资源
Name Type Target State Host
------------------------------------------------------------ora.orcl.db application ONLINE ONLINE rac1
ora....oltp.cs application ONLINE ONLINE rac2
ora....cl1.srv application ONLINE ONLINE rac1
ora....cl2.srv application ONLINE ONLINE rac2
ora....l1.inst application ONLINE ONLINE rac1
ora....l2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
查看hosts文件
[oracle@rac1 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 rac1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
#pub
192.168.56.167 rac2
192.168.56.166 rac1
#priv
10.0.0.2 rac1-priv
10.0.0.3 rac2-priv
#vip
192.168.56.168 rac1-vip
192.168.56.169 rac2-vip
[oracle@rac1 ~]$ cat /etc/issue
Red Hat Enterprise Linux Server release 5.8 (Tikanga)
Kernel \r on an \m
(1)修改public
查看目前rac网络
[root@rac1 bin]# ./oifcfg getif
eth0 192.168.56.0 global public
eth1 10.0.0.0 global cluster_interconnect
删掉56网段,添加215网段
[root@rac1 bin]# ./oifcfg delif -global eth0/192.168.56.0
[root@rac1 bin]# ./oifcfg setif -global eth0/192.168.215.0:public
查看添加成功与否
[root@rac2 bin]# ./oifcfg getif
eth0 192.168.215.0 global public
eth1 10.0.0.0 global cluster_interconnect
vi /etc/hosts (两节点都要改)
192.168.215.167 rac2
192.168.215.166 rac1
#priv
10.0.0.2 rac1-priv
10.0.0.3 rac2-priv
#vip
192.168.56.168 rac1-vip
192.168.56.169 rac2-vip
service network restart; (两节点都要执行)
(2)修改vip
[root@rac1 bin]# ./srvctl config nodeapps -n rac1 -a
VIP exists.: /rac1-vip/192.168.56.168/255.255.255.0/eth0
[root@rac1 bin]# ./srvctl config nodeapps -n rac2 -a
VIP exists.: /rac2-vip/192.168.56.169/255.255.255.0/eth0
[root@rac1 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE rac1
ora....oltp.cs application ONLINE ONLINE rac1
ora....cl1.srv application ONLINE ONLINE rac1
ora....cl2.srv application ONLINE OFFLINE
ora....l1.inst application ONLINE ONLINE rac1
ora....l2.inst application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE OFFLINE
ora....C2.lsnr application ONLINE OFFLINE
ora.rac2.gsd application ONLINE OFFLINE
ora.rac2.ons application ONLINE OFFLINE
ora.rac2.vip application ONLINE ONLINE rac1
资源中asm已经停掉 若为10.2.0.3+版本需要
$ srvctl stop instance -d <db_name> -i <inst_name> (optional for 10.2.0.3+)
$ srvctl stop asm -n <node_name> (optional for 10.2.0.3+)
其他版本如我是10.2.0.5
[root@rac1 bin]# ./srvctl stop nodeapps -n rac1
[root@rac1 bin]# ./srvctl modify nodeapps -n rac1 -A 192.168.215.168/255.255.255.0/eth0
若为10.2.0.3+版本启动时也要
$ srvctl start asm -n <node_name> (optional for 10.2.0.3+)
$ srvctl start instance -d <dbanme> -i <inst> (optional for 10.2.0.3+)
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-JUN-2016 08:16:44
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:Copyright (c) 1991, 2005, Oracle. All rights reserved.
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:TNSLSNR for Linux: Version 10.2.0.1.0 - Production
rac1:ora.rac1.LISTENER_RAC1.lsnr:System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
rac1:ora.rac1.LISTENER_RAC1.lsnr:Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener_rac1.log
rac1:ora.rac1.LISTENER_RAC1.lsnr:Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)(IP=FIRST)))
rac1:ora.rac1.LISTENER_RAC1.lsnr:TNS-12545: Connect failed because target host or object does not exist
rac1:ora.rac1.LISTENER_RAC1.lsnr: TNS-12560: TNS:protocol adapter error
rac1:ora.rac1.LISTENER_RAC1.lsnr: TNS-00515: Connect failed because target host or object does not exist
rac1:ora.rac1.LISTENER_RAC1.lsnr: Linux Error: 99: Cannot assign requested address
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:Listener failed to start. See the error message(s) above...
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-JUN-2016 08:16:47
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:Copyright (c) 1991, 2005, Oracle. All rights reserved.
rac1:ora.rac1.LISTENER_RAC1.lsnr:
rac1:ora.rac1.LISTENER_RAC1.lsnr:Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)(IP=FIRST)))
rac1:ora.rac1.LISTENER_RAC1.lsnr:TNS-12560: TNS:protocol adapter error
rac1:ora.rac1.LISTENER_RAC1.lsnr: TNS-00530: Protocol adapter error
rac1:ora.rac1.LISTENER_RAC1.lsnr: Linux Error: 113: No route to host
rac1:ora.rac1.LISTENER_RAC1.lsnr:Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)(IP=FIRST)))
rac1:ora.rac1.LISTENER_RAC1.lsnr:TNS-12541: TNS:no listener
rac1:ora.rac1.LISTENER_RAC1.lsnr: TNS-12560: TNS:protocol adapter error
rac1:ora.rac1.LISTENER_RAC1.lsnr: TNS-00511: No listener
rac1:ora.rac1.LISTENER_RAC1.lsnr: Linux Error: 111: Connection refused
CRS-0215: Could not start resource 'ora.rac1.LISTENER_RAC1.lsnr'
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE rac1
ora....oltp.cs application ONLINE ONLINE rac1
ora....cl1.srv application ONLINE OFFLINE
ora....cl2.srv application ONLINE ONLINE rac2
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application ONLINE ONLINE rac2
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application ONLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
rac1 的listener offline 但vip online了
[root@rac1 bin]# ./srvctl config nodeapps -n rac1 -a
VIP exists.: /192.168.215.168/192.168.215.168/255.255.255.0/eth0
操作第二节点
[root@rac2 bin]# ./srvctl config nodeapps -n rac2 -a
VIP exists.: /rac2-vip/192.168.56.169/255.255.255.0/eth0
[root@rac2 bin]# ./srvctl stop nodeapps -n rac2
[root@rac2 bin]# ./srvctl modify nodeapps -n rac2 -A 192.168.215.169/255.255.255.0/eth0
[root@rac2 bin]# ./srvctl start nodeapps -n rac2
节点二没有报错
vi /etc/hosts
依次启动以下资源
[root@rac2 bin]# ./srvctl start asm -n rac2
[root@rac2 bin]# ./srvctl start asm -n rac1
[root@rac2 bin]# ./srvctl start instance -d orcl -i orcl1
[root@rac2 bin]# ./srvctl start instance -d orcl -i orcl2
[root@rac2 bin]# ./srvctl start service -d orcl
[oracle@rac2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE rac1
ora....oltp.cs application ONLINE ONLINE rac1
ora....cl1.srv application ONLINE ONLINE rac1
ora....cl2.srv application ONLINE ONLINE rac2
ora....l1.inst application ONLINE ONLINE rac1
ora....l2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2