My Oracle Support Banner

Top 11 Things to do NOW to Stabilize your RAC Cluster Environment (Doc ID 1344678.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

Many RAC instability issues are attributed to a rather short list of commonly missed Best Practices and/or Configuration issues.  The goal of this document it to provide a easy to find listing of these commonly missed Best Practices and/or Configuration issues with the hope to prevent instability caused by these issues.

Scope

This article applies to ALL RAC implementations.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1.  Apply the latest Patchset Update (PSU) to your environment
 2.  Ensure that UDP buffers are sized appropriately
 3.  Set DIAGWAIT to a value of 13 on all 10.2 and 11.1 Clusters
 4.  Implement HugePages on Linux Environments
 5.  Implement OS Watcher and/or Cluster Health Monitor
 6.  Follow Best Practices for OS settings
 7.  Ensure appropriate APARS are in place on AIX platforms to avoid Excessive paging/swapping issues
 8.  Apply NUMA Patch
 9.  Increase the Windows noninteractive Desktop Heap
 10.  Run ORAchk utility
 11. Implement NTP with slewing option
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.