Preview unavailable

Course Materials

• Slides

• Lab Guide

Introduction to Oracle RAC

• Overview of Single Instance Database

• Overview of Oracle RAC

• Infrastructure requirements for RAC

Overview of Oracle Grid Infrastructure

• What is Oracle Grid Infrastructure?

• Storage Concepts - File System, Volume Manager, RAID

• Oracle ASM Concepts

• Oracle Clusterware Concepts

RAC Installation

• Overview of RAC Installation

• Roadmap to RAC Installation

Creating Node1 (Linux VM)

• Installing VirtualBox Software

• Creating the Virtual Machine (VM)

• 📖 Suggested Reading...

• Downloading Oracle Linux

• Planning Disk Partitions and IP Addresses for Installation

• Installing Linux

• Oracle Linux Post Install Configuration

Preparing Node1

• Overview of Prerequisites for Oracle Grid Infrastructure Software Installation

• How to Configure Prerequisites for Oracle Grid Infrastructure Software Installation?

• Configuring Prerequisites for Oracle Grid Infrastructure Software Installation

Creating Node2

• Cloning and Creating Node2

Creating Node3 (optional)

• Cloning and Creating Node3 (optional)

Configuring Shared Storage

• Planning of Shared Storage

• Creating the Disks to be used as Shared Storage

• Making the Disks Sharable

• Attaching the Disks to both Nodes

• Creating Partitions on the Disks

• Creating ASM Disks

Installing Oracle Grid Infrastructure Software

• Downloading Oracle Grid Infrastructure Software

• Extracting Oracle Grid Infrastructure Software

• Setup Oracle Grid Infrastructure Software

Installing Oracle Database Software

• Downloading Oracle Database Software

• Extracting Oracle Database Software

• Setup Oracle Database Software

Creating RAC Database

• Creating ASM Disk Groups required for RAC Database

• Creating RAC Database

Summary of the Installed System

• Summary of the Installed RAC System

Setting Environment Variables

• Setting Environment Variables

How to Start/Stop RAC Nodes?

• Starting/Stopping a Particular Node

• Starting/Stopping All Nodes

Administering Oracle Clusterware

• About Oracle Clusterware

• About Oracle Clusterware Startup

• About Managing Oracle Clusterware

• Lab Practice: Managing Clusterware Startup and Shutdown

• About Oracle Clusterware Resources

• Lab Practice: Managing Oracle Clusterware Resources

• Managing SCAN

• Managing Listeners

• Managing ASM Instances, RAC Database, RAC Database Instances

• Managing Voting Disks

• Lab Practices: Managing Voting Disks

• Managing OCR, OLR

• Lab Practices: Managing OCR, OLR

• Oracle Clusterware Diagnostic Data

• Cluster Verification Utility (CVU)

RAC Concepts

• Single Instance DB Vs RAC DB

• Global Resource Management in RAC

Administering RAC Database

• Tools for Administering RAC Database

• Starting and Stopping RAC Database

• Data Dictionary in RAC

• Managing Initialization Parameters in RAC

• Configuring Client Connections in RAC

Using Services in RAC

• Overview of Database Services

• Lab Practice: High Availability of Services

• Lab Practice: Transparent Application Continuity (TAC)

Applying Patches to RAC Database

• Overview of Patching RAC Database

• Listing Installed Patches

• About Grid Infrastructure Release Updates

• Downloading the Patches from MoS

• Links to download Patches

• Applying GI RU in Rolling Fashion

Converting to RAC

• Overview of Converting Single Instance Database to RAC

• Creating Single Instance Database

• Lab Practice: Converting to RAC

🆓 BONUS LESSON 1 (Self-study only): Using RMAN in RAC 🆓

• Using RMAN in RAC

🆓 BONUS LESSON 2(Self-study only): Adding New Node to RAC 🆓

• Creating New Node

• Configuring Prerequisites for Grid Infrastructure Installation

• Adding New Node to Cluster

• Extending Oracle RAC to New Node and Creating New Instance

🆓 BONUS LESSON 3(self-study only): Deleting Node from RAC 🆓

• Deleting Node from RAC

🆓 BONUS LESSON 4(self-study only): Upgrading RAC Database 🆓

• Creating Linux VM

• Configuring Prerequisites for GI Installation

• Clone and Create Second Node

• Configure Shared Storage

• Installing GI Software

• Installing Oracle Database Software

• Installing Mandatory Patches

• Creating RAC Database

• Upgrading Oracle Grid Infrastructure

• Upgrading RAC Database

🆓 BONUS LESSON 5(self-study only): ASM Administration 🆓

• Administering ASM Instance

• Administering ASM Disk Groups - Part1

• Administering ASM Disk Groups - Part2

• Administering Flex Disk Groups

• Using ASMCA

• Using ASMCMD

• Administering ASM Files and Directories

• ASM Diagnostic Data