下文给大家带来Oracle 12c应用如何实现连接VIP轮训负载均衡的，希望能够给大家在实际运用中带来一定的帮助，负载均衡涉及的东西比较多，理论也不多，网上有很多书籍，今天我们就用亿速云在行业内累计的经验来做一个解答。
目前很多生产数据库都是两节点RAC，应用连接的数据库通常会连接SCAN IP或者VIP,这里做一个小实验，如果我们使用VIP连接，
应该怎样配置我们的客户端，负载均衡是否是严格意义上的轮训机制，只有通过自己的测试才能得到准备的答案。
tnsnames.ora配置
<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$less tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
vip =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.203)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.204)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
2.测试脚本如下
<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$
<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$less load_balance.sh
#!/bin/bash
for i in {1..100}
do
echo $i
sqlplus -S system/oracle@vip <<EOF
select instance_name from v\$instance;
select count(*) from t1;
EOF
sleep 1
done
exit 0
3.开始测试，观察
<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$sh load_balance.sh
1
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
2
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
3
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
4
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
5
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
6
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
7
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
8
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
9
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
10
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
11
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
12
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
13
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
14
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
15
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
16
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
17
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
18
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
19
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
20
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
21
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
22
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
23
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
24
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
25
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
26
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
27
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
28
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
29
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
30
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
31
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
32
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
33
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
34
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
35
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
36
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
37
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
38
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
39
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
40
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
41
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
42
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
43
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
44
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
45
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
46
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
47
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
48
INSTANCE_NAME
----------------
orcl2
COUNT(*)
----------
2910624
49
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
50
INSTANCE_N
....省略...............
COUNT(*)
----------
2910624
100
INSTANCE_NAME
----------------
orcl1
COUNT(*)
----------
2910624
看了以上关于Oracle 12c应用如何实现连接VIP轮训负载均衡的，如果大家还有什么地方需要了解的可以在亿速云行业资讯里查找自己感兴趣的或者找我们的专业技术工程师解答的，亿速云技术工程师在行业内拥有十几年的经验了。
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
