Course

ORACLE 11G RAC

ORACLE 11G RAC TRAINING

DUCAT imparts training in a way that is more practical and efficient. Anyone who wants to learn ORACLE 11G RAC needs to look no further than DUCAT. It gives training so that after the training ORACLE 11G RAC becomes a part of you. ORACLE 11G RAC starts where Oracle Parallel Server ends. It allows someone to approach the same database simultaneously. It ensures full tolerance, load balancing, and of course performance. The heart of this technology is the concept of the shared disk subsystem. In case of system failure, it allows recovery of that node from other nodes. DUCAT imparts training not only through lectures or lessons but by giving real access to ORACLE 11G RAC. One can understand the advantage and disadvantages of this technology only when one feels it which happens during the training at DUCAT. Students learn how to install the process and run it efficiently. The training teaches all the features of ORACLE 11G RAC in depth. DUCAT faculties are the best in this field of technology. They themselves are experts and they make their students also experts. They teach so that their students shine in their field and make themselves proud.

ORACLE GRID INFRASTRUCTURE ARCHITECTURE

  • Oracle Clusterware Concepts
  • What is Clustere?
  • Oracle Clusterware?
  • Oracle Clusterware Architecture
  • Grid Plug and Play (GPnP)
  • Grid Naming Service (GNS)
  • Single Client Access Name (SCAN)

GRID INFRASTRUCTURE INSTALLATION

  • Shared Storage Planning for Grid Infrastructure 2-4
  • OCR and Voting Disk in ASM
  • Checking System Requirements
  • Checking Network Requirements
  • Software Requirements (Kernel)
  • Software Requirements: Packages
  • Creating Groups and Users

ADMINISTERING ASM

  • ASM Initialization Parameters
  • Starting and Stopping ASM Instances by Using srvctl.
  • Starting and Stopping ASM Instances by Using SQL*Plus.
  • Starting and Stopping ASM Instances by Using ASMCA and ASMCMD.
  • Creating a New Disk Group
  • Mounting and Dismounting Disk Groups
  • Dropping Disk Groups
  • kASM Dynamic Performance Views

REAL APPLICATION CLUSTERS DATABASE INSTALLATION

  • Installing the Oracle Database Software 11-3
  • Creating the Cluster Database 11-7
  • Cluster Database Management Options 11-10
  • Initialization Parameters 11-15
  • Database Storage Options 11-16
  • Create the Database 11-17
  • Background Processes Specific to Oracle RAC 11-21
  • Single Instance to RAC Conversion 11-23

ADMINISTERING ORACLE CLUSTERWARE

  • CRSCTL : manages clusterware-related operations
  • SRVCTL : manages Oracle resource�related operations

MANAGING ORACLE CLUSTERWARE

  • Adding the Node in the Cluster.
  • Deleting the Node in the Cluster.

TROUBLESHOOTING ORACLE CLUSTERWARE

  • Golden Rule in Debugging Oracle Clusterware
  • Oracle Clusterware Main Log Files
  • Diagnostics Collection Script
  • Cluster Verify Utility
  • Determining Which Process Caused Reboot
  • Using ocrdump to View Logical Contents of the OCR
  • Checking the Integrity of the OCR
  • OCR-Related Tools for Debugging

UPGRADING AND PATCHING ORACLE RAC

  • Configuring the Software Library
  • Setting Up Patching
  • Obtaining Oracle RAC Patches
  • Downloading Patches
  • Reduced Down-Time Patching for Cluster Environments
  • Rolling Patches

ORACLE RAC ADMINISTRATION

  • Redo Log Files and RAC
  • Automatic Undo Management and RAC
  • Starting and Stopping RAC Instances
  • Starting and Stopping RAC Instances with SQL*Plus
  • Starting and Stopping RAC Instances with srvctl
  • Terminating Sessions on a Specific Instance
  • How SQL*Plus Commands Affect Instances

MANAGING BACKUP AND RECOVERY FOR RAC

  • Protecting Against Media Failure
  • Media Recovery in Oracle RAC
  • Parallel Recovery in RAC
  • Archived Log File Configurations
  • RAC and the Fast Recovery Area

RAC DATABASE MONITORING AND TUNING

  • CPU and Wait Time Tuning Dimensions
  • RAC-Specific Tuning
  • RAC and Instance or Crash Recovery
  • Instance Recovery and Database Availability
  • Instance Recovery and RAC
  • Analyzing Cache Fusion Impact in RAC
  • Typical Latencies for RAC Operations
  • Wait Events for RAC
  • Wait Event Views
  • Global Enqueue Waits: Overview

SERVICES

  • Oracle Services
  • Services for Policy- and Administrator-Managed Databases
  • Default Service Connections
  • Create Service with Enterprise Manager
  • Create Services with SRVCTL
  • Manage Services with Enterprise Manager
  • Managing Services with EM
  • Manage Services with srvctl

DESIGN FOR HIGH AVAILABILITY

  • Causes of Unplanned Down Time
  • Causes of Planned Down Time
  • Oracle's Solution to Down Time
  • RAC and Data Guard Complementarity
  • Maximum Availability Architecture
  • RAC and Data Guard Topologies
  • RAC and Data Guard Architecture
  • Data Guard Broker (DGB) and Oracle Clusterware (OC)
  • Integration