Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2

What you will learn:

In this course, students will learn about the Oracle Grid Infrastructure products. This includes Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware. Students will also learn to administer the Oracle Clusterware and storage products using both command line utilities and graphical tools. Administration of ASM and ACFS will be done using both command line and graphical user interface clients. 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.

This course is based on Oracle Database 11g Release 2.

Learn To:

• Describe Oracle Database 11g Grid Infrastructure enhancements and new features
• Configure and manage ASM and ACFS
• Install and configure Grid Infrastructure
• Use Oracle Clusterware to make applications highly available
• Describe Grid Plug and Play
• Troubleshooting Grid Infrastructure

Audience: Data Warehouse Administrator
Database Administrators
Database Designers
Support Engineer
Technical Administrator

Suggested Prerequisites
Oracle Database 11g: Administration Workshop II Release 2
Oracle Database 11g: Introduction to SQL

Prerequisites: Oracle Database Administrator, Oracle Database 11g: Administration Workshop I Release 2

Next Course:

Relevant Certification:

Course Objectives:

• Understand Oracle Clusterware architecture
• Describe how Grid Plug and Play affects Clusterware
• Describe Automatic Storage Management (ASM) architecture
• Perform Grid Infrastructure installation and create RAC database
• Demonstrate Clusterware management proficiency
• Manage application resources
• Troubleshoot Oracle Clusterware
• Administer ASM Instances and disk groups
• Administer ASM Cluster File Systems

Course Topics:

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 Filesystems
Job Role Separation

Grid Infrastructure Installation and Configuration

Hardware Requirements
Network Requirements
DNS and DHCP Configuration
Grid Plug and Play Considerations
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
Comparing Software Versions With the Active Version
Installing A Patchset With the OUI Utility
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
High availability events

Troubleshooting Oracle Clusterware

Oracle Clusterware Log Files
Gathering Log Files Using diagcollection.pl
Resource Debugging
Component-level Debugging
Tracing For Java-based Tools
Troubleshooting the Oracle Cluster Registry

Administering ASM Instances

ASM Initialization Parameters
Adjusting ASM Instance Parameters in SPFILEs
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 ASM Listener

Administering ASM Disk Groups

Creating And Deleting ASM Disk Groups
ASM Disk Group Attributes
ASM Disk Group Maintenance Tasks
Preferred Read Failure Groups
Viewing ASM Disk Statistics
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
Managing ASM ACL With Command Line Utilities
Managing ASM ACL with Enterprise Manager

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
Using Command Line Tools To Manage ACFS