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