Oracle客户端配置tnsnames.ora

关注

原创最新推荐文章于 2026-08-12 17:21:32 发布 3.4k 阅读 AI 写同款· GEO 优化 ›

Oracle tnsnames.ora 详解文章目录1 概述2 图示2.1 路径2.2 参数2.3 登录3 扩展 1 概述 #mermaid-svg-ZAgWjMQX0gJ3xtsn {font-family:"trebuchet ms",verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-ZAgWjMQX0gJ3xtsn .error-icon{fill:#552222;}#mermaid-svg-ZAgWjMQX0gJ3xtsn .error-text{fill:#552 阅读详情

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