Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677
Oracle Database 11g: Real Application Clusters (RAC) enable high utilization of a cluster of standard, low-cost modular servers and offers high availability, scalability, and important grid computing features. This course provides an introduction to Oracle Database 11g: Real Application Clusters (RAC) and demonstrates how to fulfill the pre-installation requirements for Oracle Clusterware as well as how to install and configure Clusterware. It also demonstrates the installation of Automatic Storage Management (ASM) and Oracle Database software and then explains how to install the Enterprise Manager agent on each cluster node. The creation of a cluster database including discussion of the cluster database post installation tasks are also topics that are explored.
Identify key concepts related to Real Application Clusters
Recognize the main features and functions of RAC
Identify the requirements for installing Oracle Clusterware
Recognize how to install and configure Oracle Clusterware
Install Oracle Clusterware
Recognize how to install Automatic Storage Management
Recognize how to install Oracle database software
Recognize how to install Enterprise Manager
Recognize how to create a cluster database
Identify the tasks you perform after creating a cluster database
Install Automatic Storage Management and Oracle database software
Oracle Database 11g has many tools available for administering a RAC Database and Oracle Clusterware, including Oracle Enterprise Manager. This course explains how to use Enterprise Manager cluster database pages to administer a RAC database and how to carry out various administration tasks on Oracle Clusterware. It discusses how to manage RAC instances, Oracle Clusterware and resources, voting disks, VIP addresses and the CRS framework, and initialization parameters. This course also demonstrates how to configure backup and recovery in a RAC environment.
Identify how to use Enterprise Manager cluster database pages
Recognize how to start and stop RAC databases and instances
Recognize how to modify initialization parameters in a RAC environment
Identify ways to manage instances in a RAC environment
Identify ways to manage Oracle Clusterware and resources
Identify the functions of the voting disk and important CSS parameters
Recognize steps you take to configure voting disks
Recognize how to manage OCR files and locations
Recognize the procedure for changing VIP addresses
Recognize how to use the CRS framework to register an application
Recognize RAC recovery and backup settings
Identify how to use RMAN in a RAC environment
Recognize how to configure backup and recovery in RAC
Perform RAC backup and recovery using Enterprise Manager
Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the best performance by tuning your RAC system the same as you would with a single-instance system. The same tuning tools are available for RAC as would be for a single-instance system.
This course explains instance recovery in RAC, describes RAC wait events and latencies, and provides the most common RAC tips for tuning performance in a RAC environment. It also discusses how to monitor and diagnose RAC performance using Enterprise Manager and Automatic Database Diagnostic Monitor (ADDM). In addition, it demonstrates in detail how to use the Cluster Database Performance pages to monitor RAC database and cluster performance.
Identify how instance recovery works in a RAC environment
Recognize typical wait events and latencies for RAC
Identify the most common RAC tuning tips
Identify factors that affect tuning in a RAC environment
Recognize how to use the Cluster Database Performance pages to monitor RAC database and cluster performance
Recognize how to discover RAC performance problems using ADDM and Enterprise Manager
Recognize how to fix performance problems in RAC
Discover RAC performance problems using Enterprise Manager
A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing competing applications running within a single instance and across multiple instances and databases. Using standard interfaces, such as the Database Configuration Assistant, Enterprise Manager, and SRVCTL, services can be configured, administered, enabled, disabled, and measured as a single entity.
This course provides an introduction to services and discusses how to configure, modify, and use services in a RAC environment. It explains how to use services with client applications, Resource Manager, and the Scheduler, and explores service aggregation and tracing. This course also demonstrates how to create and relocate a service, as well as how to set alert thresholds for a service.
Identify the role of services in a RAC environment
Recognize how to use distributed transactions with RAC
Recognize how to create and modify services in a RAC environment
Recognize how to use services with RAC client applications, Resource Manager, and the Scheduler
Recognize how to set alert thresholds for a RAC service
Recognize the function of service aggregation and tracing in a RAC environment
Recognize how to use Enterprise Manager and SRVCTL to manage services in a RAC environment
Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and debugging Oracle Clusterware and RAC components.
This course discusses the basics of debugging and the use of diagnostics in a RAC environment, including how to use Oracle Clusterware diagnostic files, the DIAG process, and the Cluster Verification Utility (CVU). In addition, it explains and demonstrates in detail the steps involved in adding and removing nodes and instances in a RAC cluster using the Database Configuration Assistant (DBCA). Adding an instance to a RAC Database using Enterprise Manager (EM) is also covered.
Recognize how to carry out diagnostics-related activities on Oracle Clusterware components
Identify how to enable debugging in RAC
Add a node to a RAC cluster
Recognize how to add nodes and instances in a RAC database
Recognize how to delete nodes and instances in a RAC database
In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without loss of data.
This course explains how to configure connections for high availability using various types of workload distribution and load balancing, including Fast Application Notification (FAN), Fast Connection Failover (FCF), and Transparent Application Failover (TAF). It also discusses designing for high availability by minimizing downtime using Data Guard, Data Guard Broker, rolling upgrades, ASM, various forms of RAID, and Extended RAC.
Recognize how to configure workload distribution features
Identify the characteristics and benefits of Fast Application Notification
Recognize how to configure server-side callouts
Recognize how to use the Load Balancing Advisory
Recognize how to configure TAF
Download patch updates and set ASM preferred disks
Identify how RAC and Data Guard provide protection during downtime
Recognize the function of the Oracle Data Guard Broker
Recognize how to perform rolling upgrades
Recognize which mirroring and striping configurations provide the best availability