Databases Reference
In-Depth Information
6. Choose
*Oracle's Driver (Thin XA) for RAC Service-Instance
connections; Versions:10 and later
from the Database Driver
drop-down menu. Click on the Next button.
7. Then, click on the Next button in the Transaction Options page.
8. On 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. Complete the Database User Name,
Password, and Confirm Password fields by typing
dbuser
, and
dbpwd
as the
username and password respectively. Click on the Next button.
9. Click on the Next button in the Test Database Connection page.
10. Select 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. Add
ds-XA-rac02
as
Name,
jdbc/ds-XA-rac02
as JNDI Name,
dbservice-rac02
as Service Name,
instance-rac02
as Database Name, and
dbhost-rac02
in the Host Name field.
12. Create the multi data source by clicking on the New button then on the Multi Data
Source link.
13. Type
ds-XA
in the Name field and
jdbc/ds-XA
in the JNDI Name field. Leave the
other options as their default values. Click on the Next button.
14. Select the All servers in the cluster radio button from the
PROD_Cluster
cluster.
Click on the Next button.
15. Select the XA Driver option. Click on Next.
16. Select both data sources
ds-XA-rac01
and
ds-XA-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.
Search WWH ::
Custom Search