I. Overview:

The Oracle Database 19c Clusterware Administration Workshop is a 3-day course designed to give experienced Oracle Database administrators a comprehensive understanding of Oracle Clusterware and its interaction with the Real Application Clusters option. Attendees will gain the knowledge and skills necessary to install, configure, and maintain Oracle Clusterware and Real Application Clusters in both an Oracle Grid Infrastructure and Oracle Database 19c deployment.

The course provides step-by-step instructions on Oracle Clusterware installation, Autonomous Health Framework deployment and configuration, Oracle Flex Clusters, creating and managing Oracle RAC databases, backup and recovery, and monitoring Oracle Clusterware and Oracle RAC databases. The course is broken down into nine modules which progressively build upon the preceding one:

1. Clusterware and Oracle RAC overview
2. Installing and Configuring Oracle Clusterware
3. Autonomous Health Framework Configuration
4. Oracle Flex Clusters
5. Oracle RAC Database Creation
6. Monitoring and Performance Tuning
7. Backup and Recovery
8. High Availability Solutions
9. Troubleshooting Oracle Clusterware and Oracle RAC

This course enables attendees to gain an in-depth understanding of Oracle Grid Infrastructure and the Oracle Real Application Clusters architecture, so that they can expertly and efficiently manage an Oracle Clusterware environment. By the end of the workshop, attendees will have the ability to install, operate, and maintain Oracle Database 19c in an Oracle Clusterware environment, using the industry best practices.

II. Duration:

03 days (32 hours)

III. Objectives:

This Oracle Database 19c: Clusterware Administration Workshop Training enables participants to develop the skills necessary for administering Oracle Grid Infrastructure for a cluster and managing high availability in an Oracle Real Application Clusters (Oracle RAC) environment. Participants will have the ability to configure a cluster and the components used to protect clusters from server failure. Upon completing this course, participants should have a good understanding of the parameters necessary for setting up a cluster and easily recognize potential cluster related problems and implementation clues. Additionally, learners will be able to install and configure Oracle Clusterware, implement best practices for cluster health monitoring, maintain and troubleshoot cluster activities, configure and manage resources and services, and maintain overall cluster performance.

IV. Intended Audience:

This Oracle Database 19c: Clusterware Administration Workshop training is best suited for Oracle database administrators, software and hardware engineers, system administrators, technical consultants and people in support roles who are responsible for deploying, administering and troubleshooting Oracle 19c Clusterware on various operating systems

Additionally, individuals who are responsible for managing and monitoring databases using Oracle Database 19c Cloud Control or Enterprise Manager will benefit from the workshop

This workshop is also helpful for those who have just finished taking the Oracle 19c Clusterware Administration I and II courses or those needing a refresher on Oracle Clusterware

V. Prerequisites

There are no prerequisites for the Oracle Database 19c Clusterware Administration Workshop training. The topics covered in this training are applicable to all versions of Oracle Database, including 19c.

VI. Course outlines:

Module 1: Oracle Clusterware Architecture

• Oracle Clusterware Architecture
• Voting Disk Considerations
• Clusterware Startup Details: OHASD oraagent

Module 2: Introduction to Clusterware

• Introduction to Clusterware
• Oracle Clusterware Networking

Module 3: Cluster Configuration Options

• Cluster Configuration Options
• Oracle Member Cluster for Applications

Module 4: Grid Infrastructure: Preinstallation Tasks

• Grid Infrastructure: Preinstallation Tasks
• Enabling the Name Service Cache Daemon (nscd)
• Private Interconnect Network Requirements
• Oracle Linux with the Unbreakable Enterprise Kernel

Module 5: Grid Infrastructure Installation

• Grid Infrastructure Installation
• Specify Installation Location

Module 6: Managing Cluster Nodes

• Managing Cluster Nodes
• Deleting a Node from the Cluster

Module 7: Traditional Clusterware Management

• Traditional Clusterware Management
• Checking the Integrity of Oracle Clusterware Configuration Files
• Restoring the OCR on Linux or UNIX Systems
• Oracle Local Registry
• SCAN Listeners and Valid Node Checking

Module 8: Policy-Based Cluster and Capacity Management

• Policy-Based Cluster and Capacity Management
• Moving Servers Between Server Pools
• Policy-Based Cluster Management and QoS Management

Module 9: Upgrading and Patching Grid Infrastructure

• Upgrading and Patching Grid Infrastructure
• Completing a Clusterware Upgrade When Nodes Become Unreachable
• OPatch: Overview

Module 10: Monitoring and Troubleshooting Oracle Clusterware

• Monitoring and Troubleshooting Oracle Clusterware
• oclumon Utility
• CHA Key Performance and Workload Indicators
• Cluster Resource Activity Log (CALOG)
• Rebootless Node Eviction

Module 11: Making Applications Highly Available with Oracle Clusterware

• Making Applications Highly Available with Oracle Clusterware
• Using Clusterware to Enable High Availability
• Deciding on a Deployment Scheme
• Resource Group: Overview