Oracle

Database 10g R2: RAC for Administrators

Course Code: D47380GC20      Days: 5
Show all Oracle Database 10g Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Central London
City
London (EC2) 14/07/08 £ 2,888
London (EC2) 28/07/08 £ 2,888
London (EC2) 11/08/08 £ 2,888
England
Manchester (Greater)
Manchester (SK8) 21/07/08 £ 2,888
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer OracleClusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification.

  • Install Oracle Clusterware and Real Application Clusters
  • Administer a RAC Database
  • Administer Database Services in a RAC environment
  • Administer Oracle Clusterware
  • Add/Remove a node to/from a cluster
  • Patch Oracle Clusterware and RAC software in a rolling fashion

Audience

  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers
  • Project Manager
  • Support Engineer
  • System Analysts
  • Technical Administrator
  • Technical Consultant

Prerequisites

  • Single-instance Oracle Database 10g Architecture and Experience
  • Oracle Database 10g: Administration Workshop I Release 2
  • Oracle Enterprise Manager 10g Grid Control Release 2NEW
  • Oracle Database 10g: Administration Workshop II Rel 2

Skills Gained

  • Identify Real Application Clusters components
  • Install, create, administer, and monitor a Real Application Clusters database
  • Use configuration and management tools for Real Application Clusters databases
  • Setup services for workloads management, and applications high availability
  • Develop a backup and recovery strategy for Real Application Clusters databases
  • Configure and monitor Oracle Clusterware resources
  • Review high availability best practices

Course Outline

Identify Real Application Clusters components

  • Understand Real Application Clusters
  • Clusters Scalability and High Availability
  • The Necessity of Global Resources
  • Parallel Execution with RAC
  • RAC Software and Database Principles
  • RAC and Shared Storage Technologies
  • Understand VIPs
  • Describe the benefits of Fast Application Notification

Install, create, administer, and monitor a Real Application Clusters database

  • Describe the installation of Oracle RAC 10g
  • Perform RAC pre-installation tasks
  • Perform cluster setup tasks
  • Install Oracle Clusterware
  • Install and configure Automatic Storage Management (ASM)
  • Install the Oracle database software
  • Create a cluster database
  • Install the Enterprise Manager agent on each cluster node

Use configuration and management tools for Real Application Clusters databases

  • Use Enterprise Manager cluster database pages
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Start and stop RAC databases and instances
  • Modify initialization parameters in a RAC environment
  • Manage ASM instances in a RAC environment
  • Determine RAC-specific wait events, global enqueues, and system statistics
  • Implement the most common RAC tuning tips

Setup services for workloads management, and applications high availability

  • Configure and manage services in a RAC environment
  • Set performance-metric thresholds on services
  • Configure services aggregation and tracing
  • Configure server-side connect-time load balancing
  • Use the Load Balancing Advisory
  • Configure server-side callouts
  • Configure the server- and client-side ONS
  • Configure Transparent Application Failover (TAF)

Develop a backup and recovery strategy for Real Application Clusters databases

  • Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
  • Configure RMAN for the RAC environment

Configure and monitor Oracle Clusterware resources

  • Manually control the Oracle Clusterware stack
  • Change voting disk and OCR configuration
  • Back up or recover your voting disks and OCR files
  • Change VIP addresses
  • Use the CRS framework
  • Collect Oracle Clusterware diagnostic files
  • Enable Oracle Clusterware debugging

Review high availability best practices

  • Add a new node to your cluster database
  • Remove a node from your cluster database
  • Design a Maximum Availability Architecture in your environment
  • Decide on the best ASM configuration to use
  • Patch your RAC system in a rolling fashion


How to make a booking for the D47380GC20 course

 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership