Oracle客户端配置tnsnames.ora

最新推荐文章于 2024-03-21 21:32:22 发布

q30

最新推荐文章于 2024-03-21 21:32:22 发布

阅读量3.2k

点赞数

分类专栏： Oracle 文章标签： oracle list service tcp database manager

本文链接：https://blog.csdn.net/q30/article/details/55201

版权

Oracle 专栏收录该内容

48 篇文章 0 订阅

订阅专栏

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 GLOBAL_DBNAME parameter in the SID_LIST_listener_name section of the listener.ora. A statically configured global database name disables connect-time failover.

Default

on for DESCRIPTION_LISTs, DESCRIPTIONs, and ADDRESS_LISTs

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_LISTs

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))