A Using Multi Data Sources with Oracle RAC

Oracle recommends that you use GridLink data sources when you develop new Oracle RAC applications. However, if you are using legacy applications and databases that do not support GridLink data sources, refer to the information in this appendix.

This appendix provides information about multi data sources and Oracle RAC and procedure for configuring multi data sources for an Enterprise Deployment.

About Multi Data Sources and Oracle RAC

A multi data source provides an ordered list of data sources to use to satisfy connection requests.

Normally, every connection request to this kind of multi data source is served by the first data source in the list. If a database connection test fails and the connection cannot be replaced, or if the data source is suspended, a connection is sought sequentially from the next data source on the list.

For more information about configuring Multi Data Sources with Oracle RAC, see Using Multi Data Sources with Oracle RAC in Administering JDBC Data Sources for Oracle WebLogic Server.

Typical Procedure for Configuring Multi Data Sources for an Enterprise Deployment

You need to configure data sources when you configure a domain. If you want to use Multi Data Sources instead of GridLink data sources, replace the GridLink instructions with the instructions provided in this section.

For example, when you are configuring the initial Administration domain for an Enterprise Deployment reference topology, you use the configuration wizard to define the characteristics of the domain, as well as the data sources.

The procedures for configuring the topologies in this Enterprise Deployment Guide include specific instructions for defining GridLink data sources with Oracle RAC. If you want to use Multi Data Sources instead of GridLink data sources, replace the GridLink instructions with the following:

  1. In the Configure JDBC Component Schema screen:

    1. Select the appropriate schemas.

    2. For the RAC configuration for component schemas, Convert to RAC multi data source.

    3. Ensure that the following data source appears on the screen with the schema prefix when you ran the Repository Creation Utility.

    4. Click Next.

  2. The Configure RAC Multi Data Sources Component Schema screen appears (Figure A-1).

    Figure A-1 Configure RAC Multi Data Source Component Schema Screen

    Description of Figure A-1 follows
    Description of "Figure A-1 Configure RAC Multi Data Source Component Schema Screen"

    In this screen, do the following:

    1. Enter values for the following fields, specifying the connect information for the Oracle RAC database that was seeded with RCU.

      • Driver: Select Oracle driver (Thin) for RAC Service-Instance connections, Versions:10, 11.

      • Service Name: Enter the service name of the database.

      • Username: Enter the complete user name (including the prefix) for the schemas.

      • Password: Enter the password to use to access the schemas.

    2. Enter the host name, instance name, and port.

    3. Click Add.

    4. Repeat this for each Oracle RAC instance.

    5. Click Next.

  3. In the Test JDBC Data Sources screen, the connections are tested automatically. The Status column displays the results. Ensure that all connections were successful. If not, click Previous to return to the previous screen and correct your entries.

    Click Next when all the connections are successful.