examples:
DFDZ_DATASRV =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER=ON)
(LOAD_BALANCE=off)
(ADDRESS = (PROTOCOL = TCP)(HOST = ibmRS6002)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dfdzs1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
FAILOVER
Purpose
Use the parameter FAILOVER
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.
Embed this parameter under either the DESCRIPTION_LIST
parameter, the DESCRIPTION
parameter, or the ADDRESS_LIST
parameter.
Important: Do not set the |
Default
on
for DESCRIPTION_LIST
s, DESCRIPTION
s, and ADDRESS_LIST
s
Values
on
| off
| yes
| no
| true
| 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.acme.com)))
LOAD_BALANCE
Purpose
Use the parameter LOAD_BALANCE
to enable or disable client load balancing for multiple protocol addresses.
When you set the parameter to on
, yes
, or true
, Oracle Net progresses through 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 protocol addresses sequentially until one succeeds.
Embed this parameter under either the DESCRIPTION_LIST
parameter, the DESCRIPTION
parameter, or the ADDRESS_LIST
parameter.
Default
on
for DESCRIPTION_LIST
s
Values
on
| off
| yes
| no
| true
| 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.acme.com))
相关参考文档:
http://www.cise.ufl.edu/help/database/oracle-docs/network.920/a96581/tnsnames.htm