Oracle 11g Real Clusters for Administrators Training in Winnipeg, Canada

Enroll in or hire us to teach our Oracle 11g Real Clusters for Administrators class in Winnipeg, Canada by calling us @303.377.6176. Like all HSG classes, Oracle 11g Real Clusters for Administrators may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Oracle 11g Real Clusters for Administrators may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
This hands-on course teaches students all aspects of Oracle 11g RAC administration. Students will begin with a solid foundation in Oracle Clusterware and RAC architecture. Students will then install and configure both Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important topics such as failover, flashback, and backup and recovery are all covered in detail. Students will get hands-on experience with Automatic Storage Management. The course ends with troubleshooting and tuning a RAC system.
Course Length: 5 Days
Course Tuition: $2090 (US)

Prerequisites

Oracle 11g Database Administration and at least 6 months of administration experience recommended.

Course Outline

 

Cluster Architecture
Cluster Architecture
Shared Storage
Nodes and Interconnects
Oracle Cluster Registry (OCR)
The RAC Voting Disk
Virtual IP Addresses
SCAN Addresses and GNS
Oracle Software

Oracle Clusterware
What is Oracle Clusterware?
Oracle Clusterware Files
Oracle Clusterware Processes
The Grid Home
Oracle Clusterware Preinstallation Steps
Node Preparation
Configuring SSH User Equivalency
cluvfy – The Cluster Verification Utility
Installing the Grid Infrastructure
Oracle Clusterware Postinstallation Steps

Installing DB Software and Creating a RAC Database
Installation Overview
Configuring the OS Environment
Verifying System Readiness with the CVU
Installing the Database Software
Troubleshooting Installation Setup
Recommended Postinstallation Tasks
Database Pre-Creation Tasks
Creating a Cluster Database Using DBCA
Initialization Parameters
ORACLE_SID in a RAC Environment

RAC Database Architecture
Overview of RAC
Oracle Single-Instance Architecture
RAC Architecture
RAC Instances and Parameter Files
RAC Database Components
RAC Instance Background Processes
Global Resource Directory
Overview of Cache Fusion
Cache Fusion Components – GES and GCS
Cache Fusion Components – Resource Master and GRD
Application Connection to RAC

RAC Instance Management
Overview of RAC Instance Management
Starting and Stopping a RAC Database
Starting and Stopping a RAC Instance
Oracle® 11g Real Application Clusters for Administrators

RAC Database Identical Parameters
RAC Database Unique Parameters
Changing Parameter Values
Administering Undo Tablespaces in RAC
Administering Redo Logs in RAC

Managing Oracle Clusterware
About Oracle Clusterware
Adding and Removing Voting Disks
Backing Up and Recovering Voting Disks
The OCR
Changing the OCR Configuration
Adding and Removing an OCR Location
Backing Up and Recovering the OCR
Restoring from Automatic OCR Backups
Moving or Replacing the OCR
Repairing the OCR Configuration
Troubleshooting the OCR

RAC Utilities
The olsnodes Utility
The ocrcheck Utility
The ocrdump Utility
Querying Clusterware Resource Status
The crsctl Utility
The Server Control (SRVCTL) Utility
SRVCTL ADD
SRVCTL CONFIG
SRVCTL ENABLE and DISABLE
SRVCTL GETENV
SRVCTL MODIFY
SRVCTL RELOCATE
SRVCTL STATUS
SRVCTL REMOVE
SRVCTL START
SRVCTL STOP

Services
Overview of Services
Types of Services
Creating Services with srvctl
Preferred and Available Instances for Services
Using Services
Managing Services
Service Views
Tracing with Services

Failover
Transparent Application Failover (TAF)
Client-Side vs. Server-Side TAF
Configuring TAF on the Client
Using OEM to Configure TAF
Using srvctl to Configure TAF
The DMBS_SERVICE Package
Connecting to the Database with TAF
Monitoring TAF Connections

RAC Backup and Recovery
Overview of RAC Backup and Recovery
Log Archiving in RAC
Undo Tablespaces in RAC
Using Flashback Features in RAC
Deploying a Flash Recovery Area in RAC
Performing RMAN Backups of a RAC Database
Performing Non-RMAN Backups
Preparing to Restore and Recover with RMAN
Recover the RAC Database with RMAN
Recovering Without RMAN

Cluster Management
Overview of Cluster Management Tasks
Extending the Clusterware Home Directory
Extending the Database Software Home Directory
Creating the New Instance
Verifying the New Instance
Removing a Node

Automatic Storage Management
ASM Overview
ASMLib
Installing ASM

Creating an ASM Instance
ASM Initialization Parameters
Accessing an ASM Instance
ASM Startup and Shutdown
Creating a Disk Group
Changing a Disk Group
Oracle-Managed Files
Creating and Managing a Database
Creating and Managing a Tablespace
Creating and Managing Redo Logs
Creating and Copying Control Files
Backing up and Restoring Control Files
Creating and Managing Archive Logs
ASMCMD

ASM Backup, Recovery, and Migration
Overview of ASM Backup and Recovery
Overview of Recovery Manager (RMAN) and ASM
Migrating a Database to ASM
Migrating the Control File
Migrating the Database Files
Migrating the Online Redo Logs
Migrating SPFILEs

RAC Troubleshooting
The Oracle Clusterware Alert Log
Clusterware Component Log Files
Automatic Diagnostic Repository and ADRCI
Using crsctl to Diagnose Cluster Issues
Using diagcollection.pl
Checking Interconnect Settings
cluvfy – Verifying Clusterware Component Integrity
cluvfy – Verifying Cluster Registry Integrity
cluvfy – Verifying Cluster Integrity
ocrcheck – Verifying the Oracle Cluster Repository
RAC Database Alerts
The racdiag.sql Script
The oradebug Utility

RAC Tuning
RAC Tuning Methodology
Using Performance Views in RAC
Monitoring Cache Fusion
Global Cache Latencies
Monitoring Cache Transfers
OEM – Cluster Database Performance
OEM – RAC-Related Reports
Using AWR in the RAC Environment
Generating AWR Reports
Analyzing AWR Reports
Using ADDM in the RAC Environment
Analyzing ADDM Reports
RAC Tuning Tips and Best Practices

Appendix – Preparing a RAC Node
Checking the Hardware Requirements
Identifying Network Requirements
Configuring Operating System Users and Groups
Generating RSA and DSA Keys
Adding the Keys to an Authorized Key File
Configuring SSH User Equivalency
Configuring the Operating System Environment
Configuring the Network
Verifying the Network Configuration
Preparing the Operating System and Software
Configuring Installation Directories and Shared Storage
Choosing Directories

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.