Oracle的load_balance和failover
来源:互联网 发布:mac网络代理设置 编辑:程序博客网 时间:2024/06/05 04:50
jdbc:oracle:thin:@
(description=(TRANSPORT_CONNECT_TIMEOUT=1)
(address_list=(load_balance=off)(failover=on)
(address=(protocol=tcp)(host=RAC1-vip)(port=1521))
(address=(protocol=tcp)(host=RAC2-vip)(port=1521))
(address=(protocol=tcp)(host=RAC3-vip)(port=1521)))
(connect_data=(service_name=orcl)(failover_mode=(type=select)(method=basic)))
)
LOAD_BALANCE
Purpose
To enable or disable client load balancing for multiple protocol addresses.
When you set the parameter to on, yes, or true, Oracle Net progresses the list of addresses in a random sequence, balancing the load on the various listener or Oracle Connection Manager protocol addresses. When you set the parameter to off, no, or false, Oracle Net tries the first address in the address list. If the connection fails and the failover parameter is enabled, then Oracle Net tries the addresses sequentially until one succeeds.
Put this parameter under either the DESCRIPTION_LIST parameter, the DESCRIPTION parameter, or the ADDRESS_LIST parameter.
Default
on for DESCRIPTION_LIST
Values
yes | on | true
no | off | false
Example
net_service_name=
(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=sales.us.example.com))
FAILOVER
Purpose
To enable or disable connect-time failover for multiple protocol addresses.
When you set the parameter to on, yes, or true, Oracle Net, at connect time, fails over to a different address if the first protocol address fails. When you set the parameter to off, no, or false, Oracle Net tries one protocol address.
Put this parameter under the DESCRIPTION_LIST parameter, the DESCRIPTION parameter, or the ADDRESS_LIST parameter.
Default
on for DESCRIPTION_LIST, DESCRIPTION, and ADDRESS_LIST.
Values
yes | on | true
no | off | false
Example
net_service_name=
(DESCRIPTION=
(FAILOVER=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=sales.us.example.com)))
(description=(TRANSPORT_CONNECT_TIMEOUT=1)
(address_list=(load_balance=off)(failover=on)
(address=(protocol=tcp)(host=RAC1-vip)(port=1521))
(address=(protocol=tcp)(host=RAC2-vip)(port=1521))
(address=(protocol=tcp)(host=RAC3-vip)(port=1521)))
(connect_data=(service_name=orcl)(failover_mode=(type=select)(method=basic)))
)
LOAD_BALANCE=OFF,客户端进程首先会尝试连接 RAC1-vip,如果连不上,则会尝试RAC2-vip,如果再连不上就尝试RAC3-vip。如果设置为ON则会随机的选择一个做均衡负载。LOAD_BALANCE =on负载均衡,FAILOVER = on 失败自动切换,这两个参数是搭配在一起的。
LOAD_BALANCE
Purpose
To enable or disable client load balancing for multiple protocol addresses.
When you set the parameter to on, yes, or true, Oracle Net progresses the list of addresses in a random sequence, balancing the load on the various listener or Oracle Connection Manager protocol addresses. When you set the parameter to off, no, or false, Oracle Net tries the first address in the address list. If the connection fails and the failover parameter is enabled, then Oracle Net tries the addresses sequentially until one succeeds.
Put this parameter under either the DESCRIPTION_LIST parameter, the DESCRIPTION parameter, or the ADDRESS_LIST parameter.
Default
on for DESCRIPTION_LIST
Values
yes | on | true
no | off | false
Example
net_service_name=
(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=sales.us.example.com))
FAILOVER
Purpose
To enable or disable connect-time failover for multiple protocol addresses.
When you set the parameter to on, yes, or true, Oracle Net, at connect time, fails over to a different address if the first protocol address fails. When you set the parameter to off, no, or false, Oracle Net tries one protocol address.
Put this parameter under the DESCRIPTION_LIST parameter, the DESCRIPTION parameter, or the ADDRESS_LIST parameter.
Default
on for DESCRIPTION_LIST, DESCRIPTION, and ADDRESS_LIST.
Values
yes | on | true
no | off | false
Example
net_service_name=
(DESCRIPTION=
(FAILOVER=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=sales.us.example.com)))
0 0
- Oracle的load_balance和failover
- oracle 10G LOAD_BALANCE、FAILOVER、TAF简介
- LOAD_BALANCE FAILOVER SOURCE_ROUTE 组合分类
- Dataguard的switchover和failover
- 有关Oracle Data Guard Failover 的说明
- 有关Oracle Data Guard Failover 的说明
- 有关Oracle Data Guard Failover 的说明
- 2.6.28内核的进程load_balance
- 77、Dataguard的switchover和failover
- Oracle DG测试failover和后续恢复报告
- Oracle RAC Failover 详解
- Oracle RAC Failover 详解
- Oracle RAC Failover 详解
- Oracle RAC Failover 详解
- Oracle RAC Failover 详解
- Oracle RAC Failover 详解
- oracle rac failover
- Oracle RAC Failover 详解
- ARMv8-A系列学习笔记(5)--Chapter 15 Power Management
- sttdio快捷键
- 玩转Excel系列-SUMIF函数实例教程
- android zip压缩base64解密加密,做记录用
- 多态
- Oracle的load_balance和failover
- 自适应学习速率SGD优化算法
- 使用kettle进行增量抽取数据
- 用 jQuery.ajaxSetup 实现对请求和响应数据的过滤
- 游戏行业理解
- SQL Cursor(游标) 基本用法
- Shell基础教程,什么是Shell?Shell脚本的执行方式,Shell中的变量,Shell中的特殊变量
- 代码直连指定ip的dubbo服务
- [转]pycharm的一些快捷键