Session 1: ORACLE REAL APPLICATION CLUSTERS OVERVIEW
- Oracle RAC Features
- Oracle RAC Technology Hierarchy
- Oracle RAC Capabilities
- Oracle RAC Components
- Tools for Installing, Configuring and Managing Oracle RAC
Session 2: ORACLE GRID INFRASTRUCTURE OVERVIEW
- Cluster Overview
- Grid Foundation Components and Architecture
- Oracle Clusterware Components and RAC
- Oracle Clusterware Software and Storage
- Oracle Storage Subsystems
- File Types used by a RAC Database
- Methods used to Share Database Files across a Cluster
- ASM Architecture
- Create and Manage ASM Disk Groups
- Create and Manage ASM Cluster Filesystems
- An Overview of RAC Services
- Network Requirements and Configuration
- Single Client Access Names
- Overview of Grid Plug and Play
Session 3: RAC INSTALLATION AND CONFIGURATION TASKS
- Oracle RAC Pre-installation Tasks
- Job Role Separation
- Create Oracle Groups, User Accounts and Directories
- Validate and Prepare the Hardware and the Operating System
- Configure RAC Nodes for Remote Access using SSH
- Configure the Network for RAC
- Configure the Startup Commands for the Oracle RAC Nodes
- Install and Configure ASMLIB
Session 4: INSTALL ORACLE GRID INFRASTRUCTURE AND REAL APPLICATION CLUSTERS
- Install the Oracle Grid Infrastructure
- Use the Cluster Verification Utility
- Install Oracle Database Software and Create a Cluster Database
- Verify the Installation
- Post Installation Tasks
- Configure Client Connections with Oracle Net Manager
- Convert an Oracle Database to a RAC Database
- Use the DBCA for Single Instance Conversion
- Use rconfig for Single Instance Conversion
- RAC Specific Background Processes
Session 5: RAC CLUSTER DATABASE AND DATABASE INSTANCE ADMINISTRATION
- Administer Oracle RAC using Enterprise Manager
- Policy Managed and Administrator Managed Databases
- RAC Initialization Parameters
- Manage Undo Tablespaces in a RAC Environment
- Manage Redo Log Files and Groups in a RAC Environment
- Oracle Enterprise Manager Cluster Database Pages
- Start and Stop Oracle RAC Databases and Instances
- Administer Database Storage
Session 6: ADMINISTER ORACLE CLUSTERWARE COMPONENTS
- CRS Resources and Daemon Functionality
- Manage Clusterware with Enterprise Manager
- CRSCTL Commands to Stop, Start and Administer Clusterware
- Backup and Recover Voting Disks
- Add and Remove Voting Disks
- The ocrcheck Utility
- The ocrdump Command
- Administer the Oracle Cluster Registry (OCR)
- Locate OCR Automatic Backups
- Backup and Restore OCR
- Troubleshoot the OCR with ocrcheck
Session 7: ASM INSTANCE ADMINISTRATION
- ASM Overview
- ASM Components in RAC
- ASM Initialization Parameters
- Create an ASM Instance using ASMCA
- Start and Stop an ASM Instance using srvctl
- Start and Stop an ASM Instance using ASMCMD and ASMCA
- Start and Stop an ASM Instance Containing Cluster Files
- Start and Stop the ASM Listener
Session 8: ASM DISK GROUP ADMINISTRATION
- Create and Delete ASM Disk Groups
- ASM Disk Group Attributes
- ASM Disk Group Maintenance Tasks
- Preferred Read Failure Groups
- ASM Disk Statistics
Session 9: RAC MANAGEMENT COMMANDS
- RAC Management Commands
- RAC Administration with SVRCTL
- SVRCTL Cluster Database Configuration Tasks
- SVRCTL Cluster Database Administration Tasks
- Check the Current Configuration
- SVRCTL Command Summary
- Administer Databases and Instances
- Administer Services and Node Applications
- Bring a Cluster Database online and offline
- Introduction to CRS
- Cluster Services
Session 10: MANAGING THE DATABASE WORKLOAD USING SERVICES
- Manage the Database Workload using Services
- Create and Administer Services in a RAC Environment
- Services and Client Applications
- Manage Services with Enterprise Manager and from the Command Line
- Configure Oracle Net to Support Services
- Configure Service Level Thresholds
- Configure Clients for Failover
Session 11: HIGH AVALABILITY OF CONNECTIONS
- RAC High Availability Framework
- Failure Detection with Cluster Services
- Oracle RAC and Hardware Failover
- Connection Failover
- Transparent Application Failover (TAF)
- Server, Client And Runtime Load Balancing
- Fast Application Notification (FAN)
- Server and Client Side Oracle Notification Services
Session 12: BACKUP AND RECOVER A RAC DATABASE
- Configure a Fast Recovery Area for use with RAC
- Tune Instance Recovery in RAC
- Parallel Recovery in RAC
- Initiate Archiving
- Configure RMAN Backup and Recovery Settings
- Backup a RAC Database using RMAN
- Restore and Recover a RAC Database using RMAN
- Display Backup Reports
- Best Practices and Tips for Backup and Recovery
Session 13: RAC PERFORMANCE TUNING
- Monitoring and Performance Guidelines
- RAC Monitoring Tools
- RAC Performance Recommendations
- Analyze Performance Issues
- Use the Automatic Workload Repository in RAC
- Use the Automatic Database Diagnostic Monitor in RAC
- Use Statspack with RAC
- Global Cache Services (GCS) Monitoring
- V$cache_transfer Views
- Monitor the GES Processes
- Monitor and Tune the RAC Cluster Environment using Enterprise Manager
Session 14: ADD AND DELETE NODES AND CLUSTERS
- Grid Plug and Play (GPnP)
- Prepare a New Node
- Extend the Oracle Grid Infrastructure Home to the New Node
- Extend the Oracle RAC Home Directory
- Add the New Node to the Cluster
- Create an Instance on the New Node
- Delete an Instance from the Cluster Database
- Remove a Node from the Cluster
Session 15: MANAGE ORACLE SOFTWARE AND APPLY PATCHES
- Configure the EM Patch Interface
- Obtain Patches
- Apply Rolling Patches to a RAC System
- Apply a Patchset with the opatch Utility
- Apply a Patchset with OUI