Selenium Online training

Oracle RAC DBA Online Training

Learn Oracle RAC DBA online training from United Training’s to work in the best Oracle DBA consultants made available in the IT environs. Oracle RAC DBA training (Real Application Clusters) allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering. The main aim of Oracle RAC is to implement a clustered database to provide performance, scalability and resilience.

 

Course Content – Oracle RAC online training

Introduction about Oracle 11g RAC

  • What is a ClusterOracle Real Application Clusters (RAC)
  • Advantage of using RAC
  • Clusters High Availability, Scalability and Performance
  • Oracle Real Application Clusters Architecture
  • Cache fusion f. Multi instance transaction behaviour
  • Extra background process in RAC

Installation of Oracle Clusterware (CRS) and configuration

  • Oracle RAC 10g Installation: Outline
  • Pre-Installation Tasks
  • Hardware Requirements
  • Network Requirements
  • The oracle User Environment Setup & User Shell Limits
  • Linux Operating System Parameters
  • Cluster Setup Tasks h. Storage for Cluster
  • Oracle Cluster Registry File
  • Voting Disk File
  • Verifying the Oracle Clusterware Installation
  • Cluster verify utility (CLUVFY)

ASM with RAC

  • ASM Overview
  • Installation of ASM Instances
  • Managing ASM Disk Groups and Instances
  • ASM Instance and Crash Recovery in RAC

RAC Software Installation & Database Creation

  • Oracle database software installation
  • Cluster database creation
  • Post installation tasks

Oracle Clusterware Administration & Debugging

  • Oracle Cluster registry (OCR)
  • Voting disk
  • VIP Addresses
  • Debugging Clusterware log files
  • Workload distribution
  • Transparent application failover

RAC Administration

  • Starting and Stopping RAC Instances
  • Creating and Registering Instances
  • Transparent Application Failover (TAF)
  • Database files with RAC
  • Initialization Parameter Files
  • Trace & Alert logs
  • Undo management
  • Temporary table space monitoring

RAC Services

  • What is a Service
  • Advantage of using service
  • Possible service configuration
  • Creation and maintenance of services using SRVCTL, DBCA,EM
  • Statistics gathering and tracing to check performance of Services
  • Service performance views
  • Workload distribution
  • Transparent application failover

Performance Monitoring

  • Finding & Monitoring the Sessions
  • Session and system statistics
  • Finding and Resolving Locks across Instances
  • Cache Fusion impact & events in RAC
  • Wait events & Wait event views
  • Generating AWR Snapshots & Reports in RAC
  • Doing ADDM analysis

Backup and Recovery in RAC

  • Protecting Against Media Failure
  • Archived Log File Configurations & Conventions
  • RAC and the Flash Recovery Area
  • Oracle Recovery Manager
  • Distribution of Backups