I. Overview:

This course covers how to install, configure, and administer clusterware software when using the latest of release of Oracle Database (19c).
The course covers the following topics:

• Introduction to Clusterware
• Oracle Clusterware Architecture
• Cluster Configuration Options
• Grid Infrastructure: Preinstallation Tasks
• Grid Infrastructure Installation
• Managing Cluster Nodes
• Traditional Clusterware Management
• Policy-Based Cluster and Capacity Management
• Upgrading and Patching Grid Infrastructure
• Monitoring and Troubleshooting Oracle Clusterware
• Making Applications Highly Available with Oracle Clusterware.

II. Duration: 04 days (32 hours)

III. Objectives:

Learn how to:

• Configure a Standalone Flex Cluster
• Add a New Hub Node to the Cluster
• Create an additional ASM disk group
• Install RAC Database Software
• Create a RAC Database
• Start and Stop Oracle Clusterware
• Add and Remove Oracle Clusterware Configuration Files
• Perform Backup of the OCR and OLR
• Configure Network Interfaces Using oifcfg
• Work with SCANs, SCAN Listeners, and GNS
• Recover from Voting Disk Corruptions
• Configure and Use Policy-Based Cluster Management
• Work with CLUVFY
• Work with Cluster Health Monitor and Cluster Health Advisor
• Create and Manage Clusterware Resources and Resource Groups

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. Course outlines:

1. Introduction to Clusterware

• Introduction to Clusterware
• Oracle Clusterware Networking

2. Oracle Clusterware Architecture

• Oracle Clusterware Architecture
• Voting Disk Considerations
• Clusterware Startup Details: OHASD oraagent
• Practice 2-1: Laboratory Introduction

3. Cluster Configuration Options

• Cluster Configuration Options
• Oracle Member Cluster for Applications

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
• Practice 4-1: Preinstallation Tasks

5. Grid Infrastructure Installation

• Grid Infrastructure Installation
• Specify Installation Location
• Practice 5-1: Configuring a Standalone Flex Cluster Part01
• Practice 5-1: Configuring a Standalone Flex Cluster Part02

6. Managing Cluster Nodes

• Managing Cluster Nodes
• Deleting a Node from the Cluster
• Practice 6-1 and Practice 6-2
• Practice 6-3: Installing RAC Database Software
• Practice 6-4: Creating a RAC Database

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
• Practice 7-1 to Practice 7-3
• Practice 7-4 to Practice 7-6

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
• Practice 8-1: Configuring and Using Policy-Based Cluster Management

9. Upgrading and Patching Grid Infrastructure

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

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
• Practice for lesson 10

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
• Practice 11-1: Configuring highly available application resources
• Practice 11-2: Clusterware Resource Groups

12. Appendix A: Cleanup and Catchup Scripts

• Appendix A: Cleanup and Catchup Scripts lab part 1
• Appendix A: Cleanup and Catchup Scripts lab part 2