Oracle Database 18c RAC and Grid Infrastructure Administration

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: ORACLE REAL APPLICATION CLUSTERS OVERVIEW

• Overview of Oracle RAC
• Oracle RAC Features
• Oracle RAC Technology Hierarchy
• Oracle RAC Capabilities
• Oracle RAC Components
• Oracle RAC One Node Overview
• Benefits of using RAC
• Tools for Installing, Configuring and Managing Oracle RAC

Session 2: ORACLE GRID INFRASTRUCTURE OVERVIEW

• Cluster Overview
• Flex Cluster Overview
• Grid Foundation Components and Architecture
• Oracle Clusterware Components and RAC
• Oracle Clusterware Software and Storage
• Oracle Storage Subsystems
• File Types used by a RAC Database
• Methods used to Share Database Files across a Cluster
• RAC Multitenant Database
• ASM Architecture
• Create and Manage ASM Disks Groups
• Create and Manage ASM Cluster Filesystems
• An Overview of RAC Services
• Network Requirements and Configuration
• Single Client Access Names
• Overview of Grid Plug and Play

Session 3: CONFIGURE SERVERS FOR INSTALLATION

• Oracle RAC Pre-installation Tasks
• Job Role Separation
• Create Oracle Groups, User Accounts and Directories
• Validate and Prepare the Hardware and the Operating System
• Configure RAC Nodes for Remote Access using SSH
• Configure the Network for RAC
• Configure the Startup Commands for the Oracle RAC Nodes
• ASM Storage Management Configuration Methods
• Configure ASM and the udev Device Manager
• Udev SCSI Rules
• Install and Configure ASMLIB
• ASM Filter Drivers (ASMFD)

Session 4: INSTALL ORACLE GRID INFRASTRUCTURE AND REAL APPLICATION CLUSTERS

• The Clusterware Role
• Requirements for Oracle Clusterware
• Pre-installation Steps
• The Voting Disk, OCR and GIMR
• Oracle Clusterware Installation Stages
• Install the Oracle Grid Infrastructure for a Cluster
• Use the Cluster Verification Utility
• Install Oracle Database Software and Create a Cluster Database
• Verify the Installation
• Oracle Clusterware Daemons and Log Files
• Clusterware Interconnect Best Practices
• Post Installation Tasks
• Clean Up Failed Installations
• TNS Configuration
• Convert a Single Instance Database to a RAC Database
• Use the DBCA for Single Instance Conversion
• RAC Specific Background Processes

Session 5: RAC CLUSTER DATABASE AND DATABASE INSTANCE ADMINISTRATION

• Administer Oracle RAC using Enterprise Manager
• Policy Managed and Administrator Managed Databases
• RAC Initialization Parameters
• Password File Management
• Manage Undo Tablespaces in a RAC Environmentc
• Temporary Tablespace Configuration
• Manage Redo Log Files and Groups in a RAC
• Oracle Enterprise Manager Cluster Database Pages
• Manage Sessions on RAC Databases
• Start and Stop Oracle RAC Databases and Instances
• Administer Database Storage

Session 6: ADMINISTER ORACLE CLUSTERWARE COMPONENTS

• CRS Resources and the Cluster Ready Services Stack
• Cluster Processes
• Use crsctl Commands to Stop, Start and Administer Clusterware
• Backup and Recover Voting Disks
• Add and Remove Voting Disks
• The ocrcheck Utility
• The ocrdump Command
• Administer the Oracle Cluster Registry (OCR)
• Locate OCR Automatic Backups
• Backup and Restore OCR
• Troubleshoot the OCR with ocrcheck

Session 7: ASM INSTANCE ADMINISTRATION

• ASM Management Overview
• ASM Storage Components in RAC
• Oracle Automatic Cluster File System (ACFS)
• ASM Initialization Parameters
• Creation an Ownership of an ASM Instance
• Administer ASM Instances and Disk Groups with EM
• Administer ASM Instances and Disk Groups with asmca
• Administer ASM Instances with srvctl
• Administer ASM with the asmcmd Command Line Tool

Session 8: ASM DISK GROUP ADMINISTRATION

• Create and Delete ASM Disk Groups
• Create ASM Data Files
• ASM Disk Group Attributes
• Flex ASM
• ASM Disk Group Maintenance Tasks
• Preferred Read Failure Groups
• ASM Disk Statistics
• ASM Storage Limits
• Tuning ASM Rebalance Operations
• ASM Disk Scrubbing
• Active Session History (ASH) for ASM

Session 9: RAC MANAGEMENT COMMANDS

• RAC Management Commands
• RAC Administration with svrctl
• svrctl Cluster Database Configuration Tasks
• svrctl Cluster Database Administration Tasks
• Check the Current Configuration
• svrctl Command Summary
• Administer Databases and Instances
• Administer Services and Node Applications
• Bring a Cluster Database online and offline
• Manage Application Resources
• Introduction to CRS
• Cluster Services
• What-if command line evaluation with eval

Session 10: MANAGING THE DATABASE WORKLOAD USING SERVICES

• Manage the Database Workload using Services
• Configure Services for High Availability
• Create and Administer Services
• Service Administration using EM Cloud Control
• Service Administration using srvctl
• Configure Oracle Net to Support Services
• Connection Failover
• Transparent Connection Failover
• Load Balancing
• Configure Service Level Thresholds
• Configure Clients for Failover
• Fast Application Notification (FAN)
• Fan Callouts
• Server and Client Side Oracle Notification Services

Session 11: HIGH AVALABILITY OF CONNECTIONS

• RAC High Availability Framework
• Database High Availability Best Practices
• RAID Configuration for High Availability
• Causes of Planned and Unplanned Down Time
• Failure Detection with Cluster Services
• Oracle RAC and Hardware Failover

Session 12: RAC CACHE FUSION AND GLOBAL RESOURCE MANAGEMENT

• Cache Fusion Overview
• RAC Locking Mechanism
• Buffer Cache Fusion Processing
• Oracle RAC Cache Fusion Accelerator
• Result Caching
• Library and Row Cache Management
• Management Requirements of the Buffer Cache
• Access Single Blocks in RAC
• Multi Block Read Considerations in RAC
• Undo and Read Consistency Issues in RAC

Session 13: BACKUP AND RECOVER A RAC DATABASE

• Overview of RAC Backup and Recovery
• Instance Failure and Recovery in RAC
• The LMON and SMON processes
• Redo Threads and Archive Log Configurations
• Configure a Fast Recovery Area for use with RAC
• Tune Instance Recovery in RAC
• Parallel Recovery in RAC
• Initiate Archiving
• Configure RMAN Backup and Recovery Settings
• Backup a RAC Database using RMAN
• Restore and Recover a RAC Database using RMAN
• Display Backup Reports
• Best Practices and Tips for Backup and Recovery

Session 14: RAC PERFORMANCE MONITORING AND TUNING

• Monitoring and Performance Guidelines
• RAC Monitoring Tools
• RAC Performance Recommendations
• Workload Partitioning
• CPU and Wait Time Latches
• Session and System Statistics
• RAC Specific V$ Views
• Analyze RAC Performance Issues
• Use OSWatcher
• Create a Monitoring Plan
• AWR and Statspack Reports
• Monitor RAC Cluster Interconnect Performance
• Cache Coherency Times
• RAC Wait Events of Interest
• Undesirable Global Cache Statistics
• Important RAC Wait Events
• Global Cache Wait Events
• Important Cache Fusion Views
• Monitor the GES Processes
• Monitor and Tune using Enterprise Manager

Session 15: ORACLE CLUSTERWARE TROUBLESHOOTING

• Overview of Oracle Clusterware Troubleshooting
• Hardware, Storage and Network Problems with RAC
• The Oracle Clusterware Alert Log
• Trace and Incident Files
• Other Diagnostic Data
• Failed, Missing or Offline Cluster Resources
• Oracle Clusterware Log File Locations
• The Clusterware Resource Activity Log
• The Diagnostics Collection Tool
• Troubleshoot the OCR and Voting Disk
• Debug Resources
• Debug a Component Level
• CRS, CCS and EVM Components
• Oracle Clusterware Troubleshooting Tools and Utilities

Session 16: ADD AND DELETE NODES AND CLUSTERS

• Grid Plug and Play (GPnP)
• Prepare a New Node
• Extend the Oracle Grid Infrastructure Home to the New Node
• Extend the Oracle RAC Home Directory
• Add the New Node to the Cluster
• Create an Instance on the New Node
• Delete an Instance from the Cluster Database
• Remove a Node from the Cluster

Session 17: MANAGE ORACLE SOFTWARE AND APPLY PATCHES

• Overview of Upgrades and Patching
• Patches and Patch Sets
• Obtain Patches
• Apply Rolling Patches to a RAC System
• Apply a Patch with the opatch Utility
• Upgrade the Oracle Software

Session 18: MULTITENANT ARCHITECTURE IN A RAC ENVIRONMENT

• Overview of Multitenant Architecture
• Create a RAC CDB and PDB
• Use the CDB and PDB Default Services
• Drop a PDB

Session 19: OVERVIEW OF RAC ONE NODE

• Overview of RAC One Node
• Online Database Migration
• Add an Oracle RAC One Node Database to an Existing Cluster
• Convert a Single Instance Database to a RAC One Node Database
• Convert an Oracle RAC One Node Database to a Complete RAC Database

Session 20: OVERVIEW OF QUALITY OF SERVICE MANAGEMENT

• Overview of Quality of Service Management (QOS)
• QOS Components
• QOS Functionality

Session 21: OVERVIEW OF APPLICATION CONTINUITY FOR JAVA

• Overview of Application Continuity (AC)
• AC Architecture
• AC Restrictions
• Application Requirements