This article translates and consolidates Oracle Real Application Clusters 19c Technical Architecture, using 41 detailed diagrams to explain RAC concepts, configurations, cluster components, storage options, tools, and management commands for building and operating high‑availability Oracle databases.
Learn how to rapidly set up an Oracle RAC testing cluster using VirtualBox and Vagrant, covering the reasons for avoiding Docker, required software versions, Vagrantfile configuration, shared disk creation, network setup, and step‑by‑step commands to launch and access the virtual machines.
When a major operations incident strikes, the safest approach is to prioritize simple, low‑risk actions and accept limited responsibility, as illustrated by real DBA lessons from Oracle RAC failures and a data‑center power‑loss disaster.
The article examines Oracle RAC’s perceived obsolescence, compares it with modern distributed databases, reviews recent Chinese vendor releases of RAC‑like products, and argues that high‑availability needs, hardware advances, and evolving data architectures keep shared‑storage clustering relevant today.
This article explains core cluster concepts, the benefits of building database clusters, classifies common cluster types, and compares scalable architectures such as Oracle RAC, MySQL Cluster, sharding, CAP/BASE theory, and cross‑database transaction strategies for high availability and performance.
A tiny typo—a stray space in an ifconfig command—changed a node's IP to 0.0.0.0, triggering IPC errors, instance eviction, and a full Oracle RAC restart, illustrating why meticulous command entry and privileged‑user discipline are critical in system operations.
An Oracle RAC deployment across four identical clusters repeatedly experienced node crashes, each traced to ocssd.bin failures caused by a memory leak bug in CRSD/OCSSD processes (Bug 11704113), with analysis of logs, kernel parameters, and recommended patches and configuration tweaks to prevent recurrence.
This guide provides a comprehensive, command‑by‑command walkthrough for shutting down and starting Oracle RAC clusters, covering srvctl and crsctl usage, status checks, and essential options to help administrators manage database instances and cluster services reliably.
The article explains the common Oracle RAC “IPC Send timeout” error, shows real alert‑log examples, analyzes root causes such as network loss, resource exhaustion, or bugs, and provides step‑by‑step troubleshooting methods including monitoring tools and configuration checks.
An Oracle RAC performance analysis shows that delayed commits on a configuration table cause frequent gc buffer busy acquire and gc cr block busy waits, dramatically slowing SELECT statements, increasing LMS/LGWR CPU usage, and prompting short‑ and long‑term mitigation strategies.
A two‑node Oracle 11g RAC cluster repeatedly lost quorum because the voting file on /dev/raw/raw1 became unavailable due to a storage link failure, leading to simultaneous CRSD reboots and highlighting the need to check hardware when RAC misbehaves.
