Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
Overview of Oracle Real Application Clusters (RAC)
- Introduction to Oracle RAC and its architecture
- Benefits of RAC in high availability and scalability
- Key components of RAC: Cluster nodes, Clusterware, and ASM
Grid Infrastructure Fundamentals
- Understanding Oracle Grid Infrastructure
- Role of Oracle Clusterware in RAC
- Overview of Automatic Storage Management (ASM)
Installing Oracle Grid Infrastructure
- Hardware and software prerequisites for Grid Infrastructure
- Installation and configuration of Oracle Grid Infrastructure
- Configuring network and storage for RAC
Preparing the Environment for RAC
- Preparing shared storage with ASM
- Configuring the network environment for RAC
- Setting up SSH equivalency and user environments
Installing Oracle RAC
- Step-by-step RAC installation process
- Post-installation tasks for Oracle RAC
- Verifying RAC installation and troubleshooting common issues
Administering RAC Databases
- Creating and managing RAC databases
- RAC-specific administration tasks
- Understanding RAC database instances and services
Oracle Clusterware Administration
- Managing Clusterware components: Voting disks and OCR
- Configuring and managing High Availability Services (HAS)
- Monitoring and troubleshooting Clusterware
RAC Backup and Recovery
- Backup strategies for RAC environments
- Performing backup and recovery in RAC
- Using RMAN for RAC databases
Introduction to ASM
- Understanding the architecture and benefits of ASM
- ASM components: Disk groups, disks, and ASM instances
- Installing and configuring ASM
Administering ASM Disk Groups
- Creating and managing ASM disk groups
- ASM disk group redundancy and performance
- Monitoring and maintaining ASM disk groups
ASM Instance Management
- Starting and stopping ASM instances
- ASM instance parameters and tuning
- ASM and Clusterware integration
ASM Backup and Recovery
- Backup and recovery strategies for ASM
- Using RMAN with ASM
- Best practices for ASM management
RAC Performance Tuning
- Tuning RAC database performance
- Monitoring and optimizing RAC workloads
- Using Oracle Enterprise Manager for RAC performance tuning
High Availability and Disaster Recovery in RAC
- Implementing Oracle Data Guard with RAC
- Configuring RAC for disaster recovery
- RAC failover and switchover scenarios
RAC Troubleshooting and Diagnostics
- Diagnosing and resolving RAC issues
- Using Clusterware diagnostics and logs
- Best practices for RAC troubleshooting
Patching and Upgrading RAC and Grid Infrastructure
- Patching RAC databases and Grid Infrastructure
- Performing rolling upgrades in RAC environments
- Downtime minimization techniques during upgrades
Advanced ASM Features
- Implementing ASM Flex and Flex Clusters
- ASM cluster file system (ACFS) overview and configuration
- ASM monitoring and alerting mechanisms
Advanced Grid Infrastructure Administration
- Configuring and managing Oracle Flex Clusters
- Managing Clusterware resources and services
- Using Oracle Cluster Registry (OCR) and voting disk management
Securing RAC and Grid Infrastructure
- Implementing security best practices in RAC environments
- Configuring ASM security features
- Managing user roles and privileges in Grid Infrastructure
Best Practices for RAC, ASM, and Grid Infrastructure
- High availability and scalability best practices
- Performance optimization strategies
- Implementing automation for RAC and ASM management
Summary and Next Steps
Requirements
- Basic understanding of Oracle database administration
- Familiarity with SQL and PL/SQL
Audience
- Database administrators
- IT professionals
35 Hours
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Course - ORACLE PL/SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
