rac用戶端負載均衡測試

rac預設全局服務名用戶端負載均衡測試

more tnsnames.ora 

ractest =
  (DESCRIPTION =
    (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
     (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)
    )
  )
lsnrctl status
Service "+ASM" has  instance(s).
  Instance "+ASM1", status READY, has  handler(s) for this service...
Service "rac" has  instance(s).
  Instance "rac1", status READY, has  handler(s) for this service...
Service "racXDB" has  instance(s).
  Instance "rac1", status READY, has  handler(s) for this service...
Service "service1_manual" has  instance(s).
  Instance "rac1", status READY, has  handler(s) for this service...
Service "service6_cmdline" has  instance(s).
  Instance "rac1", status READY, has  handler(s) for this service...
The command completed successfully
在另外一個節點上
Service "+ASM" has  instance(s).
  Instance "+ASM2", status READY, has  handler(s) for this service...
Service "rac" has  instance(s).
  Instance "rac2", status READY, has  handler(s) for this service...
Service "racXDB" has  instance(s).
  Instance "rac2", status READY, has  handler(s) for this service...
Service "service_cmdline" has  instance(s).
  Instance "rac2", status READY, has  handler(s) for this service...
The command completed successfully
預設tnsnames.ora中的下面個值都是開啟的。
（load_balance=on)
    (failover=on)
用戶端連接配接測試；
sqlplus sys/xxx@ractest as sysdba
經過了多次的測試，發現總是連接配接的rac1,沒有随機到rac2上。