Español English

• Contacto
• Novedades
• Prensa
• Newsletters

• SAP
• ITIL
• SAP e-Distance Academy

Oracle Database 11g: RAC for Administrators

Course Overview

The course “Oracle Database: 11g RAC for Administrators” provides an introduction to the features of Oracle Real Application Clusters (RAC) as well as the tasks necessary to properly install, configure and maintain an Oracle RAC cluster. Students will learn how Oracle RAC works, the components necessary to create the RAC cluster and how to administer it. This will include how to configure Cluster Ready Services (CRS), the Oracle Database instances, and Oracle Net in a RAC environment.

Course Objectives

The “Oracle Database: 11g RAC for Administrators” course combines in-depth 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 maximize the performance of their Oracle RAC database system.

Course Topics cover

• Prerequisites for creating an Oracle RAC
• Configuring hardware and OS for RAC.
• Install Oracle Clusterware and Oracle RAC databases.
• Administering the Oracle Cluster using Grid Control.
• Administering the Oracle Cluster using Command Line Utilities.
• Adding and removing nodes from the cluster.
• Patching the Oracle cluster.

Audience

• Data Warehouse Administrators
• Database Administrators
• Support Engineer
• Technical Consultant

Prerequisites

The student must be familiar with Oracle 9i, or 10g database.

Course Agenda

RAC Architecture and Theory

• Intro to the class
• Oracle RAC introduction.
• Overview of Cluster Ready Services and Cache Fusion.
• Global Resources.
• Architecting an Oracle RAC database.

Storage, Hardware and OS

• RAC hardware prerequisites.
• Configuring the hardware for RAC.
• Configuring the OS for RAC.

Installing Oracle RAC

• Performing pre-installation tasks.
• Installing and upgrading Cluster Ready Services.
• Install and configure ASM.
• Installing and upgrading the Oracle Database Server in a RAC environment.
• Create the Oracle RAC database.
• Install the Grid Control Agent.

Oracle Administration

• Administer the Oracle RAC cluster with Grid Control.
• Start and stop the RAC instances with Grid Control and manually.
• Modify Oracle parameters for all RAC instances and individually.
• Add a node to the RAC cluster.
• Remove a node from the RAC cluster.

RAC Administration

• View the status of the cluster (manually).
• View the RAC configuration.
• Reconfigure the RAC cluster.
• Change VIP and interconnect addresses.
• Patch a node in the cluster.

Oracle Service and Workload Management

• Configure and manage Oracle Services.
• Set performance metric thresholds on services.
• Configure service aggregations.
• Configure load balancing.
• Use the Load Balancing Advisor.
• Configure ONS and TAF.

Backup and Recovery

• Configure RMAN with RAC.
• Configure the flash recovery area.
• Design a backup strategy for a RAC database.
• Backup the OCR and voting disks.
• Configure the voting disk for redundancy.

Troubleshooting

• Identify critical database log files.
• Identify critical RAC cluster log files.
• Review procedures for debugging a RAC cluster.

Best Practices and Tuning

• Review RAC best practices.
• Design a Maximum Availability Architecture configuration.
• Review ASM configurations and best practices.