Oracle RAC 负载均衡测试(结合服务器端与客户端)

1、服务器端各节点监听器正常提供服务，如果使用非缺省的1521端口，请参考 ORACLE RAC 下非缺省端口监听配置(listener.ora tnsnames.ora) 
  oracle@bo2dbp:~> more $ORACLE_HOME/network/admin/listener.ora
  # listener.ora.bo2dbp Network Configuration File: /u01/oracle/db/network/admin/listener.ora.bo2dbp
  # Generated by Oracle configuration tools.
  
  LISTENER_BO2DBP =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = bo2dbp-vip.2gotrade.com)(PORT = 1521)(IP = FIRST))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.51)(PORT = 1521)(IP = FIRST))
      )
    )
  
  SID_LIST_LISTENER_BO2DBP =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = PLSExtProc)
        (ORACLE_HOME = /u01/oracle/db)
        (PROGRAM = extproc)
      )
    )
  
  oracle@bo2dbp:~> lsnrctl status
  Service "GOBO4" has 2 instance(s).
    Instance "GOBO4A", status READY, has 2 handler(s) for this service...
    Instance "GOBO4B", status READY, has 1 handler(s) for this service...
    
2、服务器端的remote_listener参数设置
  要求remote_listener参数的连接标识符在服务器端的tnsnames.ora中有对应的条目
  
  SQL> show parameter listener
  
  NAME                                 TYPE        VALUE
  ------------------------------------ ----------- ------------------------------
  local_listener                       string
  remote_listener                      string      remote_lsnr_gobo4

  oracle@bo2dbp:~> more $ORACLE_HOME/network/admin/tnsnames.ora
  # tnsnames.ora Network Configuration File: /u01/oracle/db/network/admin/tnsnames.ora
  # Generated by Oracle configuration tools.
  remote_lsnr_gobo4 =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.61)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.62)(PORT = 1521))
    )

3、客户端tnsnames.ora中启用load_balance
  oracle@SZDB:~> tail -11 $ORACLE_HOME/network/admin/tnsnames.ora
  
  GOBO4 =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.61)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.62)(PORT = 1521))
      (LOAD_BALANCE = yes)
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = GOBO4)
      )
    )

#还是使用之前的脚步来进行测试
#Author : Robinson
#Blog : http://blog.csdn.net/robinson_0612
oracle@SZDB:~> more load_balance.sh 
#!/bin/bash
for i in {1..1000}
do
echo $i
sqlplus -S system/oracle@GOBO4 <<EOF
select instance_name from v\$instance;
EOF
sleep 1
done
exit 0

oracle@SZDB:~> ./load_balance.sh >load_bal.log   

#查看日志
oracle@SZDB:~> grep GOBO4A load_bal.log |wc -l
750
oracle@SZDB:~> grep GOBO4B load_bal.log |wc -l
250

#查看监听器的日志
oracle@bo2dbp:/u01/oracle/db/network/log> grep establish listener_bo2dbp.log |wc -l
894

oracle@bo2dbp:/u01/oracle/db/network/log> grep INSTANCE_NAME=GOBO4 listener_bo2dbp.log |wc -l
415

#从上面的查询中可以得知，节点bo2dbp总共接受了894个连接请求，而有415连接请求是由bo2dbs转发过来的
#因此，实际上从客户端发起到bo2dbp的实际连接请求数为894-415=479

#下面来看在节点bo2dbs上的监听日志
oracle@bo2dbs:/u01/oracle/db/network/log> grep establish listener_bo2dbs.log |wc -l
665

oracle@bo2dbs:/u01/oracle/db/network/log> grep INSTANCE_NAME=GOBO4 listener_bo2dbs.log |wc -l 
144
#从上面的查询中可知，节点bo2dbs总共接受了665个连接请求，而有144个连接请求是由bo2dbp转发过来的
#因此，实际上从客户端发起到bo2dbs的实际连接请求数为655-144=511

#从上面的结果可知，
#基于客户端的连接请求数为节点bo2dbp为479，节点bo2dbs为511
#监听器路由到本地实例数目为，节点bo2dbp，479-144=335，节点bo2dbs，511-415=96
#远程监听器路由道本地实例的数据为，节点bo2dpb为415，节点bo2dbs为144
#监听器路由的概念是指基于服务器端的负载均衡
#即服务器端的监听器根据自身以及远程监听器的负载情况来确定将当前的连接请求转发到本地或远程，此即为路由。