1、客户端的tnsnames.ora配置
*确保客户端机器的hosts文件加入ip映射关系。
test=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
(FAILOVER_MODE =
(TYPE = session)
(METHOD = basic)
(RETRIES = 180)
(DELAY = 5)
)
)
)
2、负载均衡测试脚本
脚本：
#!/bin/sh
i=0
while [ $i -lt 1000 ];
do
echo "$i****************************************">>testinstance.log
sqlplus -s /nolog >> testinstance.log<< EOF
connect system/oracle@test
show parameter instance_name
EOF
echo "****************************************">>testinstance.log
echo>>testinstance.log
i=`expr $i + 1`
查看负载结果 cat testinstance.log |grep db2|wc -l db2为instance名称。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23655288/viewspace-711945/ ，如需转载，请注明出处，否则将追究法律责任。
