In this course, you will be introduced to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC). You will learn how to install and administer Oracle Clusterware, RAC, and Automatic Storage Management, and you will explore administering the Database in a RAC environment using Enterprise Manager Grid Control.

Your efficiency will increase as you learn how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. You will also discover how to add and remove nodes in clusters and how to patch both Oracle Clusterware and RAC software in a rolling fashion.

What You’ll Learn

  • Install Oracle Clusterware and RAC
  • Administer a RAC Database and Oracle Clusterware
  • RAC Performance Tuning
  • Configure, Manage, and Use Database Services in a RAC environment
  • Administer Oracle Clusterware
  • Diagnose Oracle Clusterware and Node Management
  • High Availability in RAC
  • Add/Remove a node to/from a cluster
  • Patch Oracle Clusterware and RAC software

Who Needs to Attend

Database administrators, consultants, and IT professionals who are interested in updating their Oracle skills

Prerequisites

  • General understanding of database administration
  • Oracle’s Database 11g: Administration Workshop I and Workshop II, or equivalent experience.

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Installation of Clusterware and RAC

  • Concepts related to RAC
  • Features and functions of RAC
  • Requirements and installation of Oracle Clusterware
  • Install Automatic Storage Management
  • Install Oracle database software and Enterprise Manager
  • Create a cluster database and perform the tasks needed after creating a cluster database
  • Install Automatic Storage Management and Oracle database software

2. RAC Database and Oracle Clusterware Administration

  • Use Enterprise Manager cluster database pages
  • Start and stop RAC databases and instances and back up settings
  • Modify initialization parameters in a RAC environment
  • Manage instances in a RAC environment, Oracle Clusterware, and resources
  • Functions of the voting disk and important CSS parameters
  • Steps you take to configure voting disks
  • Manage OCR files and locations
  • Procedure for changing VIP addresses
  • Use the CRS framework to register an application
  • Use RMAN in a RAC environment
  • Configure backup and recovery in RAC, and perform RAC backup and recovery using Enterprise Manager

3. RAC Performance Tuning

  • Instance recovery works in a RAC environment
  • Typical wait events and latencies for RAC
  • Most common RAC tuning tips
  • Factors that affect tuning in a RAC environment
  • Cluster Database Performance pages to monitor RAC database and cluster performance
  • RAC performance problems using ADDM and Enterprise Manager
  • Fix performance problems in RAC
  • RAC performance problems using Enterprise Manager

4. Configure, Manage, and Use Services in RAC

  • Role of services in a RAC environment and how to use distributed transactions with RAC
  • Create, manage, and modify services in a RAC environment
  • Use services with RAC client applications, Resource Manager, and the Scheduler
  • Set alert thresholds for a RAC service
  • Service aggregation and tracing in a RAC environment
  • Use Enterprise Manager and SRVCTL to manage services in a RAC environment

5. Diagnosing Oracle Clusterware and Node Management

  • Carry out diagnostics-related activities on Oracle Clusterware components
  • Enable debugging in RAC
  • Add a node to a RAC cluster
  • Add and delete nodes and instances in a RAC database

6. High Availability in RAC

  • Configure workload distribution features
  • Characteristics and benefits of Fast Application Notification
  • Configure server-side callouts
  • Use the Load Balancing Advisory and configure TAF
  • Download patch updates and set ASM preferred disks
  • How RAC and Data Guard provide protection during downtime
  • Function of the Oracle Data Guard Broker
  • How to perform rolling upgrades
  • Mirroring vs. striping configurations: which provides the best availability
  • Use extended RAC connectivity
  • Configure preferred mirror reads