This chapter describes the requirements and configuration tasks for using Oracle Real Application Clusters (Oracle RAC) with WebLogic Server 10.3.6.
Oracle WebLogic Server 10.3.6 provides strong support for Oracle Real Application Clusters (RAC) features in Oracle Database 11g, minimizing database access time while allowing transparent access to rich pooling management functions that maximizes both connection performance and availability.
This chapter includes the following sections:
Both Oracle RAC and WebLogic Server are complex systems. To use them together requires specific configuration on both systems, as well as clustering software and a shared storage solution. This document describes the configuration required at a high level. For more details about configuring Oracle RAC, your clustering software, your operating system, and your storage solution, see the documentation from the respective vendors.
Oracle Real Application Clusters (Oracle RAC) is a software component you can add to a high-availability solution that enables users on multiple machines to access a single database with increased performance. Oracle RAC comprises two or more Oracle database instances running on two or more clustered machines and accessing a shared storage device via cluster technology. To support this architecture, the machines that host the database instances are linked by a high-speed interconnect to form the cluster. The interconnect is a physical network used as a means of communication between the nodes of the cluster. Cluster functionality is provided by the operating system or compatible third party clustering software.
An Oracle RAC installation appears like a single standard Oracle database and is maintained using the same tools and practices. All the nodes in the cluster execute transactions against the same database and Oracle RAC coordinates each node's access to the shared data to maintain consistency and ensure integrity. You can add nodes to the cluster easily and there is no need to partition data when you add them. This means that you can horizontally scale the database tier as usage and demand grows by adding Oracle RAC nodes, storage, or both.
To use WebLogic Server with Oracle RAC, you must install the following software on each Oracle RAC node:
Operating system patches required to support Oracle RAC. See the release notes from Oracle for details.
Oracle 11g database management system. See Oracle® Fusion Middleware Licensing Information.
Clustering software for your operating system. See the Oracle documentation for supported clustering software and cluster configurations.
Shared storage software, such as Veritas Cluster File System. Note that some clustering software includes a file storage solution, in which case additional shared storage software is not required.
Note:
See "Supported Configurations" in What's New in Oracle WebLogic Server for the latest WebLogic Server hardware platform and operating system support, and for the Oracle RAC versions supported by WebLogic Server versions and service packs. See the Oracle documentation for hardware and software requirements required for running the Oracle RAC software.To use WebLogic Server with Oracle RAC, your WebLogic JDBC data sources must use the Oracle JDBC Thin driver 11g to create database connections.
A typical WebLogic Server/Oracle RAC system includes a WebLogic Server cluster, an Oracle RAC cluster, and hardware for shared storage.
The WebLogic Server cluster can be configured in many ways and with various hardware options. See Using Clusters for Oracle WebLogic Server for more details about configuring a WebLogic Server cluster.
For the latest hardware requirements for Oracle RAC, see the Oracle RAC documentation. However, to use Oracle RAC with WebLogic Server, you must run Oracle RAC instances on robust, production-quality hardware. The Oracle RAC configuration must deliver database processing performance appropriate for reasonably-anticipated application load requirements. Unusual database response delays can lead to unexpected behavior during database failover scenarios.
In an Oracle RAC configuration, all data files, control files, and parameter files are shared for use by all Oracle RAC instances. An HA storage solution that uses one of the following architectures is recommended:
Direct Attached Storage (DAS), such as a dual ported disk array or a Storage Area Network (SAN)
Network Attached Storage (NAS)
For a complete list of supported storage solutions, see your Oracle documentation.
When using WebLogic Server with Oracle RAC, you must configure your WebLogic Domain so that it can interact with Oracle RAC instances and so that it performs as expected. The following sections describe configuration options and requirements:
Choosing a WebLogic Server Configuration for Use with Oracle RAC
Validating Connections when using WebLogic Server with Oracle RAC
Additional Considerations When Using WebLogic Server with Oracle RAC
Consider the following alternatives:
Using GridLink data sources, see Oracle® Fusion Middleware Licensing Information.
To connect to multiple Oracle RAC instances when using global transactions (XA), Oracle recommends the use of transaction-aware WebLogic JDBC multi data sources, which support failover and load balancing, to connect to the Oracle RAC nodes. For more information see Using Multi Data Sources with Global Transactions.
To connect to multiple Oracle RAC 11g instances when not using XA, Oracle recommends the use of (non-transaction-aware) multi data sources to connect to the Oracle RAC nodes. Use the standard multi data source configuration, which supports failover and load balancing. For more information see Using Multi Data Sources without Global Transactions.
The following table may help you as you try to determine which configuration is right for your particular application:
Table 11-1 Choosing Configurations to Use with Oracle RAC
| Requires Load Balancing? | Requires Failover? | Requires Global Transactions (XA)? | Uses Oracle RAC Services | See... |
|---|---|---|---|---|
|
Yes |
Yes |
Yes |
Yes |
|
|
Yes |
Yes |
Yes |
No |
|
|
Yes |
Yes |
Yes |
Yes |
|
|
Yes |
Yes |
No |
Yes |
|
|
Yes |
Yes |
No |
No |
WebLogic supports the use of Oracle Data Guard with Multi Data Source and AGL. When used with a Multi Data Source, the following limitations exist:
Only the failover policy is supported.
Only one RAC instance is allowed in the primary data center. A single generic data source that is a member of the Multi Data Source is configured for the primary data center. If SCAN is used, an INSTANCE_NAME must also be specified.
For each standby instance, a generic data source that is a member of the Multi Data Source must be configured. If SCAN is used, an INSTANCE_NAME must also be specified for each instance. No member of the Multi Data Source can represent more than one instance in a RAC cluster.
Applications can use the JDBC 4.0 Connection.isValid API to verify connection viability.
Note:
WebLogic Server does not supportoracle.ucp.jdbc.ValidConnection.isValid or oracle.ucp.jdbc.ValidConnection.setInvalid.The Distributed Transaction Processing (DTP) attribute on a database service should not be used to coordinate transactions when using AGL data sources or multi data sources with Oracle RAC. This option implies that the service is guaranteed to run on only one RAC instance at any time. Transaction affinity to a single instance is automatically managed by WebLogic Server for either AGL or Multi Data Source. This allows the whole RAC cluster to be available for distributed transactions, as opposed to DTP limiting all transactions for the service to a single RAC instance.