Oracle Real Application Clusters

Chapter 1: Requirements Analysis

Table 1.1: Acceptable Downtime Measurement

Chapter 2: Hardware Concepts

Table 2.1: Tightly Coupled Vs. Loosely Coupled

Table 2.2: Summary of Applications Driving Network Growth

Chapter 3: Oracle Database Concepts

Table 3.1: Control File Layout

Table 3.2: Single Instance vs. Clustered Configuration

Table 3.3: OPS vs. RAC

Chapter 4: Real Application Cluster Architecture

Table 4.1: Resource Modes

Table 4.2: Resource Roles

Table 4.3: Lock Modes

Chapter 5: Transaction Management

Table 5.1: DML Lock Abbreviations

Table 5.2: Lock Modes on DML Enqueues

Table 5.3: Lock Mode Compatibility Matrix

Table 5.4: Lock Modes in a RAC Implementation

Chapter 7: Designing Databases for RAC

Table 7.1: Natural and Reverse Key Values

Chapter 8: Installation and Configuration

Table 8.1: Kernel Parameters

Table 8.2: Semaphore and shared memory settings

Table 8.3: Recommended Sizes for the Initial Tablespaces

Chapter 9: Parameters and Views

Table 9.1: GES Conversion Types

Chapter 10: Availability and Scalability

Table 10.1: TAF Subparameters

Table 10.2: Failover Events

Chapter 11: Migrating to RAC

Table 11.1: Costing Model

Chapter 13: Performance Tuning —Tools and Utilities

Table 13.1: STATSPACK Scripts

Table 13.2: Threshold parameter descriptions and values

Table 13.3: STATSPACK Parameters and Values

Chapter 15: Performance Tuning — Cluster

Table 15.1: Kernel Parameters

Table 15.2: Enqueue Mode Descriptions

Table 15.3: Acceptable STATSPACK Latency Values

Table 15.4: STATSPACK Latency Values

Table 15.5: Class Description

Table 15.6: Lock Conversions

Chapter 16: Problem Diagnosis

Table 16.1: ORA-600 Argument and Layer Information

Chapter 17: RAC Implementations

Table 17.1: Watchdog Daemon Arguments

Table 17.2: CM Parameters for the cmcfg.ora File

Table 17.3: Arguments for the oracm Executable

Table 17.4: Hardware and O/S Requirements for CFS

Table 17.5: OcfsUtil Command Summary

Table 17.6: Recommended Allocation Unit Sizes

Appendix 4: Work Plan

Table A4.1: Certification Matrix

Table A4.2: Work plan RAC migration checklist