Set Oracle Real Application Cluster
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 data block ownership information during startup
- Lock information
- Exchange transaction information and data
New feature: Use the Oracle JDBC driver to configure failover support and load balancing in an Oracle RAC environment.
First introduced in Oracle V9i, Oracle RAC clusters provide high availability and scalability, and consist of the following:
Cluster nodes 2 to n nodes or hosts, running the Oracle database server. Network Interconnect Private network used for cluster communications and cache fusion. Used for transferring database blocks between node instances. Shared Storage Holds database system and data files. Shared storage is accessed by the cluster nodes. Production network Used by clients and appservers to access the database.
The following figure depicts a typical configuration for Oracle RAC:
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 appserver to use Oracle's connection caching instead of the appserver's connection pooling feature.
Distributed Transaction Processing (DTP)
Introduced in Oracle 10gR2. Ensures that all in-flight prepared transactions belonging 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.
Related tasks
Set a simple RAC configuration in an appserver cluster.Set Oracle connection caching in the appserver
Set two-phase commit distributed transactions with Oracle RAC
Set a JDBC provider and data source