Databases Reference
In-Depth Information
WebLogic Server closes all the connections of a data source and disables it if the connection
to the database fails to be created two consecutive times. By default, the multi data source
rechecks the database every
120
seconds based on the multi data source Test Frequency
Seconds parameter. Changing the Test Frequency Seconds parameter to
5
seconds is
recommended.
The
(ENABLE=BROKEN)(LOAD_BALANCE=OFF)(FAILOVER=OFF)
parameters added to the
URL field are recommended settings for the data source members of multi data sources.
The
ENABLE=BROKEN
parameter adds an internal TCP keepalive on the JDBC client side,
improving the network connection reliability with the database.
The JDBC client load balance and JDBC connect time failover must be disabled with the
LOAD_BALANCE=OFF
and
FAILOVER=OFF
parameters since these features must be provided
by the multi data source.
The
oracle.net.CONNECT_TIMEOUT=10000
parameter adds a connect timeout of
10
seconds.
All other tunings, such as Initial Capacity, are described in the previous recipe.
There's more...
The data source configuration changes can be made with WLST.
Tuning the multi data sources using WLST
1. Log in as a
wls
user to shell and start WLST:
[wls@prod01]$ $WL_HOME/common/bin/wlst.sh
2. Connect to the Administration Server using
wlsadmin
as the user,
<pwd>
as the
password, and
t3://adminhost.domain.local:7001
as the server URL:
wls:/offline> connect("wlsadmin","<pwd>","t3://adminhost.domain.
local:7001")
3. Run the following WLST commands to tune the multi data source:
edit()
startEdit()
cd('/JDBCSystemResources/ds-XA/JDBCResource/ds-XA/
JDBCDataSourceParams/ds-XA')
cmo.setFailoverRequestIfBusy(true)
cd('/JDBCSystemResources/ds-XA/JDBCResource/ds-XA/
JDBCConnectionPoolParams/ds-XA')
cmo.setTestFrequencySeconds(5)
Search WWH ::
Custom Search