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 Oracle Clusterware, 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.

Learn To:

• 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

Please note: Georgetown University is an Oracle Workforce Training Partner. This course qualifies as the hands-on course requirement for the Oracle Database 10g Administrator Certification and the Oracle Database 10g: RAC Administrator Certified Expert Certification.

Prerequisites:

• Oracle Enterprise Manager 10g Grid Control Release 2 (and)
• Oracle Database 10g: Administration Workshop I Release 2 (and)
• Oracle Database 10g: Administration Workshop II Release 2

Objectives

• 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

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