Oracle Database 12c R2: Clusterware & RAC Admin Accelerated Ed 2

Suggested Prerequisite

• Working knowledge of Oracle Database 11g: Release 2 on Linux Operating System
• Working knowledge of Oracle Clusterware, ASM & RAC on Linux

Required Prerequisite

• Oracle Database 12c R2: ASM Administration Ed 2

Audience

• Technical Administrator
• Administrator
• Database Administrators
• Support Engineer
• Technical Consultant

Course Topics

1. Introduction to Grid Infrastructure

• Clusterware Characteristics
• What is a Cluster?
• What is a Flex Cluster?
• Oracle Clusterware
• Shared Storage Overview
• Hardware and Software Concepts (High level)

2. Installing Grid Infrastructure

• Verifying the Oracle Clusterware Installation
• Installing Oracle Grid Infrastructure
• Installing Flex Cluster

3. Policy-Based Cluster Management

• Server Categorization
• Policy-Based Cluster Management Overview
• Policy Set

4. RAC Databases Overview & Architecture

• RAC and Flex ASM
• Cluster-Aware Storage Solutions
• Scaleup and Speedup
• Overview of Oracle RAC
• Global Resources
• Benefits of Using RAC
• RAC One Node
• I/O Throughput Balanced

5. RAC Backup and Recovery

• Instance Failure And Recovery In RAC – LMON and SMON
• RMAN Admin For RAC: Channels, Instances, Backup Distribution
• Redo Threads and Archive Log Configurations and Admin
• RMAN Restore And Recovery RAC Considerations
• RAC and the Fast Recovery Area
• RMAN Configuration
• Parameter Settings Affecting Parallel Recovery and MTTR

6. Oracle Clusterware Architecture

• Configuring shared GNS
• Shared GNS Background and Architecture
• Clusterware Process Architecture
• Cluster Storage Requirements
• Clusterware Initialization and OHASD
• Moving GNS to Another Cluster
• Location Independent Names, Addresses and Name Resolution (GNS, SCAN, VIP..)
• Migrating to shared GNS

7. Managing Cluster Nodes

• Removing a Node from the Cluster
• Prerequisites for Running addNode.sh
• Adding a Node with addNode.sh
• Adding Oracle Clusterware Homes
• Configuring the node role

8. Patching Grid Infrastructure

• Rolling Patches
• OPatch Overview
• Types of Patches
• Obtaining Oracle Clusterware Patches
• Installing a Rolling Patch with OPatch
• OPatch Automation
• Out-of-Place Oracle Clusterware Upgrade
• Installing a Rolling Patchset with OUI

9. Installing and Configuring Oracle RAC

• Installing the Oracle Database Software
• Installation options
• Single Instance to RAC Conversion
• Creating the Cluster Database
• Post-installation Tasks
• Cleaning Up Unsuccessful Installs

10. RAC Global Resource Management and Cache Fusion

• Buffer cache fusion
• Accessing single blocks in RAC
• Row cache management
• Library Cache Management
• Multi-block read considerations in RAC
• Globally Managed Resources and Management
• Buffer Cache Management Requirements
• Undo and read consistency considerations in RAC

11. Application Continuity

• AC Architecture
• Side Effects
• Restrictions
• Benefits of AC
• What problem does it solve?
• What is AC?
• Application requirements
• How AC works

12. Oracle Database Exadata Cloud Service Overview

• Simple Web-Based Provisioning & Management
• Service Architecture & Availability
• REST APIs
• Storage Configuration & Management Details
• Management Responsibilities
• Service Configuration Options & Service Connection Options
• Migrating to Exadata Cloud Service
• Introducing Exadata Cloud Service

13. Flex Cluster Architecture

• Flex Cluster Architecture
• Configuring Flex Cluster
• Flex Clusters and Node Failure

14. Grid Infrastructure Pre-Installation Tasks

• Shared Storage for Oracle Clusterware
• Groups and Users
• Shell Settings
• Redundant Interconnect Usage
• Kernel Requirements
• Checking System Requirements
• Single Client Access Name for the Cluster
• Oracle Validated Configuration

15. Traditional Clusterware Management

• Network Administration
• Administering the Voting Disk file
• Clusterware Admin Tools Review
• Administering the Oracle Cluster Registry Disk file
• Oracle Clusterware startup and shutdown
• What-If Command Evaluation

16. Troubleshooting Oracle Clusterware

• Component level checks – cluvfy with -comp
• Troubleshooting Node Evictions
• Log files and Diagnostic Collection
• The oclumon Utility
• Cluster Health Monitor Enhancements Overview
• Resource Debugging – Java Tools and Dynamic Debugging
• Diagnostic Framework Support for CRS

17. Making Applications Highly Available

• Server Pools
• ONS and FAN overviews
• Overview of Using Oracle Clusterware to Enable HA
• Creating an Application VIP
• Overall flow diagram of HA lifecycle (crs_profile, crs_register, crs_start….)
• Resource Management Options
• Clusterware Resource Modeling
• Oracle Clusterware HA Components

18. Oracle RAC Administration

• Undo Tablespaces
• Use Enterprise Manager Cluster Database Pages
• RAC Alerts
• Parameters and RAC – SPFILE, Identical and Unique Parameters
• Session management on RAC instances
• Redo Threads
• Instance Startup, Shutdown and Quiesce
• RAC Metrics

19. RAC Monitoring and Tuning

• Common RAC Tuning
• RAC specific V$ Views
• Wait Events for RAC
• OCPU and Wait Time Latencies
• Session and System Statistics
• Automatic Database Diagnostic Monitor for RAC

20. Managing High Availability of Services in a RAC Environment

• Services for Policy – and Administrator-Managed Databases
• Creating Services
• Oracle Services
• Services and Transparent Application Failover
• Use Services with Client Applications
• Managing Services
• Services and Connection Load Balancing
• Services and the Resource Manager

21. Design for High Availability

• Database High Availability Best Practices
• Hardware Assisted Resilient Data
• RAC and Data Guard
• Maximum Availability Architecture
• Oracle’s Solution to Down Time
• RAID Configuration for High Availability
• Fast-Start Failover
• Causes of Planned and Unplanned Down Time