Select Page

Oracle RAC Training

Oracle RAC Course

CURRICULUM

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