Unique online training methodology to help a DBA sharpen his real application clusters skills with limited time and resources.
Audience: Oracle DBAs who want to master Oracle Real Application clusters.
Read About our Unique Online Training Model and Lab Setup.
Online RAC Training Course outline.
Module 1: Introduction to Real Application clusters. (Duration: Session 1 hr)
- Introduction to Clustering
- Active/passive Vs Active-Active Clusters.
- What is real application clusters.
- What is Oracle Clusterware and what is RAC.
- Advantages of RAC.
- Overview of infrastructure required for Basic RAC Setup.
- Comparison between oracles 11.1. Or 10g RAC and 11.2 RAC.
Module 2: Setup your RAC (Duration Session 1 hr, Install Lab 5 hr)
- Prepare the infrastructure for RAC.
- Prepare the OS for RAC (Solaris/Linux)
- Prepare the network for RAC. Understand Network requirements for Oracle Clusterware.
- Prepare the Shared Storage for RAC (ASM or CFS).
- run the Cluster verify run cluvfy)
- Install Oracle Clusterware.
- Install Oracle RAC software.
- Creating a RAC Database.
Module 3: Administering Clusterware (Duration Session 2 Hr, Lab 5 hr)
- Verifying Clusterware
- Understanding various processes that constitutes to Clusterware.
- Understanding Clusterware log locations.
- Understanding various Clusterware configuration files.
- Understanding OLR
- understanding OCR
- understanding Voting Disk
- Add /Remove Voting disks.
- Add/ remove OCR mirror.
- Relocating OCR from one location to another.
- Moving OCR to ASM
- Taking OCR backups.
- Automatic OCR backups.
- Restoring OCR.
- Restoring Voting disk
- Restoring OCR/Voting disk on ASM.
- SCAN Single Client Access name Configuring SCAN.
- Changing SCAN NAME after installation.
- SCAN listeners.
- Modifying SCAN Listener.
- Introduction to changing network configuration –What is possible and what is not possible.
- Changing public IP address
- Changing VIP address
- Changing private IP address
- Configuring clients to access database via SCAN.
- Understanding the connections via SCAN – a close look.
Module 4: Adding and Removing Node (Session 1 hr, Lab 4 hrs)
- Adding node to Clusterware
- Extending RAC software to new node.
- Adding instance to new node.
- Configuring listener.
- Removing a node from Cluster.
Module 5: Managing Clusterware Software (Session 1 hr, lab 3 hrs)
- Understanding patchset, one-off patches, PSUs.
- Applying patchset
- Applying one-off patch.
- Applying PSU- using new opatch auto option.
- Upgrading Clusterware
- Rolling patches.
Module 6: Managing Services on RAC. (Session 1 hr, lab 1 hrs)
- Default Services
- Create service with srvctl
- Administer Services with srvctl
- TAF- Transparent Application failover.
Module 7: Administering RAC DATABASE (Session 1 hr, lab 2 hrs)
- Start /stop RAC instances
- Srvctl
- Specifying parameter file used by srvctl
- Modifying dependency on ASM
- Table space special considerations for undo /temp
- A close look at RAC Specific Parameters.
- Understanding Redo logs and threads.
- Understanding instance recovery.
- Understanding cache fusion
- Cache fusion internals.
Module: 8 Backup and Recovery on RAC. (Session 1 hr, lab 3 hrs)
- Archive Log file configurations.
- Recovery in RAC
- RMAN and RAC
- Configure snapshot controlfile.
- Configuring channels.
- Different backup schemes
- Restore and Recovery from a Complete Loss scenario
Module 9: Basics of ASM (Session 1 hr, lab 2 hrs)
- Understanding ASM instances in RAC.
- Creating diskgroup
- Adding disk
- Removing disk.
Module 10: Troubleshooting Clusterware. (Session 1 hr, lab 2 hrs)
- Some of the common scenarios of failure and identifying the root cause.
Module 11: RAC ONE overview. (Session 1 hr, lab 1 hrs)
Module 12: Manually removing a RAC installation (Session 1 hr, lab 1 hrs)
Module 13: Single instance to RAC Conversion. (Session 1 hr, lab 1 hrs)
Module 14 : RAC interview Questions and Discussions.(optional)
To schedule your training, please contact us : contact@orainvicta.com or orainvicta@gmail.com