Databases Reference
In-Depth Information
5. Check the Failover Request if Busy checkbox and type
5
in the Test Frequency
Seconds field. Click on the Save button, as shown in the following screenshot:
6. Click on the Data Sources link on the left navigation tree again. Click on the
ds-XA-rac01
data source link and then on the Connection Pool tab.
7. In the URL field, add the following parameters to the text value:
(ENABLE=BROKEN)
(LOAD_BALANCE=OFF)(FAILOVER=OFF)
. The final URL should be
jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(LOAD_
BALANCE=OFF)(FAILOVER=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=dbhost-rac01)(PORT=1521)))(CONNECT_DATA=(SERVICE_
NAME=dbservice-rac01)(INSTANCE_NAME=instance-rac01)))
.
8. Add the line
oracle.net.CONNECT_TIMEOUT=10000
to the Properties field.
9. If not already tuned from the previous recipe, type
0
in the Initial Capacity field and
15
in the Maximum Capacity and Minimum Capacity fields. Click on the Advanced
link to open the advanced options.
10. Check the Test Connection on Reserve checkbox. Type
900
in the Test Frequency
field and type
0
in the Seconds to Trust an Idle Connection field.
11. Leave the other options as their default values and click on the Save button.
12. Repeat steps
6
to
10
with the
ds-XA-rac02
data source.
13. Finally, click on the Activate Changes button.
How it works...
This recipe performs some additional tuning on the data sources and multi data sources.
The Failover Request if Busy option is not enabled by default and is recommended to be
enabled when using multi data sources with the
Failover
algorithm. It works by providing
a connection from the next data source member on the list when all the connections from the
primary data source member are in use (overloaded).
Search WWH ::
Custom Search