Configuring JDBC Resources for High Availability - Oracle WebLogic Server 12c Advanced Administration - page 85

Consider that the DBApp application requires an XA connection with a JNDI name jdbc/ds-
GridLinkXA to a database. The database is an Oracle RAC database with two nodes. The
first node runs in the dbhost-rac01 hostname and listens to the port 1521 . The second
node runs in the dbhost-rac02 hostname and also listens to the port 1521 . The database
has a service name dbservice . The ONS service is running on the onshost hostname,
port 6200 .
Getting ready
Create the GridLink data source with the JNDI name jdbc/ds-GridLinkXA in the
Administration Console. Make sure the Administration Server is running.
How to do it...
Carry out the following steps to create a new GridLink data source:
1. Access the Administration Console 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 then click on
Data Sources.
4. Click on the New button and then click on GridLink Data Source.
5. Type ds-GridLinkXA in the Name field and jdbc/ds-GridLinkXA in the
JNDI Name field. Choose *Oracle's Driver (Thin XA) for GridLink
Connections Versions:11 and later from the Database Driver drop-down
menu. Click on the Next button.
6. Click on the Next button on the Transaction Options page.
7. Leave the Enter individual listener information option selected on the GridLink
data source connection Properties Options page and click on the Next button.
8. On the Connection Properties page, type dbservice in the Service Name field.
Type dbhost-rac01:1521 in the Host and Port field and click on the Add button.
Add the second host by typing dbhost-rac02:1521 in the Host and Port field
and clicking on the Add button. Complete the database User Name, Password,
and Confirm Password fields by typing dbuser and dbpwd as the username and
password respectively. Leave the Protocol field with the TCP value. Click on the
Next button.
9. Click on the Next button on the Test GridLink Database Connection page.
10. On the ONS Client Configuration page, type onshost:6200 in the ONS host
and port field and click on the Add button. Then click on Next.
11. Click on the Next button on the Test ONS client configuration page.