Oracle RAC (Real Application Cluster)

Rate the Course:   
4.60 out of 5 - Based on 218 Ratings

Croma Campus is the best known for its “Oracle RAC (Real Application Cluster)” course for every kind of students whether freshers, College Students, Professionals or non professionals to fulfill the needs of dynamic IT companies. We focus on quality of practical knowledge and concept clarity. We have Oracle expertise trainers who are also working on real time projects. Moreover, Course completion and project completion certificates will also be provided on completion of the course. We have also association with major MNCs & Agencies to place our candidates.

Oracle RAC (Real Application Cluster) enables clustering of database from various servers, which aids in storage and enables high scalability, availability, and manageability. Students will learn how to install and manage Oracle Real time Application Clusters, and Automatic Storage Management.

Benefits of Oracle RAC:-

  • Reliability
  • Recoverability
  • Error Detection
  • Continuous Operation

By the end of this training,the aspirants will acquire the knowledge in the following skillsets :

  • Identify Real Application Clusters components and Shared Storage Technologies
  • Install RAC database and create cluster database
  • Use Enterprise Manager Grid Control
  • Use configuration tools for RAC databases
  • Manage instances and determine RAC-specific wait events, global enqueues, and system statistics
  • Configure and manage services in a RAC environment
  • Determine and review applications high availability and mange workload
  • Plan and implement backup and recovery strategy
  • Configure and monitor Oracle Clusterware resources
  • Administer Oracle Clusterware resources
  • Add/Remove a node to/from a cluster.
  • Patch Oracle Clusterware and RAC software in a rolling fashion.

 

Target audience :

  • Database Designers
  • Database administrators
  • Data Warehouse Administrator
  • Technical Administrator
  • System Analyst
  • Support Engineer
  • Consultants

 

Prerequisites :

The candidates having familiarity with Oracle Database Architecture(DBA) and administration are the ideal participants for this course.

 

Exams for Certification :

Exam Name Exam Code
Oracle Real Application Clusters 10gR2 :Admin 1Z0-048

Introduction to RAC 11g

  • The Dynamic Business Environment
  • The Explosive Growth of Business Data
    • Online and Real-Time Access to Corporate Data
    • Data Warehousing, Packaged Applications, E-Commerce Operations
    • Dependence on Database Management Systems
    • High Performance Systems
  • Introduction to Cluster Technology
  • Benefits of Real Application Clusters (RAC)
    • What is a DB Cluster?
    • Architectures of DB Clusters
    • What is a Cluster Interconnect?
  • Problems with Other Architectures
    • The IBM Shared-Nothing Configuration
    • Microsoft Federated Servers Database
  • Seeing the High Availability Spectrum
  • Real Application Clusters
    • Processing Prior to Cache Fusion
  • Oracle Real Application Clusters
    • Attributes of an Oracle RAC Cluster
    • Building an Oracle RAC Cluster
    • RAC Performance and Scalability

RAC 11g High Performance and Highly Available Databases

  • Growth of Powerful Processors
  • Why Parallel Processing?
  • Opportunities for Parallelism
  • Scalability
  • Parallel Databases
    • Types of Parallelism
  • High Performance Computing Cluster – HPCC
  • Clusterize Applications
    • How Do You Clusterize Applications?
  • Highly Available Databases
    • Need for Highly Available Data
    • Failure
    • Availability
    • Reliability and Serviceability
    • Fault-tolerant Systems
    • Database Availability
  • Clustered Systems
  • Databases Issues
  • Oracle RAC – High Performance and Highly Available Database

Database Clusters 

  • Overview of the Cluster Technology
    • How Clusters Differ from Distributed Systems
    • Clusters are Different from Fault-tolerant Systems
    • Database Clusters
    • Why Clusters?
  • Types of Clusters
    • Failover Clusters
    • Scalable High Performance Clusters
    • Application Server Clusters
    • Other Types of Clusters
  • Components of a Cluster
    • Cluster Nodes
    • Emerging Server Cluster Architectures
    • Cluster Interconnect
    • Essentials for Parallel Database Clusters
    • Cluster Interconnect Products
    • Infiniband Interconnect
    • ClusterWare
    • Concurrent Database Access
  • Failover Database Clusters
    • Resources, Resource Type
    • Resource Groups
    • The Concept of a Virtual Server
    • Failover Process
    • Examples
    • Failover Cluster Architecture
    • Oracle Database Service in HA Cluster
    • Issues with FO Clusters – Hidden Risks
  • Parallel Database Clusters
    • Shared-Nothing Model
    • Shared-Disk Model
    • Microsoft SQL Server Federated Database
    • IBM Offerings
    • Requirements for Parallel Clusters
    • Oracle’s Instance Membership Recovery
    • Cache Coherency and Lock Management

Real Application Cluster Architecture

  • Overview of Oracle Real Application Clusters
    • RMAN for RAC
    • RAC Workload Management
    • RAC Scalability
    • High Availability
  • Architecture
    • Oracle11g Basic Processes
    • Oracle11g Basic Internal Structures
    • Oracle11g RAC Additional Processes
    • Oracle11g RAC Additional SGA Areas
  • RAC Server Components
    • GCS Resource Modes and Roles
    • Accessing RAC

RAC Server and Disk Technology

  • Overview
  • Oracle11g RAC Disk System
  • Understanding Disks, LUNs, Volumes
    • Raw Volumes
    • File Systems
  • Storage Technology and Redundancy
    • Disk Systems
    • Understanding I/O Path
    • Host Bus Adapters (HBA)
    • Storage Redundancy Components
    • RAID and RAID Administration
    • High Availability of Storage
    • Logical Volume Managers
  • Storage Areas
    • OCFS/OCFS2
    • RAW Volumes
    • ASM
    • Other CFS Solutions
  • Redundancy
    • Understanding RAID Redundancy
  • Capabilities
    • Server Redundancy
    • Redundancy Types

RAC Installation and Configuration

  • Architecture and Components
    • Servers and Operating System
    • Cluster Interconnect and Public Switch
    • Oracle Clusterware
    • Shared Storage Subsystem
  • Overview of Installation Steps
    • Installation of Oracle Clusterware
    • Installation of Oracle for use with ASM
    • Installation of Oracle for production database use
  • Oracle RAC Tools
    • crs_stat
    • olsnodes
    • srvctl
    • dbca
    • netca

Internals of Real Application Clusters

  • Overview of Cache Fusion
    • Evolution of Cache Fusion
    • Nature of Cache Fusion
    • Benefits of Cache Fusion
    • Concurrency and Consistency
    • Cache Coherency
    • Global Cache Service
  • SGA Components and Locking
    • SGA – System Global Area
    • Program Global Area (PGA)
    • Buffer Cache Management
    • What is a Dirty Block?
    • Multi – Version Consistency Model
  • RAC Components
    • Global Cache Service
    • Global Enqueque Service
    • Row-Level Locks
    • Global Resource Directory
    • RAC Processes
  • Resource Coordination
    • Synchronization
    • GCS Resource Modes and Roles
    • Concept of Past Image
    • Lock Modes
    • Block Access Modes and Buffer States
    • Cache Fusion Scenarios
    • Block transfers using Cache Fusion – Examples
    • Block Access, Grants, and Interrupts
  • Cache Fusion and Recovery
    • Recovery Features
    • Recovery Methodology and Steps
    • Recovery Process – Re-mastering Resources

11g RAC Administration

  • Parameter Management
    • Overview
    • RAC and Initialization Parameters
  • UNDO Management
    • UNDO Management in RAC
    • UNDO Tablespace Features
    • System Rollback Segment
  • Concept of Thread
    • Thread Features
    • Redo Thread Maintenance
  • Segment Space Management
    • Automatic Segment Space Management
    • Manual Space Management
    • Oracle Managed Files
  • Using SQL*Plus
    • Starting the Database in Cluster Mode
  • Using Oracle DB Control for Clusters
    • Configuration of DB control w/RAC

RAC 11g Backup and Recovery

  • Overview of RAC backup and Recovery
    • Export
    • Cold Backup using Scripts
    • Hot Backups using Scripts
    • RMAN (Recovery Manager)
    • Third Party Solutions
  • Backup of RAC Database
    • Using RMAN for Backups
    • Backup Procedures RMAN and RAC
  • Recovery in the RAC Environment
    • Media Recovery in RAC Instances
    • Using RMAN to Recover a RAC Environment
    • Recovery in an OCFS Environment
    • Recovery in a Raw File System Environment
    • Parallel Recovery
  • Standby Databases in RAC Configuration
    • Setting up a Standby Database for a RAC Cluster to a Single-Instance (One Node)
    • Configuration when the Standby Database is a Single Node System
    • Cross-Instance Archival
    • Archive Log Gap Resolution and FAL
  • ASM and RMAN
    • Performing advanced backup/ recovery techniques with ASM
    • SWITCH DATABASE TO COPY
    • Keeping ASM Clean

Failover and Load Balancing

  • Services In-depth
    • Failover
    • Load Balancing
    • Planning and Configuration
  • Connection Pools and Services
  • The Load Balancing Advisory
  • Monitoring Services

RAC Performance Monitoring and Tuning

  • Analysis of Performance Issues
    • Monitoring RAC Cluster Interconnect
    • Using performance views
    • Using AWR
    • ADDM for RAC
  • Using DB Control to Monitor RAC

RAC Design Consideration

  • Designing equipment for RAC
    • Effects of component failure
    • Redundancy at every level
    • Choosing Service/Nodes for Work
  • Sequences in RAC
    • Tablespace Design Considerations
    • Solid State Disk Considerations
    • Table Locks and Latch Waits
    • Scalability and Unpredictable Loads

Migration to RAC Databases

  • Overview
  • Migration Methodology
    • Moving from Single Instance to RAC
    • Cloning Overview
    • Migrating to Oracle 11g
    • Rolling Upgrades

Oracle 11g RAC parallel upgrades

  • Oracle 11g RAC has a rolling upgrade features whereby RAC database can be upgraded without any downtime.

Oracle 11g hot patching

  • Oracle 11g RAC has the ability to apply patches on a node-by-node basis without service interruption.

Oracle 11g RAC load balancing advisor

  • Starting in 10gr2 we see a RAC load balancing advisorutility.  Oracle says that the 11g RAC load balancing advisor is only available with clients which use .NET, ODBC, or the Oracle Call Interface (OCI).

ADDM for RAC 11g

  • In Oracle 11g, ADDM has been extended to include RAC, and provides information on the entire cluster including latency issues on the cluster interconnect, global cache hot blocks (blocks with concurrency issues across multiple nodes), and general object usage information across multiple nodes.

11g RAC cache fusion protocols

  • 11g RAC improves the cache fusion layer for faster and more efficient pinging between nodes
  • 11g RAC ASMCA
  • Oracle 11g offers an ASM configuration assistant allows you to install cluster file systems (ACFS), ASM instances, ASM volumes and disk groups.

Optimized 11g RAC cache fusion protocols

  • Extends the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized.

Oracle 11g RAC Grid provisioning

  • The Oracle 11g grid control provisioning pack allows you to “blow-out” a RAC node without the time-consuming install, using a pre-installed “footprint”.

Please write to us at info@cromacampus.com for the course price, schedule & location.

Enquire Now

Frequently Asked Questions:

All training courses offered by us are through IT Professional with 10+ years of experience. Freshers/College Students/Professionals(IT & Non-IT) can spot the quality of training by attending one lecture. Hence, we provide one free demo class to all our trainees so that they can judge on their own.

No, you don’t have to pay anything to attend the demo class. You are required to pay the training fee after free demo only if you are fully satisfied and want to continue the training.

To register for free demo, visit our campus or call our counsellors on the numbers given on contact us page.

Yes, all the trainees shall work on live projects provided by Croma Campus after completing their training part.

You will never lose any lecture. You can choose either of the two options:
View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

Please note, access to the course material will be available for lifetime once you have enrolled into the course.

Yes, Training certificate & Project completion will be issued by Croma Campus(ISO 9001-2000 Certified Training Center)

Yes, Croma Campus conduct special training programs on week end for college students throughout the year.

Croma Campus is the largest education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

Yes, Course Fee can be paid in two equal installments with prior Approval.

Yes, Croma Campus offer various group or special discounts.

No, Lab is open from 8 A.M. to 8 P.M. seven days a week. This time can be extended upto 11 PM if need arises.

Yes, students can take breaks during their exams and can resume it later without paying any fee. Apart from this, Students can attend batches for revision even after completion of their courses.

Batch strength differ from technology to technology. Minimum batch strength at Croma Campus is 10 and maximum batch strength is 30.

Drop us a query

Course Features

Get Practical and Well focused training from Top IT Industry experts.

Get Routine assignments based on learning from previous classes.

Live project, during or after the completion of the syllabus.

Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

Get certification after the course completion.

+91-9711526942 whatsapp

Testimonials