Databases Reference
In-Depth Information
5. Type
JDBCStore01
in the Name field. Click on the Target drop-down menu and
select the
PROD_Server01
option. Select the
ds-store
value in the Data Source
field. Type
JDBCStore01
again in the Prefix Name field and click on the OK button.
6. Repeat the previous steps and create the remaining JDBC stores,
JDBCStore02
,
JDBCStore03
, and
JDBCStore04
targeting the corresponding Managed Servers,
PROD_Server02
,
PROD_Server03
, and
PROD_Server04
. Use the same
ds-
store
data source for all JDBC stores.
7. Click on the Activate Changes button to finish.
How it works...
The JDBC stores were created in all Managed Servers of the cluster and can be used
as persistent stores for the JMS servers.
The JDBC store uses a multi data source pointing to an Oracle RAC database with two
RAC nodes.
It's mandatory to use
non-XA
data sources and a multi data source
with the
Failover
algorithm with the JDBC store. Make sure to tune
all JDBC parameters according to how they were tuned in the previous
chapter.
There's more...
The JDBC store can be created using WLST.
Creating the JDBC store using WLST
1. Log in as a
wls
user to the shell and start WLST.
[wls@prod01]$ $WL_HOME/common/bin/wlst.sh
2. Connect to the Administration Server using
wlsadmin
as 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 create the first data source:
edit()
startEdit()
# create the ds-store-rac01 data source
cd('/')
Search WWH ::
Custom Search