A Using Multi Data Sources with Oracle RAC

Oracle recommends using GridLink data sources when developing 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 includes the following sections:

A.1 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 Oracle Fusion Middleware Configuring and Managing JDBC Data Sources for Oracle WebLogic Server.

A.2 Typical Procedure for Configuring Multi Data Sources for an Enterprise Deployment Topology

You configure data sources when you configure a domain. 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 procedure.

To configure Multi Data Sources for an enterprise deployment topology:

  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

    Configure RAC Multi Data Source Component Schema screen
    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 for the database schema owner of the corresponding component.

        This book uses WCC as the prefix of user names for the database 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.