VIP modification of RAC architecture based on different network segments

CRSCTL check CRS crs_stat-t

SRVCTL stop database-d raw SRVCTL stop asm -n s1-11g SRVCTL stop nodeapps-n s1-11g srvctl stop nodeapps -n s2-11g

— View the current configuration: [GRIDS1-11G Oracle]# oifcfg getif -global eth0 192.168.72.0 global public eth1 10.0.0.0 global cluster_interconnect

[grids1-11g oracle]# oifcfg delif-global eth0 [grids1-11g oracle]# oifcfg delif-global eth1 [grids1-11g oracle]# oifcfg delif-global eth1 [grids1-11g oracle]# oifcfg delif-global eth1 [grids1-11g oracle oracle]# oifcfg getif

– to add [grids1 – oracle 11 g] # oifcfg setif – global eth0/192.168.200.0: public [grids1 – oracle 11 g] # oifcfg setif – global Eth1/11.11.11.0 :cluster_interconnect [grids1-11g Oracle]# oifcfg getif eth0 192.168.200.0 global public eth1 11.0.0.0 global cluster_interconnect

[grids1-11g oracle]# oifcfg iflist

eth0 192.168.200.0

eth1 11.0.0.0

SRVCTL start database-d raw SRVCTL start asm -n s1-11g SRVCTL start asm -n s2-11g SRVCTL start nodeapps-n s1-11g srvctl start nodeapps -n s2-11g

[grids1-11g ~]$SRVCTL stop scan [grids1-11g ~]$SRVCTL stop scan_listener [grids1-11g ~]$SRVCTL stop vip-i s1-11g-vip [grids1-11g ~]$ srvctl stop vip -i s2-11g-vip [grids1-11g ~]$ srvctl stop listener

Scan IP vi /etc/hosts 192.168.200.90 Scan 192.168.200.93 S1-11G-VIP 192.168.200.94 S2-11G-VIP 192.168.200.94 192.168.200.70 Scan 192.168.200.73 S1-11G-VIP 192.168.200.74 S2-11G-VIP

[grids1-11g ~]$ which srvctl /oracle/grid/crs_1/bin/srvctl [grids1-11g ~]$ exit logout [roots1-11g ~]# /oracle/griwww.pizei.comd/crs_1/bin/srvctl modify scan -n scan [roots1-11g ~]# /oracle/grid/crs_1/bin/srvctl modify Nodeapps – n – 11 g – A 192.168.200.73 / s1 255.255.255.0 / eth0 [roots1-11 g ~] # / oracle/grid/crs_1 / bin/SRVCTL modify nodeapps – n S2-11 g – A 192.168.200.74/255.255.255.0 / eth0

[grids1-11g ~]$ srvctl start scan

[grids1-11g ~]$ srvctl start vip -i s1-11g

[grids1-11g ~]$ srvctl start vip -i s2-11g

[grids1-11g ~]$ srvctl start listener

[grids1-11g ~]$ srvctl start scan_listener

ALTER SYSTEM SET LOCAL_LISTENER ='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.73)(PORT=1521))’ scope=both sid=’hzmc1′; ALTER SYSTEM SET LOCAL_LISTENER ='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.74)(PORT=1521))’ SCOPE = BOTH SID =’ HZMC2 ‘;

ALTER SYSTEM SET REMOTE_LISTENER ALTER SYSTEM SET Remote_listener = ‘(ADDRESS_LIST = (ADDRESS = (TCP) PROTOCOL = (HOST = 192.168.200.70) (1521) PORT =))’ scope = both sid = ‘*’;

– test on two nodes with scan IP database connection up sqlplus system/oracle192.168.200.70:1521 / HZMC

– test on two nodes with VIP database connection up sqlplus system/oracle192.168.200.73:1521 / HZMC up sqlplus system/oracle192.168.200.74:1521 / HZMC