Databases Reference
In-Depth Information
set('Targets',jarray.array([ObjectName('com.bea:Name=PROD_
Cluster,Type=Cluster')], ObjectName))
5. Run the following WLST commands to create the multi data source:
#create the multi data source ds-xa
cd('/')
cmo.createJDBCSystemResource('ds-XA')
cd('/JDBCSystemResources/ds-XA/JDBCResource/ds-XA')
cmo.setName('ds-XA')
cd('/JDBCSystemResources/ds-XA/JDBCResource/ds-XA/
JDBCDataSourceParams/ds-XA')
set('JNDINames',jarray.array([String('jdbc/ds-XA')], String))
cmo.setAlgorithmType('Failover')
cmo.setDataSourceList('ds-XA-rac01,ds-XA-rac02')
cd('/JDBCSystemResources/ds-XA')
set('Targets',jarray.array([ObjectName('com.bea:Name=PROD_
Cluster,Type=Cluster')], ObjectName))
activate()
exit()
See also
F
Creating a JDBC data source
F
Defining the multi data source HA Strategy
F
Creating a GridLink data source
F
Tuning data sources for reliable connections
F
Tuning multi data sources - surviving RAC node failures
Defining the multi data source HA Strategy
The multi data source has two strategy options for highly available connections for an Oracle
RAC database. The strategy is defined by the Algorithm Type parameter.
In this recipe, the multi data source
ds-XA
will be changed from the default
Failover
algorithm to the Load Balance strategy.
Search WWH ::
Custom Search