Introduction

• Introduction to Clusters
• Why cluster?
• Different Clustering Architectures
• Shared Nothing Clusters
• Shared Disk Clusters
• Shared Everything Clusters

Introduction to Oracle Real ApplicationClusters (RAC) 12c

• What is Oracle Real Application
• Clusters (RAC)?
• Benefits of Oracle RAC
• What RAC is NOT?
• History of RAC
• Tools & Utilities to manage RAC

Overview of Oracle RAC Infrastructure

• Overview of Infrastructure required to implement RAC
• Server & OS requirements
• Network requirements
• Storage requirements
• Software requirements

Overview of Oracle Clusterware

• What is Oracle Clusterware?
• About OCR & Voting Disks
• About Virtual IPs (VIP)
• Single Client Access Name(SCAN)
• SCAN VIPs
• SCAN Listeners
• SCAN and DNS server
• SCAN and host file
• Node Listeners

Oracle ASM Concepts

• Overview of Oracle ASM
• ASM Features & Advantages
• ASM Instance
• ASM Disks & ASM Disk Groups
• ASM Diskgroup Redundancy
• ASM Failure groups
• ASM Files
• ASM Extents & Allocation Unit
• Interaction between ASM Instance & RDBMS instance
• ASM Limits

Overview of Oracle 12c Flex Cluster & Flex ASM

• Oracle 12c Flex Cluster Architecture
• Hub Nodes & Leaf nodes
• Standard ASM
• Overview of Oracle 12c Flex ASM
• Flex ASM Architecture
• Oracle Flex ASM Clusters Network
• Oracle Flex ASM Listener
• Benefits of Flex ASM

Preparing for Oracle 12c Grid Infrastructure Installation

• Verifying System Requirements
• Configuring the Network
• Preparing the Operating System
• Configuring Users & Groups
• Configuring SSH
• Configuring Installation Directories
• Configuring Shared Storage
• Creating Oracle ASM Disks

Installing Oracle 12c Grid Infrastructure

• Verifying installation requirements withCluster Verification Utility
• Installing the Oracle Grid Infrastructure
• Verifying Oracle Clusterware Installation

Installing & Creating Oracle 12c RAC Database

• Creating required directories
• Installing Oracle 12c and Creating RACdatabase
• Verifying RAC Database Creation

Administering Oracle Clusterware

• Purpose of Oracle Clusterware (OCW)
• OCW Services & Processes
• OCW Resources
• Local & Cluster resources
• Understanding OCW Process Startup
• Managing Oracle Clusterware using CRSCTL & SRVCTL commands
• Starting & Stopping OCW
• Enabling & Disabling OCW
• Purpose of OCR & Voting Disks
• Managing OCR & Voting Disks
• OCRCHECK, OCRCONFIG,OCRDUMP
• Adding/Removing OCR Locations & Voting Disks
• Backup of OCR & Voting Disks
• Oracle Local Registry (OLR)
• Managing OLR

Administering Oracle 12c Flex Clusters

• Verifying Oracle Cluster mode
• Listing node roles
• Verifying ASM Cluster mode
• Listing ASM Instances & Listeners
• Testing ASM failure in Flex Cluster

Oracle Clusterware Diagnostic & AlertLog data

• ADR Directory Structure &ADRCI
• Oracle clusterware trace files and AlertLog file
• Normal trace files & Incident Trace files
• Collecting Oracle Clusterware
• Diagnostic data
• Diagnostics Collection Script

Cluster Health Monitor(CHM)

• Overview of monitoring Oracle Clusterware
• Cluster Health Monitor (CHM)
• Oracle 12c Grid Infrastructure Management Repository (GIMR)
• Collecting CHM data
• Managing CHM with OCLUMON

Using Cluster Verification Utility(CVU)

• About Cluster Verification Utility
• CVU command format & usage
• Using CVU for stage verification
• Using CVU to check cluster components

Administering ASM Instances

• Initialization Parameters for ASM Instances
• Parameter Files for ASM Instances
• Managing ASM Instance parameters
• Shared Oracle ASM Password File in aDisk group
• Starting & Stopping ASM Instances

Administering ASM Disk Groups

• Managing ASM Disk Groups with
• ASMCA& SQL Commands
• Creating Disk groups
• Altering Disk groups
• Adding & Removing Disks
• Mounting & Dismounting Disk Groups
• Dropping Disk Groups
• ASM Failure Groups

Administering ASM Directories & Files

• ASM Directory structure
• Managing ASM Directories
• ASM Files
• Fully Qualified File Names
• Alias File Names
• Incomplete File Names

ASM Command-Line Utility (ASMCMD)

• Types of ASMCMD commands
• Running ASMCMD in Interactive mode
• Running ASMCMD in Non-Interactive mode

Oracle RAC Architecture

• Instance in RAC
• Single Instance DB Vs RAC DB
• RAC specific Background processes
• Global Resources in RAC
• GCS, GES, GRD
• Cache Fusion in RAC

Administering RAC Instances & Database

• Overview of RAC DB Administration
• Starting and Stopping RAC Instances and Databases
• Terminating Sessions in RAC
• Initialization Parameters in RAC
• Data Dictionary in RAC
• Files in RAC
• Archiving in RAC
• Client connections in RAC

Backup & Recovery in RAC

• Configuring RMAN Snapshot Control
• File location
• Configuring Control File &SPFILE auto backups
• Configuring Channel connections inRAC
• Instance Recovery in RAC
• Media Recovery in RAC
• Parallel Recovery in RAC

Migrating File system Database to ASM

• Why migrate to ASM?
• Basic concepts of migrating to ASM
• Preparing to migrate to ASM
• Migrating Database to ASM

Converting Single Instance Database to RAC Database

• Overview of different Methods/Tools
• About rconfig utility
• Preparing XML file
• Converting to RAC using rconfig
• Verifying the conversion

Patching RAC Environments

• Patchset, Bundle Patch, One-Off Patch, Patchset Updates
• Rolling Patches, OPatch Utility
• Downloading &Analyzing Patches
• Installing RAC Patches in Rolling fashion
• Verifying Patch Application