UCLIDIT SCHOOL

Oracle RAC

Oracle RAC is the foundation for Oracle’s Grid computing and provides Scalability and High Availability to business-critical 24x7 databases. Oracle 12c Real Application Clusters (Oracle RAC) training prepares the students to successfully administer and manage multi-Instance Oracle Databases.

After completing this course, students will gain thorough knowledge about Oracle 12c RAC Concepts, Architecture, Management and Administration.

Live Online Trainings

Course Duration: 4 Weeks

Fee:- INR 25,000

23 April 2020

11am IST – 12pm IST

URL for Live Session
https://www.gotomeet.me/UclidITS

Self-paced Recorded Trainings - INR 15,000

Course Description

Oracle RAC is the foundation for Oracle’s Grid computing and provides Scalability and High Availability to business-critical 24x7 databases. Oracle 12c Real Application Clusters (Oracle RAC) training prepares the students to successfully administer and manage multi-Instance Oracle Databases.

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 Grid Infrastructure
- Implementing Oracle Flex Cluster
- Configuring & Administering Oracle Flex ASM
- Installing, Configuring and Administering Oracle RAC Databases
- Patching RAC environments using rolling patching method
- Converting a single instance database to RAC
The focus is more on practical setup and configuration so that students will gain the 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 the Linux platform.

Course Instructor

The course Instructor, Muralidhar Punyala, is an IT professional with 23 years of global IT experience. Murali worked with various global organizations in countries like USA, UK, Singapore, Hong Kong and India. Currently, Murali is the Director at Uclid IT School and previously worked as Practice Manager at Oracle India.

Course Curriculum
Module-1: Basics & Concepts
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 Application Clusters (RAC) 12c
- What is Oracle Real Application Clusters (RAC)?
- Benefits of Oracle RAC
- What is RAC 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 VIPs
- 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
Module-2: Installation, Configuration
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 with Cluster 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 RAC database
- Verifying RAC Database Creation
Module-3: Admin, Manage Oracle Grid Infrastructure
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
- OCRCHECK, OCRCONFIG, OCRDUMP
- 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 & Alert Log data
- ADR Directory Structure & ADRCI
- Oracle Clusterware trace files and Alert Log 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 a Disk 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 a Non-Interactive mode
Module-4: Admin, Manage Oracle RAC
19. Oracle RAC Architecture
- Instance in RAC
- Single Instance DB Vs RAC DB
- RAC specific Background processes
- Global Resources in RAC
- GCS, GES, GRD
- GCS, GES, GRD
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 in RAC
- 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. Patching RAC Environments
- Patchset, Bundle Patch, One-Off Patch, Patchset Updates
- Rolling Patches, OPatch Utility
- Downloading & Analyzing Patches
- Installing RAC Patches in a Rolling fashion
- Verifying Patch Application
24. Migrating Filesystem Database to ASM
- Why migrate to ASM?
- Basic concepts of migrating to ASM
- Preparing to migrate to ASM
- Migrating Database to ASM
25. Converting Single Instance Database to RAC Database
- Overview of different Methods/Tools
- About rconfig utility
- Preparing XML file
- Converting to RAC using rconfig
- Verifying the conversion

Requirements
- A Windows, Linux or Mac PC/Laptop with Internet Connection
- Knowledge about Unix/Linux
- Knowledge about Oracle Database Administration

Key Features
- 30 hours of high quality training
- Hands-on practices for every lesson
- Access to session recordings
- Training by Real time & Hands-on RAC expert
- In-depth coverage and thorough explanation of all lessons

FAQ

1. What about Lab practice?

You can practice all the lab sessions on our RAC Lab or choose to practice on your personal laptop/desktop system.

2. How do I access Lab?

You can use our VPN based access to connect to the Lab and practice.

3. What if I miss a session?

We provide recordings of each session you attend for future reference.

4. What if I discontinue the training in between?

You can attend any future training that suits your schedule.

Oracle RAC

Live Online Trainings

Course Duration: 4 Weeks

Fee:- INR 25,000

Self-paced Recorded Trainings - INR 15,000

Course Description

Course Instructor

Course Curriculum

Module-1: Basics & Concepts

1. Introduction to Clusters

2. Introduction to Oracle Real Application Clusters (RAC) 12c

3. Overview of Oracle RAC Infrastructure

4. Overview of Oracle Clusterware

5. Oracle ASM Concepts

6. Overview of Oracle 12c Flex Cluster & Flex ASM

Module-2: Installation, Configuration

7. Preparing for Oracle 12c Grid Infrastructure Installation

8. Installing Oracle 12c Grid Infrastructure

9. Installing & Creating Oracle 12c RAC Database

Module-3: Admin, Manage Oracle Grid Infrastructure

10. Administering Oracle Clusterware

11. Administering Oracle 12c Flex Clusters

12. Oracle Clusterware Diagnostic & Alert Log data

13. Cluster Health Monitor(CHM)

14. Using Cluster Verification Utility (CVU)

15. Administering ASM Instances

16. Administering ASM Disk Groups

17. Administering ASM Directories & Files

18. ASM Command-Line Utility (ASMCMD)

Module-4: Admin, Manage Oracle RAC

19. Oracle RAC Architecture

20. Administering RAC Instances & Database

21. Backup & Recovery in RAC

22. Workload Management with Services

23. Patching RAC Environments

24. Migrating Filesystem Database to ASM

25. Converting Single Instance Database to RAC Database

Requirements

Key Features

FAQ

Quick Links

Important Links

Social