Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle® 11g Real Application Clusters for Administrators
Oracle Training Overview

This hands-on course teaches students all aspects of Oracle® 11g RAC administration. Students will begin with a solid foundation in Oracle Clusterware and RAC architecture. Students will then install and configure both Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important topics such as failover, flashback, and backup and recovery are all covered in detail. Students will get hands-on experience with Automatic Storage Management. The course ends with troubleshooting and tuning a RAC system.

Oracle Training Prerequisites

Oracle 11g Database Administration and at least 6 months of administration experience recommended.

Oracle Training Audience

Database administrators new to the RAC environment.

Oracle Training Course duration

5 Days

Oracle Training Course outline

1. Cluster Architecture
  • Cluster Architecture
  • Shared Storage
  • Nodes and Interconnects
  • Oracle Cluster Registry (OCR)
  • The RAC Voting Disk
  • Virtual IP Addresses
  • SCAN Addresses and GNS
  • Oracle Software
2. Oracle Clusterware
  • What is Oracle Clusterware?
  • Oracle Clusterware Files
  • Oracle Clusterware Processes
  • The Grid Home
  • Oracle Clusterware Preinstallation Steps
  • Node Preparation
  • Configuring SSH User Equivalency
  • cluvfy – The Cluster Verification Utility
  • Installing the Grid Infrastructure
  • Oracle Clusterware Postinstallation Steps
3. Installing DB Software and Creating a RAC Database
  • Installation Overview
  • Configuring the OS Environment
  • Verifying System Readiness with the CVU
  • Installing the Database Software
  • Troubleshooting Installation Setup
  • Recommended Postinstallation Tasks
  • Database Pre-Creation Tasks
  • Creating a Cluster Database Using DBCA
  • Initialization Parameters
  • ORACLE_SID in a RAC Environment
4. RAC Database Architecture
  • Overview of RAC
  • Oracle Single-Instance Architecture
  • RAC Architecture
  • RAC Instances and Parameter Files
  • RAC Database Components
  • RAC Instance Background Processes
  • Global Resource Directory
  • Overview of Cache Fusion
  • Cache Fusion Components – GES and GCS
  • Cache Fusion Components – Resource Master and GRD
  • Application Connection to RAC
5. RAC Instance Management
  • Overview of RAC Instance Management
  • Starting and Stopping RAC Database
  • Starting and Stopping a RAC Instance
  • RAC Database Identical Parameters
  • RAC Database Unique Parameters
  • Changing Parameter Values
  • Administering Undo Tablespaces in RAC
  • Administering Redo Logs in RAC
6. Managing Oracle Clusterware
  • About Oracle Clusterware
  • Adding and Removing Voting Disks
  • Backing Up and Recovering Voting Disks
  • The OCR
  • Changing the OCR Configuration
  • Adding and Removing an OCR Location
  • Backing Up and Recovering the OCR
  • Restoring from Automatic OCR Backups
  • Moving or Replacing the OCR
  • Repairing the OCR Configuration
  • Troubleshooting the OCR
7. RAC Utilities
  • The olsnodes Utility
  • The ocrcheck Utility
  • The ocrdump Utility
  • Querying Clusterware Resource Status
  • The crsctl Utility
  • The Server Control (SRVCTL) Utility
  • SRVCTL ADD
  • SRVCTL CONFIG
  • SRVCTL ENABLE and DISABLE
  • SRVCTL GETENV
  • SRVCTL MODIFY
  • SRVCTL RELOCATE
  • SRVCTL STATUS
  • SRVCTL REMOVE
  • SRVCTL START
  • SRVCTL STOP
8. Services
  • Overview of Services
  • Types of Services
  • Creating Services with srvctl
  • Preferred and Available Instances for Services
  • Using Services
  • Managing Services
  • Service Views
  • Tracing with Services
9. Failover
  • Transparent Application Failover (TAF)
  • Client-Side vs. Server-Side TAF
  • Configuring TAF on the Client
  • Using OEM to Configure TAF
  • Using srvctl to Configure TAF
  • The DMBS_SERVICE Package
  • Connecting to the Database with TAF
  • Monitoring TAF Connections
10. RAC Backup and Recovery
  • Overview of RAC Backup and Recovery
  • Log Archiving in RAC
  • Undo Tablespaces in RAC
  • Using Flashback Features in RAC
  • Deploying a Fast Recovery Area in RAC
  • Performing RMAN Backups of a RAC Database
  • Performing Non-RMAN Backups
  • Preparing to Restore and Recover with RMAN
  • Recover the RAC Database with RMAN
  • Recovering Without RMAN
11. Cluster Management
  • Overview of Cluster Management Tasks
  • Extending the Clusterware Home Directory
  • Extending the Database Software Home Directory
  • Creating the New Instance
  • Verifying the New Instance
  • Removing a Node
12. Automatic Storage Management
  • ASM Overview
  • ASMLib
  • Installing ASM
  • Creating an ASM Instance
  • ASM Initialization Parameters
  • Accessing an ASM Instance
  • ASM Startup and Shutdown
  • Creating a Disk Group
  • Dynamic Perfomance Views for ASM
  • Changing a Disk Group
  • Oracle-Managed Files
  • Creating and Managing a Database
  • Creating and Managing a Tablespace
  • Creating and Managing Redo Logs
  • Creating and Copying Control Files
  • Backing up and Restoring Control Files
  • Creating and Managing Archive Logs
  • ASMCMD
13. ASM Backup, Recovery, and Migration
  • Overview of ASM Backup and Recovery
  • Overview of Recovery Manager (RMAN) and ASM
  • Migrating a Database to ASM
  • Migrating the Control File
  • Migrating the Database Files
  • Migrating the Online Redo Logs
  • Migrating SPFILEs
14. Clusterware and RAC Troubleshooting
  • The Oracle Clusterware Alert Log
  • Clusterware Component Log Files
  • Automatic Diagnostic Repository and ADRCI
  • Using crsctl to Diagnose Cluster Issues
  • Using diagcollection.pl
  • Checking Interconnect Settings
  • cluvfy – Verifying Clusterware Component Integrity
  • cluvfy – Verifying Cluster Registry Integrity
  • cluvfy – Verifying Cluster Integrity
  • ocrcheck – Verifying the Oracle Cluster Repository
  • RAC Database Alerts
  • Cluster Health Monitor (CHM)
  • The racdiag.sql Script
  • The oradebug Utility
15. RAC Tuning
  • RAC Tuning Methodology
  • Using Performance Views in RAC
  • Monitoring Cache Fusion
  • Global Cache Latencies
  • Monitoring Cache Transfers
  • OEM – Cluster Database Performance
  • OEM – RAC-Related Reports
  • Using AWR in the RAC Environment
  • Generating AWR Reports
  • Analyzing AWR Reports
  • Using ADDM in the RAC Environment
  • Analyzing ADDM Reports
  • RAC Tuning Tips and Best Practices
16. Appendix – Preparing a RAC Node
  • Checking the Hardware Requirements
  • Identifying Network Requirements
  • Configuring Operating System Users and Groups
  • Generating RSA and DSA Keys
  • Adding the Keys to an Authorized Key File
  • Configuring SSH User Equivalency
  • Configuring the Operating System Environment
  • Configuring the Network
  • Verifying the Network Configuration
  • Preparing the Operating System and Software
  • Configuring Installation Directories and Shared Storage
  • Choosing Directories

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved