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