WebSphere Application Server Network Deployment: Specifying the alternate database addresses and ports for Oracle RAC

For IBM® WebSphere® Application Server Network Deployment to communicate with the servers in an Oracle RAC, specify alternate database addresses and ports.

Prerequisites

Creating the metadata repository database and running the installation program within an Oracle RAC configuration

1. Start the WebSphere Application Server administrative console.
2. Log in as the WebSphere Application Server administrator (default: wasadmin), or as another user with administrative privileges.
3. In the navigation pane, expand Resources, expand JDBC, and click JDBC Providers.
   The JDBC providers page opens.
4. Complete the steps for the following JDBC provider:
   • ASB XA JDBC Provider
   1. Ensure All scopes is selected for the Scope.
   2. Click the JDBC provider link.
      The JDBC provider page opens.
   3. Under Additional Properties, click Data sources
   4. Complete the steps for the following data source:
      • ASB JDBC Staging XA DataSource

      1. Click the data source.
      2. Under Additional Properties, click Custom Properties.
      3. Include only the following properties:
         • serverName with the name of your primary server.
         • portNumber with the port number, usually 1521.
         • webSphereDefaultIsolationLevel with the value of 2.
         • enable2Phase with the default value of true.
         • serviceName with the value of your service name.
         • alternateServers to contain the value of the alternate servers. For example (host1:port,host2:port,host3:port)
         • ConnectionRetryCount with the value of your choice, for example, 20.
         • ConnectionRetryDelay with the value of your choice, for example, 100.
      4. Click Test Connection to test the connection.
5. Log out of the console.
6. Restart the application server. For clustered WebSphere Application Server, restart the cluster members, node agents, and the deployment manager.