This workshop is available for delivery at your location.
Objectives
The goal of this workshop is to learn how to deploy an Oracle 11g RAC environment based on an IBM POWER system running the AIX Operating System and GPFS for the storage needs. During this workshop, the instructor will describe the requirements, installation and configuration for a two node Oracle 11g RAC (cluster), as well as various administrative tasks such as managing the Oracle Clusterware and GPFS.
Description
The class will cover via a combination of lectures, discussion, and hands-on exercises the following topics:
+ Introduction
+ Why clustering
+ High availability
+ Scalability
+ Oracle type of cluster - shared storage type
+ Introduction to Oracle Clusterware (clustering infrastructure) and Oracle RAC
+ Networking options
- Ethernet
- EtherChannel
- InfiniBand
+ Storage access - Types of clusters supported on AIX:
- Single instance - file system, raw devices, ASM
- JFS2 and Direct/Concurrent I/O including tuning hints.
- RAC
- PowerHA with CLVM (Concurrent Logical Volume Manager)
- GPFS
- ASM
+ Storage requirements for Oracle Clusters are:
- Introduction to GPFS
- Storage for GPFS
- Parameters and Tuning options -- Oracle - Related
+ Oracle RAC on AIX Installation overview
- Platform preparation
- Remote command and copy programs (rsh/rcp, ssh/scp)
- Network configuration
- OS prerequisites
+ Oracle Clusterware installation steps -- also exercise
+ Oracle RAC installation high level --- also exercise + RAC DB creation
+ Using GPFS
- Advanced topics
- Storage pools
- GPFS recovery mechanism
- DR configurations
- Backup and restore w/ GPFS snapshots (Cloning DB)
+ Migration from PowerHA-based cluster to GPFS based cluster
+ IBM Power Infrastructure for RAC
- Power Systems
- Operating System
- Network
- Storage
- Supported configurations and features matrix
+ Licensing Oracle on Power Systems
+ Exercises:
1. Platform preparation
2. Setting up ssh
3. Installing and configuring GPFS
3. Installing and configuring CRS w/ testing
4. Installing RAC and DB creation
5. Configuring the network services using netca utility
6. Adding nodes to the Oracle Real Application Cluster
7. Managing Oracle Clusterware configuration
Prerequisites
AIX system administration, POWER hardware configuration, and Oracle experience are highly recommended.
Target Audience
IT specialists, IT support staff, IT architects, technical sales teams.