Databases Reference
In-Depth Information
5. Type
ds-store-rac01
in the Name field and
jdbc/ds-store-rac01
in the JNDI
Name. Leave the Database Type drop-down menu with the Oracle option selected.
Click on the Next button.
6. Choose
*Oracle's Driver (Thin) for RAC Service-Instance
connections; Versions:10 and later
from the Database driver drop-down
menu. Click on the Next button.
7. Disable the Supports Global Transactions checkbox and click on the Next button.
8. In the Connection Properties page, type
dbservice-rac01
in the Service Name
field,
instance-rac01
in the Database Name field,
dbhost-rac01
in the Host
Name field, and
1521
in the Port field. Fill in the Database User Name, Password,
and Confirm Password fields with
dbuser
and
dbpwd
. Leave the Protocol field with
the default
TCP
value. Click on the Next button.
9. Click on the Next button in the Test Database Connection page.
10. Click on the All servers in the cluster radio button from the
PROD_Cluster
cluster.
Click on the Finish button.
11. Repeat the previous steps and create another data source. Use
ds-store-rac02
as Name,
jdbc/ds-store-rac02
as JNDI Name,
dbservice-rac02
as Service
Name,
instance-rac02
as Database Name, and
dbhost-rac02
as Host Name.
12. Create the multi data source by clicking on the New button and then the Multi Data
Source link.
13. Type
ds-store
in the Name field and
jdbc/ds-store
in the JNDI Name
field. Leave the Algorithm Type option in the default Failover option. Click on
the Next Button.
14. Click on the All servers in the cluster radio button from the
PROD_Cluster
cluster.
Click on the Next button.
15. Click on the Non-XA Driver option in the Select Data Source Type page. Click on Next.
16. Select both data sources
ds-store-rac01
and
ds-store-rac02
from the left of
the Add Data Source page. Click on the >button in the center of both sides to move
them to the right. Click on Finish.
17. Click on the Activate Changes button.
Create the JDBC stores using the Administration Console:
1. Access the Administration Console again with your web browser
at
http://adminhost.domain.local:7001/console
.
2. Click on the Lock & Edit button to start a new edit session.
3. Click on the plus sign to open the Services tree on the left and click on
Persistent Stores.
4. Click on the New button and click the Create JDBCStore link to start creating a new
persistent store.
Search WWH ::
Custom Search