Unlike other Oracle RAC tuning classes, it will provide you step by step guidance to create RAC environment at your home PC using VMWARE a freeware software. The course focuses on RAC architecture, installation, patching, administration, backup and recovery and tuning. The course will also include specialized Oracle RAC tuning script for monitoring all of the critical RAC performance areas.

Commencement Date: 22 June 2013

Training Schedule : 22, 23, 29, 30 June 2013 & 06, 07 July 2013

Training Duration:  6 Days

Timings : 1:00 Noon GMT | 9:00AM EST | 6:00AM PST | 8:00AM CST | 7:00AM MST | 6:30PM IST

Course Fee: USD 599

** For any issues/queries, contact  This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Course Contents :

Day 1:
Grid Infrastructure Concepts
What is a Cluster
Grid Foundation Components
Oracle Clusterware Architecture
Oracle Clusterware Software and Storage
Describe ASM Architecture
Creating and Managing ASM Disk Groups
Creating and Managing ASM Cluster Filesystems
Job Role Separation
Grid Infrastructure Installation and Configuration
Hardware Requirements
Network Requirements
DNS and DHCP Configuration
Grid Plug and Play Considerations
Single Client Access Names
Post installation tasks

Day 2:
Administering Oracle Clusterware
Managing Clusterware with Enterprise Manager
Determining the Location of the Oracle Clusterware Configuration Files
Backing Up and Recovering the Voting Disk
Adding, Deleting, or Migrating Voting Disks
Locating the OCR Automatic Backups
Oracle Local Registry
Migrating OCR Locations to ASM
Managing Network Settings
Managing Oracle Clusterware

Day 3:
Prerequisite Steps for Extending a Cluster
Using addNode.sh to Add a Node to a Cluster
Rolling Patches, And Rolling Upgrades
Comparing Software Versions With the Active Version
Installing A Patchset With the OUI Utility
Installing A Patch With The opatch Utility
Oracle Clusterware High Availability
Oracle Clusterware high availability components
Contrasting policy-managed and administration managed databases
Troubleshooting Oracle Clusterware
Oracle Clusterware Log Files
Component-level Debugging
Troubleshooting the Oracle Cluster Registry


Day 4:
Administering ASM Instances
ASM Initialization Parameters
Adjusting ASM Instance Parameters in SPFILEs
Starting and Stopping ASM Instances Using srvctl
Starting and Stopping ASM Instances Using ASMCA and ASMCMD
Starting and Stopping ASM Instances Containing Cluster Files
Starting and Stopping the ASM Listener
Administering ASM Disk Groups
Creating And Deleting ASM Disk Groups
ASM Disk Group Attributes
ASM Disk Group Maintenance Tasks
Preferred Read Failure Groups
Viewing ASM Disk Statistics
Performance And Scalability Considerations For ASM Disk Groups
ASM Files, Directories, and Templates
Using Different Client Tools to Access ASM Files
Fully Qualified ASM File Name Format
Creating and Managing ASM files, Directories and Aliases
Managing Disk Group Templates
Managing ASM ACL With Command Line Utilities
Managing ASM ACL with Enterprise Manager
Administering ASM Cluster File Systems
ASM Dynamic Volume Manager
Managing ASM Volumes
Implementing ASM Cluster File System
Managing ASM Cluster File System (ACFS)
Using Command Line Tools To Manage ACFS
Real Application Clusters Database Installation
Installing The Oracle Database Software
Creating A Cluster Database
Post–database Creation Tasks

Day 5:
Single-Instance Conversion Using the DBCA
Single-Instance Conversion Using rconfig
Background Processes Specific to Oracle RAC
Oracle RAC Administration
Enterprise Manager Cluster Database Pages
Redo Log Files In A RAC Environment
Undo Tablespaces In A RAC Environment
Starting And Stopping RAC Databases And Instances
Initialization Parameters In A RAC Environment
Transparent Data Encryption and Wallets in RAC
Quiescing RAC Databases
Managing Backup and Recovery for RAC
Protecting Against Media Failure
Parallel Recovery in RAC
Archived Log File Configurations
RAC Backup and Recovery Using EM
Archived Redo File Conventions in RAC
Channel Connections to Cluster Instances
Monitoring and Tuning the RAC Database
Determining RAC-Specific Tuning Components
Tuning Instance Recovery in RAC
RAC-Specific Wait Events, Global Enqueues, and System Statistics
Implementing the Most Common RAC Tuning Tips
Using the Cluster Database Performance Pages
Using the Automatic Workload Repository in RAC
Using Automatic Database Diagnostic Monitor in RAC


Day 6:
Services
Configure and Manage Services in a RAC environment
Using Services with Client Applications
Managing Services From the Command Line
Maximum Availability Architecture