Oracle 11g Release 2 RAC & Grid Infrastructure Administration

Course Code: O11GRACR2

Duration: 5 days

 
 

Oracle 11g Release 2 RAC & Grid Infrastructure Administration Course Overview

This Oracle 11g Release 2 RAC & Grid Infrastructure Administration course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC) within the Oracle Grid Infrastructure environment.

Delegates will learn how to install and configure Oracle Clusterware in a RAC environment. Delegates will learn how to create, configure and administer a database for use with RAC within the Oracle Grid Infrastructure environment. Delegates will learn how to setup and use Automatic Storage Management (ASM).

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Course Objectives

The objectives of this Oracle 11g Release 2 RAC & Grid Infrastructure Administration course are to provide the skills needed to plan, implement, manage and troubleshoot Oracle Clusterware and RAC database configurations in an Oracle Grid Infrastructure environment.

Who will the Course Benefit?

This Oracle 11g Release 2 RAC & Grid Infrastructure Administration course is designed for experienced database administrators who are required to plan, implement and administer Oracle Real Application Clusters configurations for Oracle databases.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Installing and configuring Oracle Database 11g Release 2 Grid Infrastructure
  • Installing Oracle Database software
  • Creating a RAC Cluster Database
  • Administering and Monitoring a RAC database using Enterprise Manager and command line tools
  • Using configuration and management tools for RAC databases
  • Administering ASM using command line and GUI clients
  • Setting up services for workload management and application high availability
  • Backing up, restoring and recovering a RAC database
  • Monitoring and tuning the performance of a RAC database
  • Troubleshooting Oracle Clusterware

Oracle 11g Release 2 RAC & Grid Infrastructure Administration Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: ORACLE REAL APPLICATION CLUSTERS OVERVIEW

  • Overview of Oracle RAC
  • Oracle RAC Features
  • Oracle RAC Technology Hierarchy
  • Oracle RAC Capabilities
  • Oracle RAC Components
  • Oracle RAC One Node
  • Benefits of using RAC
  • 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

Oracle 11g Release 2 RAC & Grid Infrastructure Administration Training Course

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
  • Clean Up Failed Installations
  • Configure Client Connections with Oracle Net Manager
  • Convert a Single Instance Database to a RAC Database
  • Use the DBCA 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
  • Manage Sessions on RAC Databases
  • 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

Oracle 11g Release 2 RAC & Grid Infrastructure Administration Training Course

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 and ASMCMD and ASMCA
  • Administer ASM with the asmcmd Command Line Tool
  • Administer ASM with asmca

Session 8: ASM DISK GROUP ADMINISTRATION

  • Create and Delete ASM Disk Groups
  • ASM Disk Group Attributes
  • Flex ASM
  • 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
  • Database High Availability Best Practices
  • RAID Configuration for High Availability
  • Causes of Planned and Unplanned Down Time
  • Failure Detection with Cluster Services

Oracle 11g Release 2 RAC & Grid Infrastructure Administration Training Course

Session 12: RAC CACHE FUSION AND GLOBAL RESOURCE MANAGEMENT

  • Globally Managed Resources
  • Library Cache Management
  • Row Cache Cache Management
  • Buffer Cache Fusion
  • Management Requirements of the Buffer Cache
  • Use Result Caching
  • Access Single Blocks in RAC
  • Multi Block Read Considerations in RAC
  • Undo and Read Consistency Issues in RAC

Session 13: BACKUP AND RECOVER A RAC DATABASE

  • Instance Failure and Recovery in RAC
  • The LMON and SMON processes
  • Redo Threads and Archive Log Configurations and Administration
  • 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 14: RAC PERFORMANCE MONITORING AND TUNING

  • Monitoring and Performance Guidelines
  • RAC Monitoring Tools
  • RAC Performance Recommendations
  • OCPU and Wait Time Latches
  • Session and System Statistics
  • RAC Specific V$ Views
  • Analyze Performance Issues
  • Use the Automatic Workload Repository in RAC
  • Use the Automatic Database Diagnostic Monitor in RAC
  • Statspack and RAC
  • Monitor and Tune the RAC Cluster Environment using Enterprise Manager

Session 15: ORACLE CLUSTERWARE TROUBLESHOOTING

  • Overview of Oracle Clusterware Troubleshooting
  • Failed, Missing or Offline Cluster Resources
  • Oracle Clusterware Log Files
  • Troubleshoot the OCR and Voting Disk
  • Debug Resources
  • Debug a Component Level
  • CRS, CCS and EVM Components
  • Use Tracing on Java Based Tools

Oracle 11g Release 2 RAC & Grid Infrastructure Administration Training Course

Session 16: 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 17: MANAGE ORACLE SOFTWARE AND APPLY PATCHES

  • Overview of Upgrades and Patching
  • Release and Patch Set Upgrades
  • PSU, CPU and Patch Set Upgrade
  • Merge Patches
  • Out of Place Database Upgrades
  • Plan and prepare for Upgrade
  • Perform Out of Place Release Install and Upgrade
  • Apply a Patchset with the opatch Utility
  • Post Upgrade Tasks

Session 18: OVERVIEW OF RAC ONE NODE

  • Overview of RAC One Node
  • Online Database Migration
  • Add an Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC One Node Database to a RAC Database
  • Use the DBCA to Convert a Single Instance Database to a RAC One Node Database
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Requirements

A working knowledge of Oracle Database Administration is required, these skills can be obtained by attendance on the pre-requisite Oracle Database 11g Release 2 DBA - Part I and Oracle Database 11g Release 2 Backup & Recovery with RMAN courses.

This course is run on a Linux operating system, a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Pre-Requisite Courses

Course Reviews

A very relevant course given by an expert instructor. For me a very valuable 5 days!

Jack - Senior DBA - Insurance


An excellent course delivered by an outstanding tutor. Professionally delivered with clear understanding of deliverables and objectives. I can honestly say I have never learned as much nor enjoyed a course as much as this one in 20 years of IT experience.

Bryan - Database Administrator - Insurance


As always with StayAhead courses, the lecturer could call on a wealth of real life experience which helps the subject become more real. Once, again an excellent course!

Paul - DBA (trainee) - Government


One of the best courses I have attended with a very good knowledgeable instructor; I will definitely recommend.

Nigel - Oracle DBA - Government


Marian is a very friendly, knowledgeable and competent lecturer and it has been an absolute pleasure. Enjoyed this week very much.

Donna - Oracle DBA - Broadcasting


Instructor is very experienced and organised. I'm very happy with the course & content delivery.

Umair - DBA - Academic


Public Scheduled Events

Classroom & Live Virtual Instructor-Led Training

Duration: 5 days

Price: £2,250.00 exc. VAT 

Please contact us to review your requirements and schedule a date.

 

Live Virtual Classroom

 
Join live instructor-led classroom training from the comfort of your home or office.
All the convenience and benefits of the classroom experience without the hassle and costs of travel and accommodation.
 
 



Our Customers Include

 
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
 
 



Our Course Curriculum

 
 
 
 
Facebook LinkedIn Twitter Instagram E-Mail
 
+44 (0)20 7600 6116
Enquiries@StayAhead.com
Copyright © 2021 StayAhead Training Ltd
Cookies   /   Privacy Policy