Name

ADDRESS_LIST

Synopsis

ADDRESS_LIST =
  (ADDRESS...)
  [(ADDRESS...)
  ...]
  [(FAILOVER = {ON | OFF | YES | NO | TRUE | FALSE})]
  [(LOAD_BALANCE = {ON | OFF | YES | NO | TRUE | FALSE})]
  [(SOURCE_ROUTE = {ON | OFF | YES | NO})]

An address list is used to enclose a list of addresses associated with a description.

Parameters

ADDRESS

Specifies a protocol address. See the ADDRESS entry in the next section.

FAILOVER

Enables or disables connect-time failover for addresses in the address list. By default, failover is on. When failover is on, a failure to connect using one address causes Net8 to try another address in the list. Net8 works through addresses in order unless client load balancing is used.

LOAD_BALANCE

Enables or disables client load balancing. Load balancing within an address list is off by default. When making a new connection with load balancing enabled, Net8 randomly chooses an address from the address list. If failover is also on, then Net8 randomly progresses from one address to another until either all addresses have been tried or a connection is made.

SOURCE_ROUTE

Used to route connections through Connection Manager. The default setting is OFF. When enabled, the address list must include two or more addresses. The first address must point to a Connection Manager instance. Net8 then connects by hopping from one address to the next until a database listener is reached.

Get Oracle Net8 Configuration and Troubleshooting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.