RAC Training

Oracle RAC Administration Course

About Me

Welcome! I am an experienced database administrator specializing in Oracle RAC Administration. I have a passion for teaching and sharing my knowledge with others.

Contact Information

You can reach me via email at contact@br8dba.com

WhatsApp: +65-94693551

Connect with me on LinkedIn: LinkedIn Profile


We are pleased to offer a comprehensive 40 hour training course designed to equip you with the skills to install, configure, and manage Oracle 19c RAC on your personal Oracle VirtualBox environment. This training also aims to enhance your readiness for interviews and career advancement opportunities.

CourseBatchDateTimingsDurationFee
Oracle RAC DBAWeekend (Saturday to Sunday)10-Aug-2024 to 08-Sep-20249 AM - 1 PM IST (4Hrs)5 Weekends15K INR

Please take note of the following details:

  1. Detailed instructions will guide you through setting up Oracle 19c RAC on your personal workstation using VirtualBox.
  2. All concepts will be reinforced through practical lab exercises.
  3. The course content is meticulously crafted to mirror real-world scenarios.
  4. A mock exam with question and answer sessions will be conducted at the conclusion of the course.
  5. Recordings of each session will be provided.
  6. Sessions will be held five weeks, on Saturdays and Sundays, each session lasting 4 hours.
  7. Support for hands-on labs will be available even after completing the course.
  8. Gain practical experience with various RAC testing scenarios.
  9. If this opportunity aligns with your interests, we invite you to register using the link below.

Course Schedule:

DayDateTime
Saturday10-Aug-249:00 AM – 1:00 PM IST
Sunday11-Aug-249:00 AM – 1:00 PM IST
Saturday17-Aug-249:00 AM – 1:00 PM IST
Sunday18-Aug-249:00 AM – 1:00 PM IST
Saturday24-Aug-249:00 AM – 1:00 PM IST
Sunday25-Aug-249:00 AM – 1:00 PM IST
Saturday 31-Aug-249:00 AM – 1:00 PM IST
Sunday 1-Sep-249:00 AM – 1:00 PM IST
Saturday7-Sep-249:00 AM – 1:00 PM IST
Sunday8-Sep-249:00 AM – 1:00 PM IST

For registration, please visit https://www.br8dba.com/training/

We look forward to your participation and learning together.


Course-content

1. Introduction to Oracle RAC
Overview of Oracle RAC
Benefits of using Oracle RAC
Oracle RAC architecture
Oracle Grid Infrastructure components
2. Oracle VirtualBox Installation and Linux Configuration
Introduction to Oracle VirtualBox
Installing Oracle VirtualBox
Downloading and installing VirtualBox on different operating systems
Setting up Virtual Machines in VirtualBox
Creating a new virtual machine
Configuring virtual machine settings (memory, CPUs, storage, etc.)
Installing Linux on Virtual Machines
Downloading a Linux distribution ISO (e.g., Oracle Linux, CentOS, Ubuntu)
Installing Linux on the virtual machine
Configuring Linux for Oracle RAC
Network configuration (static IPs, hostname resolution)
Disk setup for ASM (Automatic Storage Management)
Required Linux packages and dependencies
Kernel parameters and limits configuration
3. Prerequisites for Oracle RAC Installation
System Requirements
Minimum hardware requirements (CPU, memory, storage)
Supported operating systems and versions
Software Requirements
Required software packages and versions
Oracle Grid Infrastructure and Oracle Database software
Kernel Settings
Configuring kernel parameters for Oracle RAC
Users and Groups
Creating Oracle user and groups (oracle, grid, oinstall, dba, asmadmin)
Directories
Creating necessary directories for Oracle software installation
Setting appropriate ownership and permissions
SSH Passwordless Connectivity
Configuring SSH for passwordless connectivity between nodes
Testing SSH connectivity
Runcluvfy Check
Running Cluster Verification Utility (cluvfy) to validate prerequisites
4. RAC Installation and Configuration
Oracle Grid Infrastructure installation
Oracle RAC software installation
5. Oracle ASM Overview and Administration
Introduction to Oracle ASM
Benefits of using Oracle ASM in RAC environments
Oracle ASM architecture
Oracle ASM disk group creation and management
Oracle ASM instance administration
Monitoring and troubleshooting Oracle ASM performance
6. Oracle RAC Database Creation
Creating a RAC database using DBCA (Database Configuration Assistant)
Understanding RAC database instances
Initialization parameters for RAC
7. Administering Oracle RAC
Managing Services in Oracle RAC using srvctl
  Listing Services
  Creating Services
  Modifying Services
  Starting and Stopping Services
  Enabling and Disabling Services
  Service Status
  Removing Services
Starting and Stopping Oracle RAC Instances
   Starting Oracle RAC Instances using srvctl and SQL*Plus
   Stopping Oracle RAC Instances using srvctl and SQL*Plus
Managing Oracle RAC Cluster Start, Stop, and Disable using crsctl
  Starting Oracle RAC Cluster
  Verifying Cluster Startup
  Stopping Oracle RAC Cluster
  Verifying Cluster Shutdown
  Disabling and Enabling Oracle RAC Cluster
8. RAC Network Configuration
RAC listeners
Overview of RAC listeners
Configuring and managing RAC listeners
SCAN (Single Client Access Name)
Introduction to SCAN
Benefits of using SCAN
Configuring and managing SCAN listeners
VIP and public IP
Understanding VIP (Virtual IP) addresses
Configuring and managing VIPs and public IPs
Private IP
Importance of private IP addresses in RAC
Configuring and managing private IPs
9. Overview RAC Daemon Resources
   Oracle High Availability Services Daemon (OHASD)
 Agents
Cluster Ready Services Daemon (CRSD)
Cluster Synchronization Services Daemon (CSSD)
Cluster Synchronization Services Daemon Monitor (CSSD Monitor)
Cluster Time Synchronization Service Daemon (CTSSD)
Event Management Daemon (EVMD)
Grid Inter-process Communication Daemon (GIPCD)
Grid Plug and Play Daemon (GPNPD)
Multicast Domain Name System Daemon (MDNSD)
10. Oracle RAC Clusterware Startup Sequence
11. RAC Backup and Recovery
Configuring RMAN (Recovery Manager) for RAC
Performing backups in a RAC environment
Restoring and recovering a RAC database
12. Adding and Removing Nodes in Oracle RAC
Adding a node to an existing Oracle RAC cluster
Prerequisites and considerations
Configuring network and storage for the new node
Using Grid Infrastructure to add a node
Removing a node from an existing Oracle RAC cluster
Prerequisites and considerations
Removing instances and resources from the node
Post-removal clean-up and configuration updates
13. OCR and Voting Disk Administration
Overview of OCR (Oracle Cluster Registry) and Voting Disk
Understanding the role of OCR and Voting Disk in Oracle RAC
Managing OCR and Voting Disk using CRSCTL commands
Backup and recovery strategies for OCR and Voting Disk
14. Patching Oracle RAC Grid Infrastructure
Understanding Oracle Grid Infrastructure patching requirements
Preparing for Grid Infrastructure patching
Applying patches using Manual and Opatch auto methods
Rolling patching techniques in RAC environments
Known issues
15. Patching Oracle RAC Database Homes
Oracle Database home patching strategies
Applying patches using Manual and Opatch auto methods
Post-patching tasks and validations
16. Upgrading Oracle RAC Grid Infrastructure
Planning an upgrade for Oracle Grid Infrastructure
Preparing the environment for GI upgrade
Performing the upgrade using Oracle Universal Installer (OUI)
Post-upgrade tasks and validations
17. Upgrading Oracle RAC Databases
Planning an upgrade for Oracle RAC databases
Preparing database instances for upgrade
Performing the database upgrade using DBUA (Database Upgrade Assistant) or manual methods
Post-upgrade tasks, testing, and validations
18. Oracle RAC One Node
Introduction to Oracle RAC One Node
Installing RAC Grid Infrastructure (if necessary)
Configuring Oracle RAC One Node
   Managing Oracle RAC One Node
19. Oracle RAC Troubleshooting Grid Infrastructure Startup Issues
20. Oracle Automatic Storage Management Cluster File System (ACFS)
Installing and Configuring Oracle ACFS
Verify ACFS Modules
Creating ACFS Volumes
Creating ACFS File Systems
Registering ACFS File Systems on OCR
Mouting and Unmounting ACFS File Systems
Starting and Stopping ACFS File Systems
21. RAC Data Guard Administration
Creating and configuring physical standby database
Configuring Data Guard broker
Identifying and refreshing gaps in standby databases
Performing switchover
Performing switchback
Converting physical standby to snapshot standby and vice versa
22. RAC Monitoring and Tuning
Performance tuning for RAC
RAC-specific wait events
Using AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor) in RAC
23. Resume Preparation
Tips for creating a strong Oracle RAC-focused resume
Highlighting key skills and experiences
Showcasing certifications and training
Customizing your resume for specific job roles
Interview Questions and Preparation