Oracle 11g Release 2 RAC & Grid Infrastructure Administration
Course
In London
Description
-
Type
Course
-
Location
London
-
Class hours
35h
-
Duration
5 Days
Suitable for: This Oracle 11g Release 2 RAC & Grid Infrastructure Administration course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC) within the Oracle Grid Infrastructure environment. Delegates will learn how to install, create, configure and administer a database for use with RAC within the Oracle Grid Infrastructure environment. Delegates will learn how to setup and use Automatic Storage Management (ASM) and Oracle Clusterware in a RAC environment.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Implement
Course programme
The objective of this Oracle 11g Release 2 RAC & Grid Infrastructure Administration course is to provide the skills needed to plan, implement, manage and troubleshoot Oracle RAC database configurations in an Oracle Grid Infrastructure environment.
Oracle 11g Release 2 RAC & Grid Infrastructure Administration Training Course
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Oracle RAC Features
- Oracle RAC Technology Hierarchy
- Oracle RAC Capabilities
- Oracle RAC Components
- Tools for Installing, Configuring and Managing Oracle RAC
- Cluster Overview
- Grid Foundation Components and Architecture
- Oracle Clusterware Components and RAC
- Oracle Clusterware Software and Storage
- Oracle Storage Subsystems
- File Types used by a RAC Database
- Methods used to Share Database Files across a Cluster
- ASM Architecture
- Create and Manage ASM Disk Groups
- Create and Manage ASM Cluster Filesystems
- An Overview of RAC Services
- Network Requirements and Configuration
- Single Client Access Names
- Overview of Grid Plug and Play
- Oracle RAC Pre-installation Tasks
- Job Role Separation
- Create Oracle Groups, User Accounts and Directories
- Validate and Prepare the Hardware and the Operating System
- Configure RAC Nodes for Remote Access using SSH
- Configure the Network for RAC
- Configure the Startup Commands for the Oracle RAC Nodes
- Install and Configure ASMLIB
Course Contents - DAY 2
Session 4: INSTALL ORACLE GRID INFRASTRUCTURE AND REAL APPLICATION CLUSTERS
- Install the Oracle Grid Infrastructure
- Use the Cluster Verification Utility
- Install Oracle Database Software and Create a Cluster Database
- Verify the Installation
- Post Installation Tasks
- Configure Client Connections with Oracle Net Manager
- Convert an Oracle Database to a RAC Database
- Use the DBCA for Single Instance Conversion
- Use rconfig for Single Instance Conversion
- RAC Specific Background Processes
- Administer Oracle RAC using Enterprise Manager
- Policy Managed and Administrator Managed Databases
- RAC Initialization Parameters
- Manage Undo Tablespaces in a RAC Environment
- Manage Redo Log Files and Groups in a RAC Environment
- Oracle Enterprise Manager Cluster Database Pages
- Start and Stop Oracle RAC Databases and Instances
- Administer Database Storage
Course Contents - DAY 3
Session 6: ADMINISTER ORACLE CLUSTERWARE COMPONENTS
- CRS Resources and Daemon Functionality
- Manage Clusterware with Enterprise Manager
- CRSCTL Commands to Stop, Start and Administer Clusterware
- Backup and Recover Voting Disks
- Add and Remove Voting Disks
- The ocrcheck Utility
- The ocrdump Command
- Administer the Oracle Cluster Registry (OCR)
- Locate OCR Automatic Backups
- Backup and Restore OCR
- Troubleshoot the OCR with ocrcheck
- ASM Overview
- ASM Components in RAC
- ASM Initialization Parameters
- Create an ASM Instance using ASMCA
- Start and Stop an ASM Instance using srvctl
- Start and Stop an ASM Instance using ASMCMD and ASMCA
- Start and Stop an ASM Instance Containing Cluster Files
- Start and Stop the ASM Listener
- Create and Delete ASM Disk Groups
- ASM Disk Group Attributes
- ASM Disk Group Maintenance Tasks
- Preferred Read Failure Groups
- ASM Disk Statistics
- RAC Management Commands
- RAC Administration with SVRCTL
- SVRCTL Cluster Database Configuration Tasks
- SVRCTL Cluster Database Administration Tasks
- Check the Current Configuration
- SVRCTL Command Summary
- Administer Databases and Instances
- Administer Services and Node Applications
- Bring a Cluster Database online and offline
- Introduction to CRS
- Cluster Services
- Manage the Database Workload using Services
- Create and Administer Services in a RAC Environment
- Services and Client Applications
- Manage Services with Enterprise Manager and from the Command Line
- Configure Oracle Net to Support Services
- Configure Service Level Thresholds
- Configure Clients for Failover
Course Contents - DAY 4
Session 11: HIGH AVALABILITY OF CONNECTIONS
- RAC High Availability Framework
- Failure Detection with Cluster Services
- Oracle RAC and Hardware Failover
- Connection Failover
- Transparent Application Failover (TAF)
- Server, Client And Runtime Load Balancing
- Fast Application Notification (FAN)
- Server and Client Side Oracle Notification Services
- Configure a Fast Recovery Area for use with RAC
- Tune Instance Recovery in RAC
- Parallel Recovery in RAC
- Initiate Archiving
- Configure RMAN Backup and Recovery Settings
- Backup a RAC Database using RMAN
- Restore and Recover a RAC Database using RMAN
- Display Backup Reports
- Best Practices and Tips for Backup and Recovery
Course Contents - DAY 5
Session 13: RAC PERFORMANCE TUNING
- Monitoring and Performance Guidelines
- RAC Monitoring Tools
- RAC Performance Recommendations
- Analyze Performance Issues
- Use the Automatic Workload Repository in RAC
- Use the Automatic Database Diagnostic Monitor in RAC
- Use Statspack with RAC
- Global Cache Services (GCS) Monitoring
- V$cache_transfer Views
- Monitor the GES Processes
- Monitor and Tune the RAC Cluster Environment using Enterprise Manager
- Grid Plug and Play (GPnP)
- Prepare a New Node
- Extend the Oracle Grid Infrastructure Home to the New Node
- Extend the Oracle RAC Home Directory
- Add the New Node to the Cluster
- Create an Instance on the New Node
- Delete an Instance from the Cluster Database
- Remove a Node from the Cluster
- Configure the EM Patch Interface
- Obtain Patches
- Apply Rolling Patches to a RAC System
- Apply a Patchset with the opatch Utility
- Apply a Patchset with OUI
Oracle 11g Release 2 RAC & Grid Infrastructure Administration