Databases Reference
In-Depth Information
4. Run the following WLST commands to tune the first data source:
# tune ds-XA-rac01
cd('/JDBCSystemResources/ds-XA-rac01/JDBCResource/ds-XA-rac01/
JDBCDriverParams/ds-XA-rac01')
cmo.setUrl('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)))')
cd('/JDBCSystemResources/ds-XA-rac01/JDBCResource/ds-XA-rac01/
JDBCDriverParams/ds-XA-rac01/Properties/ds-XA-rac01')
cmo.destroyProperty(getMBean('/JDBCSystemResources/ds-XA-rac01/
JDBCResource/ds-XA-rac01/JDBCDriverParams/ds-XA-rac01/Properties/
ds-XA-rac01/Properties/user'))
cmo.createProperty('user')
cd('/JDBCSystemResources/ds-XA-rac01/JDBCResource/ds-XA-rac01/
JDBCDriverParams/ds-XA-rac01/Properties/ds-XA-rac01/Properties/
user')
cmo.setValue('dbuser')
cd('/JDBCSystemResources/ds-XA-rac01/JDBCResource/ds-XA-rac01/
JDBCDriverParams/ds-XA-rac01/Properties/ds-XA-rac01')
cmo.createProperty('oracle.net.CONNECT_TIMEOUT')
cd('/JDBCSystemResources/ds-XA-rac01/JDBCResource/ds-XA-rac01/
JDBCDriverParams/ds-XA-rac01/Properties/ds-XA-rac01/Properties/
oracle.net.CONNECT_TIMEOUT')
cmo.setValue('10000')
cd('/JDBCSystemResources/ds-XA-rac01/JDBCResource/ds-XA-rac01/
JDBCConnectionPoolParams/ds-XA-rac01')
cmo.setMaxCapacity(15)
cmo.setMinCapacity(15)
cmo.setSecondsToTrustAnIdlePoolConnection(0)
cmo.setTestConnectionsOnReserve(true)
cmo.setTestFrequencySeconds(900)
cmo.setInitialCapacity(0)
5. Run the following WLST commands to tune the second data source:
# tune ds-XA-rac02
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDriverParams/ds-XA-rac02')
 
Search WWH ::




Custom Search