A client reported sudden Oracle database slowdown, prompting a post‑mortem analysis using AWR and TFA data that revealed GC bottlenecks, RAC heartbeat packet loss, and an intermittent storage link failure, ultimately resolved by disabling the faulty port and restarting the affected node.
This article walks through real‑world Oracle RAC failures caused by misconfigured VIP failover and SCAN IP load‑balancing, explains how to diagnose the symptoms, provides correct TAF and listener settings, and highlights essential configuration tips to ensure reliable high‑availability operation.
This article compiles over a decade of real‑world Oracle single‑instance and RAC deployment experiences, detailing compatibility issues, specific bugs encountered in versions 10g, 11g, 12c, 19c on Linux platforms, and step‑by‑step remediation commands, scripts, and configuration adjustments to ensure successful installation.
This article provides a comprehensive overview of Oracle's database products, explaining why they matter, detailing the physical and logical storage structures, instance processes and memory areas, and tracing the evolution from early versions through RAC, multitenancy, and the latest 18c features.
The article provides a comprehensive overview of Oracle Real Application Cluster (RAC), detailing its two‑part architecture of Clusterware and RAC instances, shared storage configurations, key Clusterware processes, storage options, benefits such as load balancing and high availability, as well as its management and planning considerations.
This guide walks through creating an Oracle RAC on Oracle Cloud, covering account setup, virtual network configuration, SSH key creation, cluster provisioning, Flex ASM features, high‑availability service setup, and troubleshooting steps, all illustrated with command examples and screenshots.
During a morning peak on December 15, 2020, a customer's Oracle RAC cluster hit 100% CPU on both nodes, causing severe response delays, and after detailed session analysis and SQL rewrite the CPU load dropped dramatically, restoring normal service performance.
A telecom client migrated from IBM AIX/Oracle 11g to a domestic X86 appliance with Oracle 19c, encountering slow TimesTen Cache Group rebuilds, and the article details the root‑cause analysis and step‑by‑step optimization that cut rebuild time to one‑third.
This guide walks through using Oracle Real Application Testing (RAT) Database Replay to capture production workloads, preprocess them, and replay them on a new Oracle 19c environment, highlighting setup steps, common pitfalls, and monitoring techniques.
This article walks through a real‑world Oracle 19c RAC deployment on Red Hat 7.6, detailing the root.sh failure caused by a missing IPv6 ::1 entry, patch installation errors due to file permission problems, and step‑by‑step IPv6 network configuration to get the database fully operational.
This tutorial walks through verifying IPv6 support on Red Hat 7.6, configuring a static IPv6 address, updating the Oracle 19c listener for IPv6, restarting services, and confirming connectivity, providing concrete commands, configuration snippets, and screenshots for a RAC environment.
A detailed DBA interview walks through the diagnosis of excessive Oracle RAC GC wait events, revealing that cross‑instance queries, network latency, NIC bonding mode, and unbalanced IRQ handling together caused the slowdown, and shows step‑by‑step fixes that finally eliminated the problem.
This guide shows how to use SRVCTL commands and SQL queries to view the status of Oracle RAC databases, instances, services, node applications, ASM instances, and disk groups, as well as how to start and stop the entire RAC cluster safely.
This article provides a detailed comparison of Oracle RAC and MySQL MHA high‑availability solutions, covering architecture overviews, network requirements, failover methods, configuration examples, disaster‑recovery options, performance trade‑offs, and practical considerations for choosing the right approach.
This guide explains how to use SRVCTL to view the status of Oracle RAC databases, instances, services, node applications, and ASM instances, retrieve configuration details, start and stop the cluster, and perform backup and restore operations with concrete command examples.
This article provides a comprehensive guide to Oracle Listener, covering its core functions, how to operate it via lsnrctl commands on Windows, detailed configuration of listener.ora for static and dynamic registration, and best practices for ensuring high availability and load balancing.
This guide details the step‑by‑step process of moving a Windows‑based Oracle 11g RAC cluster to a Linux environment, focusing on building DataGuard between a single‑instance source and a RAC target, adjusting IPs, updating parameter files, handling tnsnames.ora, password files, RMAN backups, and finalizing the standby configuration.
This article outlines practical steps DBAs can take to prevent data leakage and loss, covering user and profile management, privilege minimization, audit logging, vulnerability patching, high‑availability solutions like RAC and Data Guard, and effective backup and recovery drills.
This article explains how to configure client‑side and server‑side Connect Time Load Balancing for Oracle RAC across versions, details the role of SCAN, local_listener and remote_listener settings, describes Runtime Connection Load Balancing with FAN and LBA events, and shows how to tune TCP timeout parameters.
A production Oracle RAC database on IBM Power8 experienced a severe hang due to incomplete checkpoints caused by a bug in index handling, and the detailed analysis, root‑cause identification, and three‑step remediation—including index rebuild, application isolation, and a hidden parameter tweak—ultimately restored full service.
An in‑depth look at Blizzard’s Hearthstone outage reveals that a power interruption likely triggered storage failures in an Oracle RAC cluster, leading to corrupted blocks, incomplete recovery, and a reliance on backups, while highlighting broader lessons on database backup, disaster recovery, and operational decision‑making.
This guide details how to move an Oracle 11.2.0.3.0 single‑instance database from Windows to a three‑node RAC on Linux using Data Guard, covering compatibility, required patches, configuration steps, parameter settings, and post‑migration tasks to ensure a fast, low‑downtime transition.
An Oracle DBA recounts how a full archive log halted business, how manual deletion uncovered a backup script failure caused by a mismatched SYS password across RAC nodes, and the steps taken to fix the issue and prevent future overflow.
This guide explains why Oracle databases hang, how to connect when sqlplus fails, and step‑by‑step commands—including ORADEBUG systemstate and hanganalyze dumps, level meanings, and RAC-specific tips—to collect diagnostic data for effective problem analysis.
This article details a step‑by‑step investigation of a two‑node Oracle RAC environment where node 2 repeatedly rebooted, covering time‑synchronization checks, database and network heartbeat analysis, hardware diagnostics, and the final resolution through firmware and memory replacement.
This article walks through eight frequent Oracle RAC installation errors—ranging from shared‑disk configuration and s0 partition misuse to VIP interface issues and ASM disk reuse—providing clear command‑line fixes and configuration tips for Linux administrators.
This guide explains why using a forced OS shutdown on an Oracle RAC cluster can leave services in an UNKNOWN state and provides a step‑by‑step, gentle procedure using crs_stat and srvctl commands to check status, shut down databases, ASM instances, and node services in the correct order, then restart them safely.
A tiny typo in an ifconfig command set all IPs to 0.0.0.0, causing an Oracle RAC 10.2.0.4 cluster on Solaris 10 to collapse instantly, illustrating the critical need for meticulous command‑level precision in system operations.
A colleague changed an Oracle application user's password, only to see the account lock every few minutes; the article walks through checking the database version, profile settings, listener logs, discovering a lingering dataSync.jar process that still used the old password, and outlines remediation steps.
This guide details the complete process of moving a 2‑node Oracle 11gR2 RAC database to new servers and storage using Active Physical Standby Data Guard, covering architecture, pre‑implementation preparation, detailed implementation steps, switchover procedures, impact assessment, rollback measures, and lessons learned.
This article explains how Oracle 12c's In-Memory feature enables hybrid OLTP/OLAP workloads by storing columnar data in a dedicated memory area, covering its architecture, data loading, consistency mechanisms, query acceleration techniques, and integration with RAC for high‑availability deployments.
This guide walks through adding ASM disks, creating an ACFS filesystem, building a RAC database on it, generating read‑only and read‑write snapshots while running DML, and cloning a second database from those snapshots, including optional Data Guard usage for zero‑impact testing.
On February 10, 2016 a provincial accounting database experienced severe daily‑batch delays despite other applications running normally; a senior DBA collected alert logs, AWR snapshots, ASH dumps, and OSW metrics, uncovered log‑file‑sync and redo‑IO degradation, increased rollbacks, and a faulty SAN link, pinpointing the root cause.
This technical session covers Oracle RAC high‑availability best practices, installation steps, daily operational commands, detailed case studies of auto‑start checks, version‑mix issues, addNode failures, network heartbeat problems, and client connection errors, plus a concise Q&A on uninstall, SCAN vs VIP, and split‑brain detection.
This article recounts a detailed troubleshooting journey of an Oracle 11gR2 RAC cluster where a newly added node could not start with SQLPLUS due to HAIP misconfiguration and mismatched environment variables, explaining the diagnostic steps, root cause discovery, and the final resolution.
This guide explains how Oracle's Trace File Analyzer (TFA) simplifies and accelerates log collection across single‑node and RAC databases, covering supported platforms, installation details, workflow, command usage, analysis features, and practical tips for permissions and configuration.
An Oracle RAC 11g installation on AIX failed intermittent queries with ORA‑04030 errors, and a deep dive revealed that missing shell limits for the grid user capped process memory at 128 MB, causing PGA allocation failures despite ample system resources.
This article details how to use PXE to automatically provision three‑node Oracle 11gR2 RAC clusters on bare‑metal servers, covering network planning, PXE server setup with a one‑click installer, required software download, MAC address collection, shared‑disk and node configuration, virtual tape library setup, time synchronization, and user creation.
The article recounts a hands‑on K‑DB experience event where participants migrated Oracle workloads, benchmarked K‑DB against Oracle using TPMC, explored the K‑RAC cluster feature, and shared detailed observations that highlight K‑DB's compatibility, performance, and stability in a real‑world setting.
