When a database service is accessible by multiple listener protocol addresses, it is important to specify the order in which the protocol addresses are to be used. For example, the protocol addresses can be chosen randomly or tried sequentially.
When multiple protocol addresses have been configured for a net service name or database service, the following options are configurable:
Connect-time failover to choose the first protocol address, and fail over to the next protocol address if the first protocol address fails
Client load balancing to randomly choose a protocol address
Source routing to use all protocol addresses sequentially
To configure multiple address options:
In the navigator pane, expand Oracle Net Configuration > Directory > Local or Service Naming.
Select a net service name or database service. The right pane displays the current destination service and address list.
In the Address Configuration box, choose Advanced. The Address List Options dialog box appears.
Clear Use Options Compatible with Net8 8.0 Clients if this configuration is for an Oracle9 i or Oracle8 i client.
Select the option appropriate for the protocol address list, and then choose OK.
In the right pane, choose Apply.
If you are making these changes to the Local folder, choose File > Save Network Configuration.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.