SkillBuilders Welcome  |  Log in
All Oracle Classes

Oracle RAC, Grid Infrastructure and ASM Administration Training, Fast Track (Accelerated)

We Teach Oracle Oracle! - When Oracle Corp needs RAC training, they call SkillBuilders.

Oracle GI & RAC release 12c: RAC and Grid Infrastructure for Administrators Course
5 Day Onsite or 35 Hour Online Hands-On Training

In this course, you will learn to install and administer Grid Infrastructure, RAC Clustered Databases and Automatic Storage Management (ASM).

This is an accelerated (fast-track) class; students should expect after-hours work to successfully complete this class.  Please be sure to check the prerequisites carefully.

You'll learn about the Oracle Grid Infrastructure, RAC, Oracle Automatic Storage Management (ASM), ASM Cluster File System (ACFS), Grid Plug and Play (GPnP), Policy and Administror managed Resources, and the use of Flex Clusters and Flex ASM.

You will learn how to leverage the Oracle Clusterware to make applications highly available, supporting monitoring and failover to other nodes. You will learn to troubleshoot the Oracle Clusterware by examining log files, enabling debugging, and enabling tracing for various utilities.

The environment is a four node Linux cluster for each student, to be configured starting with nothing more than the operating system installed.

The primary focus of this course is on  installation, maintenance, and administration of Oracle Grid Infrstructure and RAC with command line utilities, through graphical tools may be used if desired.

 

 

Related Classes

Oracle RAC Administration (3 Days)

Oracle ASM Administration (2 Days)

Oracle Grid Infrastructure Administration (3 Days)

Free Tutorials

Oracle RAC Tutorial

Oracle Grid Infrastructure Tutorial

Oracle ASM Tutorial

Average Student Rating:

Grid Infrastructure modules

1. Grid Infrastructure Concepts

What is a Cluster

Grid Foundation Components

Oracle Clusterware Architecture

Oracle Clusterware Software and Storage

Describe ASM Architecture

ASM Disk Groups

ASM Cluster File systems

 

2. Grid Infrastructure Installation and Configuration

Hardware Requirements and Configuration

OS Requirements and Prerequisites

Storage Options

Network Requirements

The cluster interconnect

GNS, DNS and DHCP Configuration

Grid Plug and Play Considerations

The Grid Naming Service

Single Client Access Names

 

3. The Database Listener Model

The SCAN listeners and the node listeners

Database session connect time fault tolerance

Session load balancing

Runtime load balancing and fault tolerance

 

4. Administering Oracle Clusterware

Adding, Deleting, or Migrating Voting Disks

The Oracle Cluster Registry (OCR)

OCR Mirroring and Backups

The Oracle Local Registry

Migrating voting file and OCR to ASM

Managing Network Settings

 

5. Managing cluster resources

Stopping, starting, and relocating  resources

Registering third party applications  

Configuring dependencies between resources

Writing event handler scripts 

 

6. Managing an Oracle Cluster

Extending a Cluster

Rolling Patches, And Rolling Upgrades

Removing a Node

 

7. 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

 

8. Troubleshooting Oracle Clusterware

Oracle Clusterware Log Files

Gathering Log Files Using diagcollection.pl

Resource Debugging

Component-level Debugging

Troubleshooting the Oracle Cluster Registry

 

9. Flex Clusters

Hub and leaf nodes

Implement flex ASM

Convert from standard cluster to flex cluster

Set a node’s role and the hub node cardinality

Use server pools to provide HA for database instances and application servers

Using server categories to control pool membership

 

Database modules

 

1. RAC and Grid Infrastructure

Architectural summary

ASM and share storage

The SCAN and node listener model

RAC solutions


2. Real Application Clusters Database Installation

Installing The Oracle Database Software

Single Instance to RAC conversion

Creating A Clustered Database


3. Oracle RAC Administration

Redo Log Files In A RAC Environment

ndo Tablespaces In A RAC Environment

Starting And Stopping RAC Databases And Instances

Initialization Parameters In A RAC Environment


4. Managing Backup and Recovery for RAC

Protecting Against Media Failure

Archived Log File Configurations

Database Backup and Recovery with RMAN

Recovery following instance failure


5. Performance Tuning

The Tuning Methodology

The global cache and the global enqueue service

RAC Specific Statistics and Wait Events

Tuning Parallel Processing

RAC Specific Performance Issues

AWR and Statspack in a clustered environment


6. High availability and services

RAC Service Architecture

Configure and Manage Services in a RAC environment

Using Services with Client Applications

The fault tolerant architecture

Instance evictions

Policy managed databases and services

Stretched clusters

Maximum availability Architecture: RAC plus Data Guard



ASM modules

 

1. RAC and Grid Infrastructure

Architectural summary

Flex clusters

The ASM bootstrap

 

2. Administering ASM Instances

Administration privileges and the password file

ASM Initialization Parameters

Adjusting ASM Instance Parameters in SPFILEs

Starting and Stopping ASM Instances Using srvctl and other tools

Tuning and monitoring the ASM instance

 

3. Administering ASM Disks

Disk storage options: LUNs, directly attached storage, network attached storage

Using the ASMLib

Using the udev facility

 

4. Administering ASM Disk Groups

Creating And Deleting ASM Disk Groups

The importance of the RDBMS, ASM, and ACFS compatibilities

Placing the OCR and voting files on ASM devices

ASM Disk Group Maintenance Tasks

The various levels of redundancy

Templates for striping and mirroring

Hot and cold areas: exploit the geometry of the disks

Fast mirror resynch

choosing an allocation unit  size and a sector size

Preferred Read Failure Groups

Metadata backup and restore

Performance And Scalability Considerations For ASM Disk Groups

 

5. ASM Files, Directories, and Templates

Using Different Client Tools to Access ASM Files

Creating and Managing ASM files, Directories and Aliases

Applying templates to files

File extents, segment extents, and allocation units

Techniques for moving files within, into, and out of ASM

Security and Access Control Lists

 

6. Administering ASM Cluster File Systems

The ASM Dynamic Volume Manager

The ACFS file system driver

The ACFS bootstrap

Managing ASM Volumes: striping and mirroring

ACFS file system snapshots

ACFS  file system replication

ACFS file system encrption

The administration tools: srvctl, asmca, acfsutil, Unix utilities

 

7.  Flex ASM

Conversion from standard ASM to Flex ASM

Conversion from standard cluster to flex cluster

Configuring and using Flex ASM

The ASM network

The ASM listeners

Set the ASM instance cardinality

Relocate ASM instances and clients

The ADVM proxy service for ACFS in a Flex ASM environment

 

8. ASM, ACFS, and the database

Defining dependencies between a database and diskgroups

Defining dependencies between a database and file systems

Using ACFS for the database Oracle Home

Using ACFS to store database files

 

9. ASM in a non-clustered environment

The Grid Infrastructure Restart facility

Using ASM with single instance databases

 

10. Tools for interacting with ASM

sqlplus 

asmcmd

dbms_file_transfer

RMAN

FTP and HTTP

Clusterware Utilities: crsctl and srvctl

acfsutil

 
SkillBuilders Sample Video