111: Oracle Services on RAC: How They Work and What You Should Use Them For
Jeremy Schneider , IT Convergence    Biography

Objectives: Understand the differences between services in single-instance and RAC environments.
Review the role of services in load balancing and failover.
Learn configuration internals and see services’ impact on distributed db and parallel execution.
Abstract: In RAC databases, Services are a crucial, integral part of the plumbing that provides high availability and database fault-tolerance. They are the only feature whose configuration is spread across both the data dictionary and the clusterware registry. Understanding them is a basic, core responsibility of anyone who plans or maintains Oracle cluster database systems. This session will closely examine how services work in RAC. First are the similarities and differences between single-instance and cluster databases; such as methods to create, delete, modify, start and stop services. We will also discuss limits and best practices. Next, we examine where service configuration is stored – no less than four places. This leads into a discussion of clusterware integration. Other topics covered include load balancing, failover, cluster notifications, distributed databases and parallel execution. Several 11g enhancements also discussed. The session aims to cover every aspect of services on RAC.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Architecture
Date: Tuesday, April 15, 2008
Time: 1:45 PM - 2:45 PM