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

以你之姓@ 2022-06-17 05:07 136阅读 0赞

\#数据库服务器查看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)  
       )  
    )  
  )