RAC的load balance和failover的配置过程

最新推荐文章于 2021-04-13 04:13:55 发布
最新推荐文章于 2021-04-13 04:13:55 发布
阅读量218 收藏
点赞数
文章标签： 数据库 网络 java

在一个RAC中存在两个节点：power1和power2，service_name是P5，SID分别为P51,P52

1、参数设置

power1:

SQL> show parameter db_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_name string P5

SQL> show parameter db_domain

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_domain string

SQL> show parameter service_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string P5

SQL> show parameter instance_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

instance_name string P51

SQL> show parameter listener

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

local_listener string LISTENER_P51

mts_listener_address string

mts_multiple_listeners boolean FALSE

remote_listener string LISTENERS_P5

power2:

SQL> show parameter db_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_name string P5

SQL> show parameter db_domain

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_domain string

SQL> show parameter service_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string P5

SQL> show parameter instance_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

instance_name string P52

SQL> show parameter listener

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

local_listener string LISTENER_P52

mts_listener_address string

mts_multiple_listeners boolean FALSE

remote_listener string LISTENERS_P5

2、配置服务端的listener.ora

power1:

$ vi /opt/oracle/product/9.2/network/admin/listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /opt/oracle/product/9.2)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /opt/oracle/product/9.2)

(SID_NAME = P51)

)

)

power2:

$ vi /opt/oracle/product/9.2/network/admin/listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /opt/oracle/product/9.2)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /opt/oracle/product/9.2)

(SID_NAME = P52)

)

)

配置好后，重启监听，然后执行lsnrctl service检查：

power1:

$ lsnrctl service

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on 27-APR-2005 17:33:42

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

Services Summary...

Service "P5" has 2 instance(s).

Instance "P51", status READY, has 2 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=power1)(PORT=1521)))

"DEDICATED" established:146 refused:0 state:ready

LOCAL SERVER

Instance "P52", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:129 refused:0 state:ready

REMOTE SERVER

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=power2)(PORT=1521)))

Service "P51" has 1 instance(s).

Instance "P51", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

The command completed successfully

Power2:

$ lsnrctl service

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on 27-APR-2005 17:36:51

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

Services Summary...

Service "P5" has 2 instance(s).

Instance "P51", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=power1)(PORT=1521)))

Instance "P52", status READY, has 2 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=power2)(PORT=1521)))

"DEDICATED" established:117 refused:0 state:ready

LOCAL SERVER

Service "P52" has 1 instance(s).

Instance "P52", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

The command completed successfully

3、配置服务端的tnsnames.ora

power1:

$ vi /opt/oracle/product/9.2/network/admin/tnsnames.ora

LISTENERS_P5 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

)

)

LISTENER_P51 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

)

)

P51 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

(CONNECT_DATA =

(SERVICE_NAME = P5)

(INSTANCE_NAME = P51)

)

)

P52 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

(CONNECT_DATA =

(SERVICE_NAME = P5)

(INSTANCE_NAME = P52)

)

)

P5 =

(DESCRIPTION =

(LOAD_BALANCE = yes)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = P5)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

power2:

$ vi /opt/oracle/product/9.2/network/admin/tnsnames.ora

LISTENERS_P5 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

)

)

LISTENER_P52 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

)

)

P51 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

(CONNECT_DATA =

(SERVICE_NAME = P5)

(INSTANCE_NAME = P51)

)

)

P52 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

(CONNECT_DATA =

(SERVICE_NAME = P5)

(INSTANCE_NAME = P52)

)

)

P5 =

(DESCRIPTION =

(LOAD_BALANCE = yes)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = P5)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

测试

$ tnsping P51

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on 27-APR-2005 17:43:37

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

/opt/oracle/product/9.2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = P5) (INSTANCE_NAME = P51)))

OK (10 msec)

$ tnsping P52

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on 27-APR-2005 17:43:54

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

/opt/oracle/product/9.2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = P5) (INSTANCE_NAME = P52)))

OK (0 msec)

$ tnsping P5

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on 27-APR-2005 17:44:13

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

/opt/oracle/product/9.2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = power1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = power2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = P5)))

OK (10 msec)

4、配置客户端的tnsnames.ora

P5 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.111.231)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.111.232)(PORT = 1521))

)

(LOAD_BALANCE = ON)

(FAILOVER = ON)

(CONNECT_DATA =

(SERVICE_NAME = P5)

(FAILOVER_METHOD =

(TYPE = SESSION)

(METHOD = BASIC)

)

)

)

测试：

D:HwJavasqlstress>tnsping P5

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 27-4月 -2005 16:42:34

Copyright (c) 1997 Oracle Corporation. All rights reserved.

已使用的参数文件:

D:oracleora92 etworkadminsqlnet.ora

已使用 TNSNAMES 适配器来解析别名

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.111.231)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.111.232)(PORT = 1521))) (LOAD_BALANCE = ON) (FAILOVER = ON) (CONNECT_DATA = (SERVICE_NAME = P5) (FAILOVER_METHOD = (TYPE = SESSION) (METHOD =BASIC))))

OK（20毫秒）

5、配置客户端的 hosts

这个一定要配！

对xp，hosts文件的路径是C:WINDOWSsystem32driversetchosts

10.71.111.231 power1

10.71.111.232 power2

测试：

D:HwJavasqlstress>ping power1

Pinging power1 [10.71.111.231] with 32 bytes of data:

Reply from 10.71.111.231: bytes=32 time<1ms TTL=251

D:HwJavasqlstress>ping power2

Pinging power2 [10.71.111.232] with 32 bytes of data:

Reply from 10.71.111.232: bytes=32 time<1ms TTL=251

6、连接测试：

C:Documents and SettingsH36922>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 4月 27 17:20:33 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn system/manager@p5

已连接。

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

P52

SQL> conn system/manager@p5

已连接。

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

P52

SQL> conn system/manager@p5

已连接。

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

P51

SQL> conn system/manager@p5

已连接。

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

P52

SQL> conn system/manager@p5

已连接。

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

P51

SQL> conn system/manager@p5

已连接。

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

P52

SQL> conn system/manager@p5

已连接。

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

P51

多次连接，会分别连到P51、P52两个节点。

6、java通过OCI连接

package racbalance;

import java.sql.*;

import oracle.jdbc.driver.OracleDriver;

public class MyThread extends Thread {

String ThreadName="";

public MyThread(String sName) {

this.ThreadName = sName;

}

public void run()

{

try {

ConnOracle();

}

catch (SQLException ex) {

System.out.print( ex.toString() );

}

}

public void ConnOracle() throws SQLException

{

int total = 1000;

int sucessful = 0;

int fail = 0;

int aip1 = 0;

int aip2 = 0;

Connection conn = null;

Statement stmt = null;

ResultSet rset = null;

while (total > 0) {

if (total % 100 == 0 && total != 1000) {

System.out.println(ThreadName);

System.out.print("power1=");

System.out.println(aip1);

System.out.print("power2=");

System.out.println(aip2);

System.out.print("sussful=");

System.out.println(sucessful);

System.out.print("fail=");

System.out.println(fail);

System.out.println("-------------------------------------------------");

}

total--;

try {

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

String url = "jdbc:oracle:oci:@p5";

conn = DriverManager.getConnection(url, "system", "manager");

stmt = conn.createStatement();

rset = stmt.executeQuery("select host_name from v$instance");

while (rset.next()) {

String res = null;

res = rset.getString(1);

System.out.println(ThreadName+':'+res);

if (res.equals("power1"))

aip1++;

else

aip2++;

// System.out.println( res );

}

sucessful++;

}

catch (Exception e) {

fail++;

System.out.println(e.getMessage());

}

finally {

if (rset != null)

rset.close();

if (stmt != null)

stmt.close();

if (conn != null)

conn.close();

}

try {

Thread.currentThread().sleep(10);

}

catch (Exception e) {

System.out.println("sleep exception");

}

}

System.out.print("power1=");

System.out.println(aip1);

System.out.print("power2=");

System.out.println(aip2);

System.out.print("sussful=");

System.out.println(sucessful);

System.out.print("fail=");

System.out.println(fail);

double dd = 0.00;

System.out.print("aip1/aip2=");

if (aip2 > 0) {

dd = aip1 / aip2;

System.out.println(dd);

}

else {

System.out.println("~~~~~~~~");

}

System.out.print("fail/sucessful=");

if (sucessful > 0) {

dd = fail / sucessful;

System.out.println(dd);

}

else {

System.out.println("~~~~~~~~");

}

}

}
[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9650775/viewspace-920361/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9650775/viewspace-920361/

cqwf95925
关注
rac的FAILOVER 和LOAD_BALANCE参数，yes和on是否通用！
cjl249848056的博客
05-11 2187
rac的FAILOVER 和LOAD_BALANCE参数，yes和on通用吗？ 我看rac文档，FAILOVER = on，LOAD_BALANCE=on，可是有的文档，用的是yes。莫非o...
oracle连接无法负载,Oracle RAC的连接负载均衡load balance 以及连接故障failover转移...
weixin_32827751的博客
04-03 919
连接Oracle Real Application Clusters所有的数据库节点可以访问数据库中所有的数据自动维持节点之间的数据一致性SQL的并行执行(Parallel Execution)可以自动并列化一个SQL的执行从Oracle客户端开始的连接与串行处理相同无论是单一实例或是RAC都是可行的安装两个软件1.Oracle Grid Infrastructure 11g Release 2O...
Load Balancing & Failover (RAC)RAC负载均衡和失效接管
04-17
Load Balancing & Failover (RAC)RAC负载均衡和失效接管
oracle rac fail,Oracle RAC Load Balance , Fail Over测试
weixin_42362048的博客
04-13 157
配置server端的tnsnames.ora,首先来看各实例的remote_listener和local_listener情况:rac1:SQL> show parameter listenerNAME TYPE VALUE------------------------------------ ----------- ------------------------------local_...
如何配置Oracle RAC Load Balance 及FailOver
cuixie2370的博客
05-21 174
Subject: Configuration of Load Balancing and Transparent Application Failover Doc ID: 226880.1 Ty...
Oracle RAC 客户端FAILOVER LOADBALANCE特性的配置方法
congxinlan3332的博客
03-31 403
RAC客户端配置常见的报错：ORA-12545: 因目标主机或对象不存在，连接失败。1 RAC 客户端配置方法1.1 配置hosts修改C:\Windows\System32\drivers\etc\hosts(Wi...
oracle failover mode,Oracle RAC FailOver配置
weixin_39536427的博客
04-07 1031
Oracle RAC FailOver配置Oracle RAC主要为数据库的应用提供了HA(High Available)的环境，HA体现在负载均衡(loadbalance)和容错(failover)两个方面。Oracle RAC 的Failover 可以分为2种：1. TAF(Client_side)2. Service-Side TAF一． TAF(Transparent Applicatio...
Oracle RAC Failover 详解
03-15
### Oracle RAC Failover 详解 #### 一、概述 ...通过上述介绍，我们可以了解到 Oracle RAC Failover 机制的不同方面以及如何根据不同的需求配置这些 Failover 选项，以实现最优的高可用性和负载均衡效果。
weblogic连接oracle RAC数据源配置
03-17
- URL格式通常是：`jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac_node1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=rac_node2)(PORT=1521)))...
RAC的两大应用特性FAILOVER和LOAD_BALANCE总结
clt3617的博客
03-26 766
failover容易理解，案例也容易构造load_balance不太容易弄，还好都清楚了。[@more@]FAILOVER特性介绍1.connect-time failover8i提出来这个特性，为后来事先TAF打下了基础。co...
Protel DXP出现错误" Fail to load Parallel Port Driver" 的解决
Mountainer
10-28 2万+
Protel DXP出现错误 Fail to load Parallel Port Driver 经常听网友说打开DXP时，会弹出”Fail to load Parallel Port Driver”这样的错误，虽然不影响使用，但每次打开就出现一个这样的错误，多少有些不爽。其实这个错误源于Altium的FPGA应用。每次启动DXP时,DXP都会自动检测有没有连接到Nanoboard。（这个是
Oracle的load_balance和failover
关注系统性能调优
04-05 1万+
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
Oracle RAC 客户端连接负载均衡(Load Balance)
热门推荐
乐沙弥的世界
10-11 3万+
实现负载均衡(Load Balance)是Oracle RAC最重要的特性之一，主要是把负载平均分配到集群中的各个节点，以提高系统的整体吞吐能力。通常情况下有两种方式来实现负载均衡，一个是基于客户端连接的负载均衡，一个是基于服务器端监听器(Listener)收集到的信息来将新的连接请求分配到连接数较少实例上的实现方式。本文主要讨论的是基于客户端连接的负载均衡，并给出演示。        与负载均衡
LOAD_BALANCE FAILOVER SOURCE_ROUTE 组合分类
关注系统性能调优
06-03 1752
1、按顺序尝试每个地址，直到有一个成功 tnsnames.ora 里面的配置是这样的 SUN =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 岑仁彪)(PORT = 1521))       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168
Oracle RAC failover 测试(连接时故障转移)
乐沙弥的世界
12-17 1万+
Oracle RAC 集群最突出的表现就是高可用性，这些内容主要包括load balance以及failover，通过这些技术使得单点故障不影响客户端端应用程序对数据库的正常访问，以及通过创建service实现节点间负载均衡。本文主要描述Oracle 10g rac环境下的Oracle failover测试。    下面是一些关于这方面的基础参考或相关链接：  有关负监听配置，载均衡(load b
数据库（三）负载均衡（Load Balance）
蜗牛不怕慢的博客
03-25 1990
负载均衡集群是由一组相互独立的计算机系统构成，通过常规网络或专用网络进行连接，由路由器衔接在一起，各节点相互协作、共同负载、均衡压力，对客户端来说，整个群集可以视为一台具有超高性能的独立服务器。 .1)实现原理        实现数据库的负载均衡技术，首先要有一个可以控制连接数据库的控制端。在这里，它截断了数据库和程序的直接连接，由所有的程序来访问这个中间层，然后再由中间层来访问数据库。这样，
负载均衡（Load Balance）简介
guofeng_hao的博客
02-25 1万+
负载均衡(Load Balance，简称LB)是一种服务器或网络设备的集群技术。负载均衡将特定的业务(网络服务、网络流量等)分担给多个服务器或网络设备，从而提高了业务处理能力，保证了业务的高可用性。负载均衡基本概念有：实服务、实服务组、虚服务、调度算法、持续性等，其常用应用场景主要是服务器负载均衡，链路负载均衡。 一 服务器负载均衡 服务器负载均衡根据LB设备处理到的报文层次，分为四层服务器负载均...
Oracle RAC LoadBalance（负载均衡）说明
daf380的专栏
04-12 3186
一、什么是LoadBalance LoadBalance 就是把负载平均的分配到集群中的各个节点，从而提高整体的吞吐能力。Oracle RAC 提供了两种不同的方法来分散负载。 一种是通过Connection Balancing，按照某种算法把用户分配到不同的节点。也可认为是纯技术的分散负载。 另一种是通过Service，在应用层上进行分散，也可认为是根据业务的分散负载。 1.1、Con...
tnsnames.ora里面的load_balance缺省是on吗？
jarry_gao的专栏
10-20 1881
11.2的官方文档是这么写的 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
Oracle RAC数据库JDBC连接配置详解
- 在第二个URL中，`(LOAD_BALANCE=no)`表示禁用负载均衡，`(FAILOVER=on)`表示启用故障转移，`(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=30)(DELAY=5))`定义了故障转移的策略，基本模式（BASIC）会在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值