Oracle Database 10g: RAC for Administrators

Level:
Costs:
Total time:
Provider rating: 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)
Logo Perpetual Solutions

Tip: Receive more information about the programme, starting dates & price. Or request a proposal from multiple providers for in-house training.

Overview

Your experience of this course?

Did you attend the course Oracle Database 10g: RAC for Administrators at Perpetual Solutions? Help other people by submitting your review at Springest!

Springest will donate £1.- to the Edukans Foundation as a thank you for each review

 
Schedule:
Daytime
Run time:
5 days
Location type:
Open

vat information, completion, maximum participants, and starting dateplaces are unknown for this course.

Prerequisites:

A working knowledge of Oracle Database Administration is required. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended.

Course Description:

This Oracle 10g RAC Configuration & Administration course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC).Delegates will learn how to install, create, configure and administer a database for use with RAC.Delegates will learn how to setup and use Automatic Storage Management (ASM) and Oracle Clusterware in a RAC environment.

The delegate will practise:

  • Installing and configuring an Oracle 10g RAC Database
  • Admini…

Read the complete description

Description

Prerequisites:

A working knowledge of Oracle Database Administration is required. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended.

Course Description:

This Oracle 10g RAC Configuration & Administration course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC).Delegates will learn how to install, create, configure and administer a database for use with RAC.Delegates will learn how to setup and use Automatic Storage Management (ASM) and Oracle Clusterware in a RAC environment.

The delegate will practise:

  • Installing and configuring an Oracle 10g RAC Database
  • Administering and Monitoring a RAC database using Enterprise Manager and command line tools
  • Using configuration and management tools for RAC databases
  • Administering ASM using command line and GUI clients
  • Setting up services for workload management and application high availability
  • Backing up, restoring and recovering a RAC database
  • Creating duplicate and standby databases in a RAC Environment
  • Monitoring and tuning the performance of a RAC database

This course includes the following modules:

Oracle Real Application Clusters Overview

  • Oracle RAC Features
  • Oracle RAC Technology Hierarchy
  • Oracle RAC Capabilities
  • Oracle RAC Components
  • Tools for Installing, Configuring and Managing Oracle RAC

Oracle Grid Infrastructure Overview

  • Cluster Overview
  • Oracle Clusterware Components and RAC
  • Oracle Clusterware Software and Storage
  • Oracle Storage Subsystems
  • File Types used by a RAC Database
  • Methods used to Share Database Files across a Cluster
  • ASM Architecture
  • Create and Manage ASM Disk Groups
  • An Overview of RAC Services
  • Network Configuration

RAC Pre-Installation Tasks

  • Oracle RAC Pre-installation Tasks
  • Create Oracle Groups, User Accounts and Directories
  • Validate and Prepare the Hardware and the Operating System
  • Network Configuration

Install Oracle Real Application Clusters

  • Cluster Verification Utility
  • Install Oracle Database Software and Create a Cluster Database
  • Verify the Installation
  • Post Installation Tasks
  • Configure Client Connections with Oracle Net Manager
  • RAC Specific Background Processes

RAC Cluster Database and Database Instance Administration

  • RAC Initialization Parameters
  • Manage Undo Tablespaces in a RAC Environment
  • Manage Redo Log Files and Groups in a RAC Environment
  • Oracle Enterprise Manager Cluster Database Pages
  • Start and Stop Oracle RAC Databases and Instances
  • Administer Database Storage
  • Transparent Data Encryption and Wallets in RAC

Administer Oracle Clusterware Components

  • Manage CRS Commands
  • CRSCTL Commands to Stop, Start and Administer Clusterware
  • Backup and Recover Voting Disks
  • Add and Remove Voting Disks
  • The ocrcheck Utility
  • The ocrdump Command
  • Administer the Oracle Cluster Registry (OCR)
  • Backup and Restore OCR
  • Troubleshoot the OCR with ocrcheck

ASM Instance Administration

  • ASM Initialization Parameters
  • Create an ASM Instance using ASMCA
  • Start and Stop an ASM Instance using srvctl
  • Start and Stop an ASM Instance using ASMCMD
  • Start and Stop an ASM Instance Containing Cluster Files
  • Start and Stop the ASM Listener

ASM Disk Group Administration

  • Create and Delete ASM Disk Groups
  • ASM Disk Group Attributes
  • ASM Disk Group Maintenance Tasks
  • Preferred Read Failure Groups
  • ASM Disk Statistics

RAC Management Commands

  • RAC Management Commands
  • RAC Administration with SVRCTL
  • SVRCTL Cluster Database Configuration Tasks
  • SVRCTL Cluster Database Administration Tasks
  • Check the Current Configuration
  • SVRCTL Command Summary
  • Administer Databases and Instances
  • Administer Services and Node Applications
  • Bring a Cluster Database online and offline
  • Introduction to CRS
  • Cluster Services

Managing the Database Workload Using Services

  • Manage the Database Workload using Services
  • Create and Administer Services in a RAC Environment
  • Services and Client Applications
  • Manage Services with Enterprise Manager and from the Command Line
  • Configure Oracle Net to Support Services
  • Configure Service Level Thresholds
  • Configure Clients for Failover

High Availability of Connections

  • RAC High Availability Framework
  • Failure Detection with Cluster Services
  • Oracle RAC and Hardware Failover
  • Connection Failover
  • Transparent Application Failover (TAF)
  • Server, Client And Runtime Load Balancing
  • Fast Application Notification (FAN)
  • Server and Client Side Oracle Notification Services

Backup and Recover a RAC Database

  • Configure a Fast Recovery Area for use with RAC
  • Tune Instance Recovery in RAC
  • Parallel Recovery in RAC
  • Initiate Archiving
  • Configure RMAN Backup and Recovery Settings
  • Backup a RAC Database using RMAN
  • Restore and Recover a RAC Database using RMAN
  • Display Backup Reports

Create Duplicate and Standby Databases with RAC

  • Duplicate a RAC Database with RMAN
  • Standby Database in a RAC Configuration
  • Configure Data Guard for a RAC Environment
  • Possible Combinations of Instances in the RAC Primary and Standby Databases
  • Multi Instance Primary with a Single Instance Standby
  • Set up a Primary in a RAC Environment
  • Set up a Single Instance Standby Database
  • Set up a Multiple Instance Primary and Cluster Standby
  • Configure RAC Primary and Standby Databases
  • Data Protection Modes
  • Role Transition Switchovers and Failovers
  • Switchover Failover in an Oracle RAC Configuration

RAC Performance Tuning

  • Monitoring and Performance Guidelines
  • RAC Monitoring Tools
  • RAC Performance Recommendations
  • Analyze Performance Issues using OS Watcher and LTOM
  • Use the Automatic Workload Repository in RAC
  • Use the Automatic Database Diagnostic Monitor in RAC
  • Use Statspack with RAC
  • Global Cache Services (GCS) Monitoring
  • V$cache_transfer Views
  • Monitor the GES Processes
  • Monitor and Tune the RAC Cluster Environment using Enterprise Manager

Add and Delete Nodes and Clusters

  • Prepare a New Node
  • Add the New Node to the Cluster
  • Create an Instance on the New Node
  • Delete an Instance from the Cluster Database
  • Remove a Node from the Cluster

Manage Oracle Software and Apply Patches

  • Configure the EM Patch Interface
  • Obtain Patches
  • Apply Rolling Patches to a RAC System
  • Apply a Patchset with the opatch Utility

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

Reviews

There are no reviews yet. Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

In-company offer

Ask for a quote on a customised training course.
Maximum 3 relevant providers will directly respond.

More courses within this subject:

Compare 36,062 training courses in subjects like Oracle 10G

Subscribe to our newsletter?

Receive news, tips, articles, interviews and education on personal development each month.

Sign up to create your own Learning Lists.

Not for humans