Option: Try each address, in order, until one succeeds ( Failover only). By default failover=true if you have more than one entry in address list.
=============================================================================
MEHTA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NYBOX)(PORT = 1555))
(ADDRESS = (PROTOCOL = TCP)(HOST = FLBOX)(PORT = 1600))
)
(CONNECT_DATA =
(SERVICE_NAME = TESTDB)
)
)
Option: Try each address randomly, until one succeeds (Load_Balance=yes), Whenever RANDOM word comes consider LOAD_BALANCE=YES. So this option is example of Failover and load balancing.
===========================================================================
MEHTA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NYBOX)(PORT = 1555))
(ADDRESS = (PROTOCOL = TCP)(HOST = FLBOX)(PORT = 1600))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = TESTDB)
)
)
Option: Try one address only, selected at random. (Load Balancing only)
=======================================================================
MEHTA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NYBOX)(PORT = 1555))
(ADDRESS = (PROTOCOL = TCP)(HOST = FLBOX)(PORT = 1600))
(LOAD_BALANCE = yes)
(FAILOVER = false)
)
(CONNECT_DATA =
(SERVICE_NAME = TESTDB)
)
)
Option: Use each address in order until destination is reached, used with oracle connection manager.
====================================================================================================
MEHTA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NYBOX)(PORT = 1555))
(ADDRESS = (PROTOCOL = TCP)(HOST = FLBOX)(PORT = 1600))
(SOURCE_ROUTE = yes)
(FAILOVER = false)
)
(CONNECT_DATA =
(SERVICE_NAME = TESTDB)
)
)
Option: Use only the first address.
====================================================
MEHTA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NYBOX)(PORT = 1555))
(ADDRESS = (PROTOCOL = TCP)(HOST = FLBOX)(PORT = 1600))
(FAILOVER = false)
)
(CONNECT_DATA =
(SERVICE_NAME = TESTDB)
)
)