ORACLE 11G RAC TRAINING

ORACLE GRID INFRASTRUCTURE ARCHITECTURE

GRID INFRASTRUCTURE INSTALLATION

• Shared Storage Planning for Grid Infrastructure 2-4
• OCR and Voting Disk in ASM
• Checking System Requirements
• Checking Network Requirements
• Software Requirements (Kernel)
• Software Requirements: Packages
• Creating Groups and Users

ADMINISTERING ASM

• ASM Initialization Parameters
• Starting and Stopping ASM Instances by Using srvctl
• Starting and Stopping ASM Instances by Using SQL*Plus
• Starting and Stopping ASM Instances by Using ASMCA and ASMCMD
• Creating a New Disk Group
• Mounting and Dismounting Disk Groups
• Dropping Disk Groups
• kASM Dynamic Performance Views

REAL APPLICATION CLUSTERS DATABASE INSTALLATION

• Installing the Oracle Database Software 11-3
• Creating the Cluster Database 11-7
• Cluster Database Management Options 11-10
• Initialization Parameters 11-15
• Database Storage Options 11-16
• Create the Database 11-17
• Background Processes Specific to Oracle RAC 11-21
• Single Instance to RAC Conversion 11-23

ADMINISTERING ORACLE CLUSTERWARE

• CRSCTL : manages clusterware-related operations
• SRVCTL : manages Oracle resource�related operations

MANAGING ORACLE CLUSTERWARE

• Adding the Node in the Cluster
• Deleting the Node in the Cluster

TROUBLESHOOTING ORACLE CLUSTERWARE

• Golden Rule in Debugging Oracle Clusterware
• Oracle Clusterware Main Log Files
• Diagnostics Collection Script
• Cluster Verify Utility
• Determining Which Process Caused Reboot
• Using ocrdump to View Logical Contents of the OCR
• Checking the Integrity of the OCR
• OCR-Related Tools for Debugging

UPGRADING AND PATCHING ORACLE RAC

• Configuring the Software Library
• Setting Up Patching
• Obtaining Oracle RAC Patches
• Downloading Patches
• Reduced Down-Time Patching for Cluster Environments
• Rolling Patches

ORACLE RAC ADMINISTRATION

• Redo Log Files and RAC
• Automatic Undo Management and RAC
• Starting and Stopping RAC Instances
• Starting and Stopping RAC Instances with SQL*Plus
• Starting and Stopping RAC Instances with srvctl
• Terminating Sessions on a Specific Instance
• How SQL*Plus Commands Affect Instances

MANAGING BACKUP AND RECOVERY FOR RAC

• Protecting Against Media Failure
• Media Recovery in Oracle RAC
• Parallel Recovery in RAC
• Archived Log File Configurations
• RAC and the Fast Recovery Area

RAC DATABASE MONITORING AND TUNING

• CPU and Wait Time Tuning Dimensions
• RAC-Specific Tuning
• RAC and Instance or Crash Recovery
• Instance Recovery and Database Availability
• Instance Recovery and RAC
• Analyzing Cache Fusion Impact in RAC
• Typical Latencies for RAC Operations
• Wait Events for RAC
• Wait Event Views
• Global Enqueue Waits: Overview

SERVICES

• Oracle Services
• Services for Policy- and Administrator-Managed Databases
• Default Service Connections
• Create Service with Enterprise Manager
• Create Services with SRVCTL
• Manage Services with Enterprise Manager
• Managing Services with EM
• Manage Services with srvctl

DESIGN FOR HIGH AVAILABILITY

• Oracle Services
• Services for Policy- and Administrator-Managed Databases
• Default Service Connections
• Create Service with Enterprise Manager
• Create Services with SRVCTL
• Manage Services with Enterprise Manager
• Managing Services with EM
• Manage Services with srvctl