Network Deployment (Distributed operating systems), v8.0 > Establishing high availability > Establishing high availability for Data access resources
Configure Oracle Real Application Cluster (RAC) with the application server
Oracle Real Application Cluster (RAC) is a "share-everything" database architecture in which two or more Oracle RAC nodes are clustered together and share the same storage. The RAC nodes are connected together with a high-speed interconnect that enables fast communication between the Oracle nodes. The nodes can exchange various categories of data block ownership information during startup, lock information, exchange transaction information and data, and so on. Use the Oracle JDBC driver, you can configure failover support, load balancing, or both, in an Oracle Real Application Clusters (RAC) environment. Oracle RAC is an option of an Oracle database that brings together two or more computers to form a clustered database that behaves as a single system. In a RAC database, Oracle processes that are running in separate nodes access the same data from a shared disk storage. First introduced in Oracle v9i, RAC provides both high availability and flexible scalability.
A typical Oracle RAC cluster consists of the following:
- Cluster nodes – 2 to n nodes or hosts, running the Oracle database server.
- Network Interconnect – a private network used for cluster communications and cache fusion. This is typically used for transferring database blocks between node instances.
- Shared Storage – used to hold the database system and data files. The shared storage is accessed by the cluster nodes.
- Production network – used by clients and application servers to access the database.
The following figure depicts a typical configuration for Oracle RAC:
Here are two of the many features that Oracle RAC provides:
- Oracle Notification Service (ONS) allows for Oracle RAC to communicate the status for the nodes, which are typically UP and DOWN events, to the Oracle JDBC driver and the driver's connection cache.
To take advantage of ONS, configure the application server to use Oracle's connection caching instead of the application server's connection pooling feature. Read the topic Configuring Oracle connection caching in the application server for more information on this process.
- Distributed Transaction Processing (DTP) is a feature that was introduced in Oracle 10gR2. When this feature is enabled, Oracle will ensure that all in-flight prepared transactions that belong to a DTP service for failed RAC instances are pushed to disk. Then, Oracle will restart the DTP service on any of the RAC instances that are still operational.
For more information on Oracle RAC and how it works with the application server, refer to Building a high availability database environment using WebSphere middleware: Part 3: Handling two-phase commit in WAS using Oracle RAC on the developerWorks website.
Procedure
- Configure a simple RAC configuration in an application server cluster.
- Configure Oracle connection caching in the application server.
- Configure two-phase commit distributed transactions with Oracle RAC.
Related
Configure a simple RAC configuration in an application server cluster
Configure Oracle connection caching in the application server
Configure two-phase commit distributed transactions with Oracle RAC
Configure a JDBC provider and data source
Related
Accept a high availability database environment using WebSphere middleware: Part 3: Handling two-phase commit in WAS using Oracle RAC