OIN1001 : Real Application Clusters.

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

Comments are closed.