Oracle RAC

Oracle 12c Real Application Clusters (Oracle RAC) course prepares the students to successfully administer and manage Multi-Instance Oracle Databases. Oracle RAC is the foundation for Oracle’s Grid computing and provides Scalability and High Availability to business critical 24x7 databases. In today’s database world, Oracle RAC has become one of the most sought after skill from Oracle Database Administrators. The demand for Oracle RAC professionals is ever increasing than before. Many companies across the world prefer to hire Oracle DBAs with good knowledge of Oracle RAC

Download Brochure

What you will learn?

After completing this course, students will gain thorough knowledge about Oracle 12c RAC Concepts, Architecture, Management and Administration. Students will get hands-on exposure to:

  • Installing ,Configuring and Administering Oracle 12c Grid Infrastructure
  • Implementing Oracle Flex Cluster – a new cluster introduced in 12c
  • Configuring & Administering Oracle Flex ASM
  • Installing, Configuring and Administering Oracle 12c RAC Databases and understand new features in Oracle 12c RAC
  • Patching RAC environments using rolling patching method
  • Converting single instance database to RAC

The focus is more on practical setup and configuration so that students will gain thorough hands-on knowledge required to manage Oracle RAC databases in real time. Students will also be exposed to Real time scenarios that will be implemented in typical RAC Projects. The course will be implemented on Linux platform.

Who can attend?

  • Oracle Database Administrators

Suggested Pre-requisites

  • Prior knowledge on Oracle Database Administration (Oracle DBA)
  • Hands-on exposure to basic Linux commands

About the Course Instructor

The course Instructor, Muralidhar Punyala, is an expert DBA with 20 years of extensive and in-depth experience in Database Planning, Design, Implementations, Performance Tuning, High Availability, Scalability, Database Security, Data Management, Upgrade/Migrations, Backup & Recovery, Disaster Recovery areas. Muralidhar has worked with various Fortune-500 companies across the world in Singapore, Hong Kong, UK, Middle East & USA and rendered his DBA skills for some of the world’s most complex and very large databases projects. Murali was ex-practice manager at Oracle India.

1.Introduction to Clusters

  • Introduction to Clusters
  • Why cluster?
  • Different Clustering Architectures
  • Shared Nothing Clusters
  • Shared Disk Clusters
  • Shared Everything Clusters
2.Introduction to Oracle Real ApplicationClusters (RAC) 12c

  • What is Oracle Real Application
  • Clusters (RAC)?
  • Benefits of Oracle RAC
  • What RAC is NOT?
  • History of RAC
  • Tools & Utilities to manage RAC
3.Overview of Oracle RAC Infrastructure

  • Overview of Infrastructure required to implement RAC
  • Server & OS requirements
  • Network requirements
  • Storage requirements
  • Software requirements
4.Overview of Oracle Clusterware

  • What is Oracle Clusterware?
  • About OCR & Voting Disks
  • About Virtual IPs (VIP)
  • Single Client Access Name(SCAN)
  • SCAN Listeners
  • SCAN and DNS server
  • SCAN and host file
  • Node Listeners
5.Oracle ASM Concepts

  • Overview of Oracle ASM
  • ASM Features & Advantages
  • ASM Instance
  • ASM Disks & ASM Disk Groups
  • ASM Diskgroup Redundancy
  • ASM Failure groups
  • ASM Files
  • ASM Extents & Allocation Unit
  • Interaction between ASM Instance & RDBMS instance
  • ASM Limits
6.Overview of Oracle 12c Flex Cluster & Flex ASM

  • Oracle 12c Flex Cluster Architecture
  • Hub Nodes & Leaf nodes
  • Standard ASM
  • Overview of Oracle 12c Flex ASM
  • Flex ASM Architecture
  • Oracle Flex ASM Clusters Network
  • Oracle Flex ASM Listener
  • Benefits of Flex ASM
7.Preparing for Oracle 12c Grid Infrastructure Installation

  • Verifying System Requirements
  • Configuring the Network
  • Preparing the Operating System
  • Configuring Users & Groups
  • Configuring SSH
  • Configuring Installation Directories
  • Configuring Shared Storage
  • Creating Oracle ASM Disks
8.Installing Oracle 12c Grid Infrastructure

  • Verifying installation requirements withCluster Verification Utility
  • Installing the Oracle Grid Infrastructure
  • Verifying Oracle Clusterware Installation
9.Installing & Creating Oracle 12c RAC Database

  • Creating required directories
  • Installing Oracle 12c and Creating RACdatabase
  • Verifying RAC Database Creation
10. Administering Oracle Clusterware

  • Purpose of Oracle Clusterware (OCW)
  • OCW Services & Processes
  • OCW Resources
  • Local & Cluster resources
  • Understanding OCW Process Startup
  • Managing Oracle Clusterware using CRSCTL & SRVCTL commands
  • Starting & Stopping OCW
  • Enabling & Disabling OCW
  • Purpose of OCR & Voting Disks
  • Managing OCR & Voting Disks
  • Adding/Removing OCR Locations & Voting Disks
  • Backup of OCR & Voting Disks
  • Oracle Local Registry (OLR)
  • Managing OLR
11. Administering Oracle 12c Flex Clusters

  • Verifying Oracle Cluster mode
  • Listing node roles
  • Verifying ASM Cluster mode
  • Listing ASM Instances & Listeners
  • Testing ASM failure in Flex Cluster
12. Oracle Clusterware Diagnostic & AlertLog data

  • ADR Directory Structure &ADRCI
  • Oracle clusterware trace files and AlertLog file
  • Normal trace files & Incident Trace files
  • Collecting Oracle Clusterware
  • Diagnostic data
  • Diagnostics Collection Script
13. Cluster Health Monitor(CHM)

  • Overview of monitoring Oracle Clusterware
  • Cluster Health Monitor (CHM)
  • Oracle 12c Grid Infrastructure Management Repository (GIMR)
  • Collecting CHM data
  • Managing CHM with OCLUMON
14. Using Cluster Verification Utility(CVU)

  • About Cluster Verification Utility
  • CVU command format & usage
  • Using CVU for stage verification
  • Using CVU to check cluster components
15. Administering ASM Instances

  • Initialization Parameters for ASM Instances
  • Parameter Files for ASM Instances
  • Managing ASM Instance parameters
  • Shared Oracle ASM Password File in aDisk group
  • Starting & Stopping ASM Instances
16. Administering ASM Disk Groups

  • Managing ASM Disk Groups with
  • ASMCA& SQL Commands
  • Creating Disk groups
  • Altering Disk groups
  • Adding & Removing Disks
  • Mounting & Dismounting Disk Groups
  • Dropping Disk Groups
  • ASM Failure Groups
17. Administering ASM Directories & Files

  • ASM Directory structure
  • Managing ASM Directories
  • ASM Files
  • Fully Qualified File Names
  • Alias File Names
  • Incomplete File Names
18. ASM Command-Line Utility (ASMCMD)

  • Types of ASMCMD commands
  • Running ASMCMD in Interactive mode
  • Running ASMCMD in Non-Interactive mode
19. Oracle RAC Architecture

  • Instance in RAC
  • Single Instance DB Vs RAC DB
  • RAC specific Background processes
  • Global Resources in RAC
  • Cache Fusion in RAC

20. Administering RAC Instances & Database

  • Overview of RAC DB Administration
  • Starting and Stopping RAC Instances and Databases
  • Terminating Sessions in RAC
  • Initialization Parameters in RAC
  • Data Dictionary in RAC
  • Files in RAC
  • Archiving in RAC
  • Client connections in RAC
21. Backup & Recovery in RAC

  • Configuring RMAN Snapshot Control
  • File location
  • Configuring Control File &SPFILE auto backups
  • Configuring Channel connections inRAC
  • Instance Recovery in RAC
  • Media Recovery in RAC
  • Parallel Recovery in RAC
22. Workload Management with Services

  • Introduction to Oracle Services
  • Default Services
  • Creating Services
  • Preferred & Available Instances
  • Administering Services
  • Using Services with Client Applications
  • Transparent Application Failover (TAF)
  • TAF with Client-side configuration
  • TAF with Services
23. Migrating File system Database to ASM

  • Why migrate to ASM?
  • Basic concepts of migrating to ASM
  • Preparing to migrate to ASM
  • Migrating Database to ASM
24. Converting Single Instance Database toRAC Database

  • Overview of different Methods/Tools
  • About rconfig utility
  • Preparing XML file
  • Converting to RAC using rconfig
  • Verifying the conversion
25. Patching RAC Environments

  • Patchset, Bundle Patch, One-Off Patch, Patchset Updates
  • Rolling Patches, OPatch Utility
  • Downloading &Analyzing Patches
  • Installing RAC Patches in Rolling fashion
  • Verifying Patch Application

UCLID IT School is the leader in Oracle Trainings.  At UCLID, we assure you Top Quality and Project based Learning Methods. We have mastered the art of teaching Oracle RAC and helped many students to master the same.  At UCLID, we follow simple,easy and practical approach towards making you a master on Oracle RAC.

With it’s enviable & impeccable track record of training and placing thousands of students as Oracle RAC DBAs in many IT organizations, Uclid has the following unique advantages

  • Training by Real Time working Professionals
  • Training on Latest Versions – Oracle RAC 12c
  • In-depth and high quality explanation of each topic
  • High Quality Training Materials
  • Real world project based scenarios and case studies
  • Individual attention and group discussions for Interview preparation
  • Dedicated systems for Lab practice supported by qualified Lab Administrators
  • 100% Placement Assistance
  • 100% Satisfaction guaranteed

Uclid has best of the best teaching faculties who are real time IT Professionals working with top MNCs. Each faculty has a minimum 10 years of real time experience in Oracle RAC and working in the capacity of project leaders and project managers in various MNCs. You will benefit from their rich experience by going through the real time scenarios and case studies during the training. At the end of the course you will not only learn Oracle RAC but familiarize yourself with the real time aspects of Oracle RAC.