Oracle Database 11g R2: RAC and Grid Infrastructure for Administrators

Overview

In this course, students will learn about the Oracle Grid Infrastructure products, including Oracle Automatic Storage Manager (ASM), ASM Cluster File System (ACFS) and Oracle Clusterware. Students will also learn to administer the Oracle Clusterware and storage products. Students will learn how to leverage the Oracle Clusterware to make applications highly available, supporting monitoring and failover to other nodes. Students will learn to troubleshoot the Oracle Clusterware by examining log files, enabling debugging, and enabling tracing for various utilities.

Students will learn how Oracle RAC works, the components necessary to create the RAC cluster, and RAC database administration in the Oracle Grid Infrastructure environment. This will include how to configure Cluster Ready Services (CRS), the Oracle Database instances, and Oracle Net in a RAC environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be studied.

The primary focus of this course is on architecture, installation, maintenance, and administration of Oracle 11gR2 RAC. This course is also available for Oracle 10g RAC.

Course Objectives

The “Oracle Database 11g R2: RAC for Administrators” course combines in-depth, hands-on technical training on Oracle database and clustering, to provide the student with a comprehensive ability to plan, configure and administer Oracle RAC for performance and high availability. After completing this class, the student will have learned skills necessary to configure and administer their Oracle 11g RAC database system. The student will learn the following:

  • Understand Oracle Clusterware architecture
  • Describe the Oracle Database 11g Grid Infrastructure
  • Prerequisites for creating an Oracle RAC
  • Configuring hardware and OS for RAC
  • Install and configure Grid Infrastructure and create RAC database
  • Administer the Oracle Cluster using Grid Control
  • Administer ASM Instances and disk groups
  • Administer ASM Cluster File Systems
  • Patching the Oracle cluster
  • Administer both Policy and Administrator managed RAC databases
  • Describe Oracle Database 11g RAC enhancements and new features
  • Describe Grid Plug and Play
  • Use Oracle Clusterware to make applications highly available
  • Configure and manage services in a RAC environment

Course Agenda

Grid Infrastructure Concepts

  • What is a Cluster
  • Grid Foundation Components
  • Oracle Clusterware Architecture
  • Oracle Clusterware Software and Storage
  • Describe ASM Architecture
  • Creating and Managing ASM Disk Groups
  • Creating and Managing ASM Cluster File systems

RAC Concepts

  • Understanding RAC
  • RAC Solutions
  • RAC Architecture
  • RAC Global Resources
  • Cache Fusion
  • RAC Configuration
  • RAC Installation Overview
  • Oracle Optimal Flexible Architecture (OFA) and 11g

Grid Infrastructure Installation and Configuration

  • Hardware Requirements and Configuration
  • OS Requirements and Prerequisites
  • Storage Options
  • Network Requirements
  • DNS and DHCP Configuration
  • Grid Plug and Play Considerations
  • Grid Naming Services
  • Single Client Access Names
  • Post installation tasks

Administering Oracle Clusterware

  • Managing Clusterware with Enterprise Manager
  • Determining the Location of the Oracle Clusterware Configuration Files
  • Backing Up and Recovering the Voting Disk
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups
  • Oracle Local Registry
  • Migrating OCR Locations to ASM
  • Managing Network Settings

Managing Oracle Clusterware

  • Prerequisite Steps for Extending a Cluster
  • Using addNode.sh to Add a Node to a Cluster
  • Rolling Patches, And Rolling Upgrades
  • Removing a Node
  • Installing A Patch With The opatch Utility

Oracle Clusterware High Availability

  • Oracle Clusterware high availability components
  • Contrasting policy-managed and administration managed databases
  • Server pool functionality
  • The Generic and Free Server Pools
  • Application placement policies
  • Application Virtual IPs
  • Managing application resources

Troubleshooting Oracle Clusterware

  • Oracle Clusterware Log Files
  • Gathering Log Files Using diagcollection.pl
  • Resource Debugging
  • Component-level Debugging
  • Troubleshooting the Oracle Cluster Registry

Administering ASM Instances

  • ASM Inialization Parameters
  • Starting and Stopping ASM Instances Using srvctl
  • Starting and Stopping ASM Instances Using ASMCA and ASMCMD
  • Starting and Stopping ASM Instances Containing Cluster Files
  • Starting and Stopping the Listener

Administering ASM Disk Groups

  • Creating And Deleting ASM Disk Groups
  • ASM Disk Group Attributes
  • ASM Disk Group Maintenance Tasks
  • Preferred Read Failure Groups
  • Performance And Scalability Considerations For ASM Disk Groups

ASM Files, Directories, and Templates

  • Using Different Client Tools to Access ASM Files
  • Fully Qualified ASM File Name Format
  • Creating and Managing ASM files, Directories and Aliases
  • Managing Disk Group Templates

Administering ASM Cluster File Systems

  • ASM Dynamic Volume Manager
  • Managing ASM Volumes
  • Implementing ASM Cluster File System
  • Managing ASM Cluster File System (ACFS)
  • ACFS Snapshots

Real Application Clusters Database Installation

  • Installing The Oracle Database Software
  • Creating A Cluster Database
  • Post–database Creation Tasks
  • Background Processes Specific to Oracle RAC

Oracle RAC Administration

  • Enterprise Manager Cluster Database Pages
  • Redo Log Files In A RAC Environment
  • Undo Tablespaces In A RAC Environment
  • Starting And Stopping RAC Databases And Instances
  • Initialization Parameters In A RAC Environment
  • Transparent Data Encryption and Wallets in RAC
  • Quiescing RAC Databases
  • Administration using Grid Control

Managing Backup and Recovery for RAC

  • Protecting Against Media Failure
  • Parallel Recovery in RAC
  • Archived Log File Configurations
  • RAC Backup and Recovery Using EM
  • Archived Redo File Conventions in RAC
  • Database Backup and Recovery with RMAN
  • Distribution of Backups
  • Flashback Technology

Services

  • RAC Service Architecture
  • RAC Fast Connection Failover and the Load Balancing Advisory
  • Configure and Manage Services in a RAC environment
  • Using Services with Client Applications
  • Using Services with the Database Resource Manager
  • Managing Services From the Command Line
  • Managing Services With Enterprise Manager

Design for High Availability

  • Designing a Maximum Availability Architecture
  • RAC Best Practices
  • Determine the Best RAC and Data Guard Topologies
  • Data Guard Broker Configuration files in a RAC Environment
  • Identifying Successful Disk I/O strategies

Hands-on Labs

(Lab systems are running Oracle Enterprise Linux 5.5 Operating System)

Lab 1: Verify the OS configuration
Lab 2: Install Oracle 11g Grid Infrastructure with ASM and Clusterware using ASM storage for OCR and Voting disk(s)
Lab 3: Configure ASM (ACFS and Disk Groups) using the ASM Configuration Assistant (ASMCA)
Lab 4: Install Oracle11g RAC Database
Lab 5: Create a RAC Database using the Database Configuration Assistant (DBCA)
Lab 6: Administer the RAC environment (Cluster, ASM, Database) using Enterprise Manager DB Console
Lab 7: Using Flashback Technology
Lab 8: Command line RAC administration using the following utilities:

  • OLSNODES
  • OCRCHECK
  • OCRCONFIG
  • OIFCFG
  • CRSCTL
  • SRVCTL

Lab 9: Patching the RAC Database

  • Install the current OPatch version
  • Apply the July 2010 CPU in a rolling upgrade fashion

Lab 10: Deinstall Oracle RAC

  • Remove the Oracle Database using DBCA
  • Remove the Oracle and Grid Infrastructure software using the Oracle 11g DEINSTALL utility

Prerequisites

  • A skill level equivalent to a working Oracle 9i or 10g database administrator (DBA), or familiarity with administering an Oracle 9i or 10g database instance
  • Basic UNIX/Linux operating system navigation skills, including the ability to use ls, cd, and pwd commands
  • Basic Oracle skills, including the ability to use sqlplus as well as how to find alert logs, configuration files

Delivery

For more information about scheduling this course or other offerings, please call us at: (800) 887-4513, or e-mail us at: This e-mail address is being protected from spambots. You need JavaScript enabled to view it.