修改 RAC scanip

下面开始操作。  
注：停掉scan_listener和sacn vip后需要修改hosts
1、查看scan ip状态 
[oracle@dbp ~]$ srvctl config scan 
SCAN name: rac-scan, Network: 1/10.30.152.0/255.255.254.0/eth0 SCAN VIP name: scan1, IP: /rac-scan/10.30.152.85  
2、停止scan_listener 和sacn vip 
[oracle@dbp ~]$ srvctl stop scan_listener [oracle@dbp ~]$ srvctl stop scan [oracle@dbp ~]$ srvctl status scan SCAN VIP scan1 is enabled SCAN VIP scan1 is not running 
[oracle@dbp ~]$ srvctl status scan_listener SCAN Listener LISTENER_SCAN1 is enabled SCAN listener LISTENER_SCAN1 is not running  
3、登录root用户，修改scan vip 
[oracle@dbp ~]$ srvctl modify scan -n 10.30.153.2xx 
PRCS-1034 : Failed to modify Single Client Access Name 10.30.153.2xx PRCR-1071 : Failed to register or update resource ora.scan1.vip 
CRS-0245:  User doesn't have enough privilege to perform the operation  
[oracle@dbp ~]$ su - Password:  
[root@dbp ~]# /u01/app/grid/product/11.2.0/grid/bin/srvctl modify scan -n 10.30.153.2xx  
4、查看是否修改成功 
[root@dbp ~]# /u01/app/grid/product/11.2.0/grid/bin/srvctl config scan SCAN name: 10.30.153.2xx, Network: 1/10.30.152.0/255.255.254.0/eth0 SCAN VIP name: scan1, IP: /10.30.153.2xx/10.30.153.2xx  
5、启动scan 
[root@dbp ~]# /u01/app/grid/product/11.2.0/grid/bin/srvctl start scan 
[root@dbp ~]# /u01/app/grid/product/11.2.0/grid/bin/srvctl start scan_listener [root@dbp ~]# /u01/app/grid/product/11.2.0/grid/bin/srvctl status scan SCAN VIP scan1 is enabled 
SCAN VIP scan1 is running on node dbp  
6、试下效果 
SQL> conn sys/sys@10.30.153.2xx/test as sysdba 已连接。 
SQL> show parameter instance  






  




NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ active_instance_count                integer 
cluster_database_instances           integer     2 instance_groups                      string 
instance_name                        string      test1 instance_number                      integer     1 instance_type                        string      RDBMS open_links_per_instance              integer     4 parallel_instance_group              string 
parallel_server_instances            integer     2 
SQL> conn sys/sys@10.30.153.2xx/test as sysdba 已连接。 
SQL> show parameter instance  
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ active_instance_count                integer 
cluster_database_instances           integer     2 instance_groups                      string 
instance_name                        string      test2 instance_number                      integer     2 instance_type                        string      RDBMS open_links_per_instance              integer     4 parallel_instance_group              string 
parallel_server_instances            integer     2 SQL> exit  
这样集群的效果就实现了。对虚拟出来的rac-scan ip的访问，集群按每个节点的性能压力情况，自动分配到相应的节点上去。