rac通过tnsnames.ora实现负载均衡 scan-vip访问

#数据库服务器查看scan-vip分配
srvctl config scan
#将以上scan-vip的ip地址在dns服务器配置域名解析， rac最多只能有3个scan-vip


#rac更改监控端口号
srvctl modify scan_listener -p 28720
#查看监听端口号
srvctl config scan_listener


alter system set remote_listener='rclus-scan.rdato.jc.com:28720' scope=both;--不指定sid，所有节点生效




#rac安装虽然设置端口号，但是只是针对scan_vip的监听端口，public ip监听的端口还是有默认的1521，修改listener端口号
srvctl modify listener -p 28719
#查看listener配置
srvctl config listener


#注意如果更改了端口号，使用local_listener进行动态注册


#在数据库服务上oracle用户sqlplus登陆并动态注册监听, 注意set local_listener要指定sid参数
alter system set local_listener = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.80.33)(PORT=28719))))' scope=both sid='rdato1';
alter system register;
alter system set local_listener = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.80.63)(PORT=28719))))' scope=both sid='rdato2';
alter system register;


#客户端配置tnsnames.ora
#SERVER = DEDICATED 专有连接模式   
#LOAD_BALANCE = yes 采用负载均衡模式
rdato=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rclus-scan.rdato.jc.com)(PORT = 28720))
    (LOAD_BALANCE = yes)
    (FAILOVER = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rdato)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 10)
        (DELAY = 1)
       )
    )
  )