Home
Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions
DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Oracle Forms
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers
Fusion Middleware Series
Oracle Application Server
Oracle Identity Management
Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi
Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
New Objects
Partitioning
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
11gR1 Real
Application Clusters (RAC)
|
|
...
Next dates May 21-23 ...
|
The purpose of Oracle RAC is:
- Maximum availability
through elimination of the server as a single point of
failure
- Transparent application
failover
- Server-side load
balancing
- Incremental scaling
- Increased flexibility
- Lower initial cost
- Faster return on
investment
|
|
...
REGISTER ...
only $1,495 for 3 days
|
The PSOUG's RAC class is part
of our Maximum Availability series and is presented as
either a 2 day class using Network Appliance's cluster
file system and a 3 day class with RAW devices and
ASM.
How is PSOUG's RAC class different, and we think better,
than anyone else's? Because we minimize the slide-show and
maximize hands-on experience. All student's install the
operating system, configure kernel parameters, configure
SSH, install clusterware, install the database, add nodes,
subtract nodes, tail files, and learn the tools. The syllabus, below,
shows the topics covered as well as the fact that this
class is hands-on: Not slow death by PowerPoint.
|
|
|
|
Day 1
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
| 9:00-10:00am |
Discussion 1 |
RAC Concepts and Architecture
A discussion of RAC and high availability concepts and architecture. |
| 10:00-10:15am |
Lab 1 |
Network Configuration
A discussion of networking for RAC. The discussion includes Class A, B, and C networks, submasks,
and the assignment of IP and Virtual IP address for RAC clusters. |
| 10:15-11:15am |
Lab 2 |
Operating System Installation and Configuration
Working with Oracle Unbreakable Linux 4 each student will perform a hands-on
installation of the operating system on their own server. |
| 11:15-12:00pm |
Lab 3 |
Configuring the Operating System for Oracle Clusterware
The Linux operating system normally requires configuration for the Oracle database. This lab includes the standard
kernel configurations plus those configurations, including SSH, required for Clusterware and RAC. |
| 1:00-1:20pm |
Discussion 2 |
Cluster Enabled
Hardware and Storage
Most RAC cluster installations fail not due to Oracle software
but due to errors in purchasing the correct hardware: Especially
networking and storage. This discussion covers ASM, iSCSI, NAS,
NFS, OCFS, OCFS2, RAW, SANs, storage planning and other critical
aspects of selecting a storage solution. |
| 1:20-1:40pm |
Discussion
3 |
Oracle Clusterware
With version 11gR1 Oracle provides the clusterware. This discussion covers the clusterware, the CRS home, the CRSCTL
tool, Voting Disks, the Oracle Cluster Registry (OCR) CRS Daemon processes, and the NodeApps. |
| 1:40-2:10pm |
Lab 4 |
Clusterware Installation
Hands-on installation of Oracle Clusterware and the Cluster Verify utility. |
| 2:10-2:25pm |
Lab 5 |
Installation of
Oracle Database Software
Install of the Oracle binaries in preparation of creating a cluster database. |
| 2:25-2:30pm |
Lab 6 |
Network
Configuration Assistant (NETCA)
Listener configuration for RAC. |
| 2:30-3:00pm |
Lab 7 |
Create RAC Database
Create a RAC database with DBCA specifying nodes, shared
storage, failover services, and startup parameters |
| 3:00-4:00pm |
Lab 8 |
Verify Cluster Database
Time to see if we have working clusters. We will use CRS_STAT, SRVCTL, LSNRCTL, and SQL*Plus to verify cluster integrity,
start and stop the database and individual nodes, test listener load balancing, and test transparent failover. |
| 4:00-4:30pm |
Lab 9 |
Post Installation Tasks
Learn to backup the voting disk and OCR, backup the root.sh script, install and configure other Oracle products, and
disable unnecessary services. |
|
|
Day 2 |
| 9:00-9:30am |
Discussion 4 |
RAC Internals
Discussion of cache fusion, global cache services (GCS), RAC
specific Oracle processes, resource coordination, and lock
modes. |
| 9:30-10:00am |
Discussion
5 |
RAC Best Practices
Discussion of achieving High Availability, change management,
destructive testing, fencing, extended RAC, rolling upgrades,
and more. |
| 10:00-10:45am |
Lab 10 |
Verify Cluster Database Files
A hands-on exploration of a RAC database's data files, alert
log, initialization file, network configuration files,
ClusterWare configuration files, and ClusterWare logs. |
| 10:45-11:30am |
Lab
11 |
Monitoring and Managing Services
A hands-on exploration of cluster management tools including CRS
Control (CRSCTL), CRS Status (CRS_STAT), Server Control (SRVCTL),
Interface Configuration Tool (OIFCFG), Listener Control (LSNRCTL),
Cluster Verification (CLUVFY), and OCR utilities. |
| 11:30-12:00pm |
Lab
12 |
Failover Tracing
In this lab we trace a failover in real time identifying key
trace information, connect to a TAF service, determine which
node gets a connection, tail log files, learn to startup and
shutdown an instance, and ping virtual IP addresses. |
| 1:00-1:45pm |
Discussion 6 |
Workload Management
A discussion of connection balancing, workload balancing,
session failover, Fast Application Notification (FAN)), Fast
Connection Failover (FCF), and how to restart failed components. |
| 1:45-2:30pm |
Lab 13 |
Node Management
A hands-on lab where we start and stop the various layers of a
cluster including the entire database, individual nodes, single
instances, listeners, nodeapps, and clusterware. |
| 2:30-3:00pm |
Lab 14 |
Instance Monitoring
A hands-on lab where we practice instance monitoring in a RAC cluster. |
| 3:00-4:30pm |
Lab
15 |
Adding and Removing
Nodes
We turn our four 2 node clusters into two 4 node clusters adding
and dropping nodes. |
|
|
Day 3 |
| 8:30-9:30am |
Discussion
7 |
ASM Concepts and
Architecture Discussion
Discussion of the concepts and architecture of Oracle's
Automatic Storage Management technology. |
| 9:30-9:45am |
Lab
16 |
ASM Pre-Installation
Shutdown existing RAC databases and verify the CRS is still
running. |
| 9:45-10:30am |
Lab
17 |
Install and Configure iSCSI
Install iSCSI device driver for RedHat Linux onto each server. |
| 10:45-11:10am |
Demo. |
Prepare Storage Device for iSCSI
Live instructor demo on our NetApp 720 creating volumes, QTrees,
LUNs, initiator groups, and maps to create the six mount points
required for database installation. |
| 11:10-12:00pm |
Lab
18 |
Format RAW Devices
Students mount the LUNs from their Linux servers and format them
as raw devices using fdisk. |
| 1:00-1:30pm |
Lab 19 |
Install and Configure ASM Lib
Install Oracle's ASMLIB tool to improve the manageability of raw
devices. |
| 1:30-2:15pm |
Lab
20 |
Install and Configure ASM Instance
Use the Oracle Universal Installer (OUI) to install an ASM
instance on each server. |
| 2:15-3:00pm |
Lab
21 |
Create RAC Database using ASM
Storage
Use Database Configuration Assistant (DBCA) to create a 2 node
RAC cluster using the ASM instance to provide storage for
datafiles, control files, redo logs, flash recovery area, and
the spfile. |
| 3:00-3:45pm |
Lab
22 |
ASM Instance Tour
A tour of the directories and files created during an ASM RAC
installation including log files. |
| 3:45-4:30pm |
Discussion 8 |
ASM Backup and
Recovery
A discussion of how to protect your ASM instance from
becoming a single point of failure. |
|
|
Instructors |
Dan Morgan
is an Oracle Ace Director, a 10g and 11g Beta tester for
Oracle, and the instructor of the Oracle program at the
University of Washington since its inception in 1999. He
began his IT career in 1969 with an IBM 370/145, punch
cards, and Fortran IV, and though he will vigorously deny
it, wrote COBOL for a decade before moving into Oracle
about when version 6 hit the market.
In addition to Dan's work at the university he is the
Education Chair of the Puget Sound Oracle Users Group, a
member of UKOUG, and a member of the British-American
Chamber of Commerce in Seattle. He is also a frequent
lecturer at training events and at conferences and has
presented at Oracle OpenWorld on RAC (2005), at Seattle
OracleDay (2004-2007), at numerous government and
corporate training events including Apple Computer,
Argonne National Laboratory, Boeing Commercial Airplane
Group, Dow Jones & Company, Lawrence Livermore
National Laboratory, NASA, T-Mobile, US Navy at Pearl
Harbor, and Weyerhaeuser to name but a few and presented
on Streams and Change Data Capture at UKOUG in 2006.
Dan Morgan is the Morgan behind the "Morgan's
Library" website that contains the many demos he has
created for his University of Washington classes as well
as for his frequent lectures. He is the former publisher
of MacTech Journal, has presented Oracle technical
lectures in the US, Canada, Great Britain, and Japan.
Morgan is also the co-author of this course with Caleb
Small.
Caleb Small is the primary instructor for the
Oracle Workforce Development program at Camosun College in
Victoria BC, and a private consultant with years of
experience implementing and teaching Oracle throughout
North America. He has over 30 years experience in the IT
industry in numerous business areas including both public
and private sectors.
Caleb is also active as a director of the Victoria and
Puget Sound Oracle User Groups, and has delivered numerous
lectures, presentations, live demos and articles to other
groups. He has authored and led many of the PSOUG
workshops including RAC, ASM, RMAN and Data Guard.
Caleb was one of the first people to build an 11g RAC
cluster and has been a primary consultant on RAC to
publicly held corporations including Areva T&D and
Montana Dakota Utilities (MDU).
|
|
