关闭相关集群服务
[grid@s1-11g ~]$ srvctl stop scan
[grid@s1-11g ~]$ srvctl stop scan_listener
[grid@s1-11g ~]$ srvctl stop vip -i s1-11g-vip
[grid@s1-11g ~]$ srvctl stop vip -i s2-11g-vip
[grid@s1-11g ~]$ srvctl stop listener
在两节点/etc/hosts下修改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.70 scan
192.168.200.73 s1-11g-vip
192.168.200.74 s2-11g-vip
[grid@s1-11g ~]$ which srvctl
/oracle/grid/crs_1/bin/srvctl
[grid@s1-11g ~]$ exit
logout
[root@s1-11g ~]# /oracle/grid/crs_1/bin/srvctl modify scan -n scan
[root@s1-11g ~]# /oracle/grid/crs_1/bin/srvctl modify nodeapps -n s1-11g -A 192.168.200.73/255.255.255.0/eth0
[root@s1-11g ~]# /oracle/grid/crs_1/bin/srvctl modify nodeapps -n s2-11g -A 192.168.200.74/255.255.255.0/eth0
[grid@s1-11g ~]$ srvctl start scan
[grid@s1-11g ~]$ srvctl start vip -i s1-11g
[grid@s1-11g ~]$ srvctl start vip -i s2-11g
[grid@s1-11g ~]$ srvctl start listener
[grid@s1-11g ~]$ srvctl start scan_listener
手动设置local_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';
手动设置remote_listener参数
alter system set remote_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.70)(PORT=1521)))' scope=both sid='*';
在两节点上测试用scan IP来进行数据库连接
sqlplus system/oracle@192.168.200.70:1521/hzmc
在两节点上测试用VIP来进行数据库连接
sqlplus system/oracle@192.168.200.73:1521/hzmc
sqlplus system/oracle@192.168.200.74:1521/hzmc