Oracle client configuration tnsnames.ora

zhaozj2021-02-16  81

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 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 listner.ora. A staticly 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 = "(address = (protocol = TCP) (PORT = 1521) (address = (protocol = TCP) (Host = Sales2-SVR) (port = 1521 ))))) (Service_name = sales.us.acme.com))))))

LOAD_BALANCE

Purpose

Use the parameter load_balance to enable or disable client loading balacing for multiple protocol address.

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 = (address = (protocol = TCP) (Host = Sales1-SVR) (address = (protocol = TCP) (Host = Sales2-SVR) (port = 1521 ))))) (Connect_data = (service_name = sales.us.acme.com))

Related reference documents:

http://www.cise.ufl.edu/help/Database/oracle-docs/network.920/a96581/tnsnames.htm

转载请注明原文地址:https://www.9cbs.com/read-12328.html

New Post(0)