Configuring JBoss data sources for Oracle RAC

The BMC IT Business Management Suite installation program does not configure JBoss data sources for an Oracle Real Application Cluster (RAC). However, you can configure them manually.

To manually configure JBoss data sources for Oracle RAC

1. Run the installation program to configure JBoss.
2. Locate the oracle-xa-ds.xml and oracle-ds.xml files in \jboss-as\server\production\deploy.
3. In the oracle-xa-ds.xml file, locate the following lines:

   <xa-datasource-property name="URL">
   jdbc:oracle:thin:@node1-dns-name:1521: RACDB
   </xa-datasource-property>
   

4. Replace them with the following new lines:

   <xa-datasource-property name="URL">
   jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=on)
   (address=(protocol=tcp)(host=node1-dns-name)(port=1521))
   (address=(protocol=tcp)(host=node2-dns-name)(port=1521))
   (address=(protocol=tcp)(host=node3-dns-name)(port=1521))
   )(connect_data=(service_name=RACDB)(failover_mode=(type=select)(method=basic))))
   </xa-datasource-property>
   

5. Save and close the file.
6. In the oracle-ds.xml file, locate the following lines:

   <connection-url>
    jdbc:oracle:thin:@ node1-dns-name:1521: RACDB
    </connection-url>
   

7. Replace them with the following new lines:

   <connection-url>
   jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=on)
   (address=(protocol=tcp)(host=node1-dns-name)(port=1521))
   (address=(protocol=tcp)(host=node2-dns-name)(port=1521))
   (address=(protocol=tcp)(host=node3-dns-name)(port=1521))
   )(connect_data=(service_name=RACDB)(failover_mode=(type=select)(method=basic))))
   </connection-url>
   

8. Save and close the file.