Are you implementing Oracle RAC or Oracle Grid Infrastructure for the first time? Are you an experienced RAC or Oracle Clusterware user, but want feedback on the latest knowledge and Best Practices? This blog is intended to give you insights into the quickest way to find information about RAC, Oracle Clusterware and Oracle Grid Infrastructure. The contents of this blog replicate the data found in the My Oracle Support Master Note#1096952.1 for Oracle RAC, Oracle Clusterware and Oracle Grid Infrastructure.
This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Real Application Clusters, Oracle Clusterware and Oracle Grid Infrastructure implementations. This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest, within the RAC, Clusterware and Grid Infrastructure spaces. This includes the following categories:
Oracle Real Application Clusters (RAC) is a cluster database with a shared cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches to provide a highly scalable and available database solution for all your business applications. Oracle RAC provides the foundation for enterprise grid computing.
Oracle Clusterware is a portable cluster software that allows clustering of single servers so that they cooperate as a single system. Oracle Clusterware provides the required infrastructure for Oracle Real Application Clusters while also enabling high availability protection of any Oracle or third party application.
Oracle Automatic Storage Management (ASM) provides a virtualization layer between the database and storage. It treats multiple disks as a single disk group, and lets you dynamically add or remove disks while keeping databases online. ASM greatly simplifies the storage complexities often associated with an Oracle database while increasing availability and performance of the database.
With Oracle grid infrastructure 11g release 2 (11.2), Oracle Automatic Storage Management (Oracle ASM) and Oracle Clusterware are installed into a single home directory, which is referred to as the Grid Infrastructure home. The installation of the combined products is called Oracle Grid Infrastructure. However, Oracle Clusterware and Oracle Automatic Storage Management remain separate products.
This note applies to the following versions of these products:
Oracle Clusterware - Version 10.1.0.2 to 18.104.22.168
Oracle Grid Infrastructure - Version 11.2.0.x
Oracle Real Application Clusters - Version 10.1.0.2 to 11.2.0.x
Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure
The goal of the Oracle Real Application Clusters (RAC) Starter Kits are to provide the latest information on generic and platform specific best practices for implementing an Oracle cluster using Oracle Clusterware or Oracle Grid Infrastructure (11gR2) and Oracle Real Application Clusters. These documents are compiled and maintained based on Oracle Support's ongoing experience with its global RAC customer base. The process used to install, configure, and create an Oracle Cluster and an Oracle Real Application Clusters (RAC) database shares much in common across all supported operating system platforms. Despite these commonalities, many aspects of the deployment process are O/S specific. As such, there is a Generic Starter Kit, as well as a separate Starter Kit for each supported platform. These Starter Kits provide the latest information in terms of installation help, as well as best practices for ongoing/existing implementations.
The Generic Starter Kit has attached documents with sample test plan outlines for system testing and basic load-testing to validate the infrastructure is setup correctly, as well as a sample project plan outline for your RAC implementation. In addition, best practices for Storage and networking and other areas are included. The Platform-specific Starter Kit notes complement this with Step-by-Step Installation Guides, for each particular platform, as well as best practices for the specific platform in question.
Additional Notes on RAC and Clusterware Installation and Frequently asked Questions
While the Starter Kits referenced above will contain much of what you need to get started, additional notes and resources that are important to take heed of, particularly for a new implementation, can be found here in the following FAQ's and other references:
Key notes related to OS Installation requirements for a RAC or Oracle Clusterware environment
Key notes introducing differences in Oracle 11gR2
To effectively manage your RAC cluster, it is important to know how to monitor, troubleshoot and collect data, both for your own diagnosis, and also to provide supporting information when logging a service request. The following Notes will give you information on how to do both:
Tools for Monitoring RAC and Clusterware Environments
Much of RAC performance tuning is no different from "single instance" tuning. However, there are some additional areas to check in a RAC environment when tuning or troubleshooting performance related issues. The following notes will make you aware of some of the areas where performance tuning and diagnosis has a specific RAC flavor:
Maintenance of a RAC environment is similar in many respects to maintaining a single-instance environment. However, with the Clusterware and Grid Infrastructure stacks, there are some additional tasks to be aware of regarding ongoing maintenance, as well as maintenance that may be brought on by changes to your environment. Below are some references speaking to the areas of general maintenance that may be needed or affect RAC environments in a particular way, as well as references to patching, which is a key part of an ongoing maintenance strategy.
Certification References for RAC and Clusterware Environments
General Maintenance References for RAC and Clusterware Environments
Patching Best Practices and References for RAC and Oracle Clusterware
As part of an overall maintenance strategy, it is critical that customers have a formal strategy to stay in front of known issues and bugs. To make it easier for customers to obtain and deploy fixes for known critical issues please refer to the following list of references.
When migrating a RAC cluster to a new platform or upgrading a RAC cluster from an older version of Oracle to the current version of Oracle, the following references will be helpful:
Automatic Storage Management (ASM) is an evolution in file system and volume management functionality for Oracle database files. ASM further enhances automation and simplicity in storage management that is critical to the success of the Oracle grid architecture. ASM also improves file system scalability and performance, manageability and database availability for RAC environments. Use of ASM with RAC is an Oracle Best Practice.
Data Guard provides the management, monitoring, and automation software infrastructure to create and maintain one or more standby databases to protect Oracle data from failures, disasters, errors, and data corruptions. As users commit transactions at a primary database, Oracle generates redo records and writes them to a local online log file.
Keywords and search terms: RAC, ASM, CRS, Cluster, Clusterware, DB Machine, Exadata, GI, Grid, Infrastructure, OCR, Oracle, RAC, Votedsk, votedisk, 'Voting Disk', ohasd, ocssd, crsd, evmd, srvctl, crsctl, 'Grid Infrastructure', 'Real Application Clusters', HA, Scalability, ACFS, ADVM
*** - For reference to the content in this blog, and for the latest and most up to date information, refer to Note:1096952.1 Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure