Cover image for Creating highly available database solutions : oracle real application clusters (RAC) and sun cluster 3.X software
Title:
Creating highly available database solutions : oracle real application clusters (RAC) and sun cluster 3.X software
Personal Author:
Series:
Official Sun Microsystems resource series
Publication Information:
Santa Clara, CA : Sun Microsystems, 2005
Physical Description:
xviii, 208 p. : ill. ; 24 cm.
ISBN:
9780131863903
Added Author:

Available:*

Library
Item Barcode
Call Number
Material Type
Item Category 1
Status
Searching...
30000010176212 QA76.9.D3 H47 2005 Open Access Book Book
Searching...

On Order

Summary

Summary

This book explains how to architect and deploy high availability (HA) solutions with Oracle Real Application Clusters (Oracle RAC) in a Sun(tm) Cluster 3.x environment. It presents information to help you decide when an Oracle RAC and Sun Cluster software solution is appropriate to satisfy the availability requirements of your business. In addition, this book explains the technology behind these products, describes successful customer deployments, and provides technical tips and preferred practice recommendations.

This book features detailed case studies, including

A large German bank that has implemented an Oracle RAC and Sun Cluster software solution to meet the ever-increasing business demands of the banking industry. One of the largest companies in Europe for alpine skiing that has implemented Oracle RAC and Sun Cluster software to support HA requirements in a consolidated environment. A benchmark case that describes the use of Oracle RAC with Sun's Remote Shared Memory (RSM) technology to improve the performance of single-instance databases. A large financial institution that uses Sun Cluster's HA Oracle agent to provide the necessary level of HA required for their database.


Author Notes

Kristien Hens is currently working as a Technology System Engineer, focusing on storage and cluster technologies. Before that she worked for four years for Sun Educational Services. She has taught storage and Sun Cluster courses to customers and Sun engineers. She has also developed and taught the courses "Oracle 9i for Sun Engineers" and "Oracle 9i RAC on Sun Cluster 3.x Workshop." She is coauthor of three Sun BluePrints OnLine articles.

Michael Loebmann has been the local senior systems engineer for the ISV Oracle in Germany for three years. His tasks include both the exchange of technical knowledge between Oracle and Sun and customer consultation with regard to competition. He has been working in the computer field since 1990, and for Oracle since 1993. He has more than nine years of experience with Oracle products, especially in Oracle data warehousing and parallel Oracle databases (OPS and RAC). His specialties include Oracle performance tuning on Solaris and the investigation of database performance on storage subsystems.


Excerpts

Excerpts

The purpose of this Sun BluePrints book is to helps customers and Sun staff to architect and deploy high availability highly available (HA) solutions with Oracle Real Application Clusters (Oracle RAC) in a Sun Cluster 3.x environment. It provides information to help you decide when an Oracle RAC and Sun Cluster software solution is appropriate to satisfy the availability requirements of your business. In addition, this book explains the technology behind these products and provides customer cases of successful deployments, technical tips, and preferred practice recommendations. After reading this book, you should be able to perform the following tasks: Assess the availability requirements of your business Choose the correct configuration for your specific HA requirements Explain the benefits of implementing Oracle RAC in a Sun Cluster environment Provide a high-level view of the Oracle RAC architecture and the Sun Cluster software internal functionality Install Oracle RAC in a Sun Cluster environment Configure data for use with Oracle RAC Manage client connections Tune an Oracle RAC and Sun Cluster 3.x solution To illustrate the benefits, costs, and requirements of various HA solutions, we provide the following detailed case studies: A large German bank that has implemented an Oracle RAC and Sun Cluster software solution to meet the ever-increasing business demands of the banking industry. One of the largest companies in Europe for alpine skiing that has implemented Oracle RAC and Sun Cluster software to support HA requirements in a consolidated environment. A benchmark case that shows how to use Oracle RAC with the Sun's Remote Shared Memory (RSM) technology to improve performance of single instance databases. A large financial institution that uses the Sun Cluster's HA Oracle agent to provide the necessary level of HA required for their database. How This Guide Is Organized This guide is organized in the following chapters: Chapter 1 presents a common definition for HA, explains the importance of using accepted processes to assess the availability requirements of your business, and describes some standard business processes used to support HA. In addition, it provides overviews of HA Oracle and Oracle RAC as tools for supporting HA requirements and presents information to help you choose the option that best satisfies your availability requirements. Chapter 2 describes the benefits of using Oracle RAC with Sun Cluster software. Chapter 3 describes the Oracle RAC architecture and the Sun Cluster software internals and explains how they work together to address HA requirements. Chapter 4 provides preferred practice recommendations for implementing Oracle RAC and Sun Cluster software solutions. Chapter 5 describes four customer cases that show how customers have successfully implemented Oracle RAC and Sun Cluster solutions to satisfy their unique availability requirements. These cases explain situations in which when an Oracle RAC scenario makes sense and communicates the expert knowledge of customers who have implemented Sun solutions. Appendix A provides an historical overview of the continuous development path of parallel database technology, describes the evolution of cache fusion and Sun Cluster software, and explains how these early advancements have affected the current state of database technology. Appendix B presents a high-level outline of the areas that should be addressed in a typical service level agreement (SLA) and provides some detail for the areas that are relevant to the discussion of supporting HA. Appendix C presents examples for using the scsetup utility. Excerpted from Creating Highly Available Database Solutions: Oracle Real Application Clusters (RAC) and Sun Cluster 3. x Software by Kristien Hens, Michael Loebmann All rights reserved by the original copyright owners. Excerpts are provided for display purposes only and may not be reproduced, reprinted or distributed without the written permission of the publisher.

Table of Contents

Acknowledgmentsp. iii
Prefacep. xiii
Chapter 1 Understanding High Availability for Databasesp. 1
Assessing the Criticality of a Solutionp. 2
Assessing High Availability Requirements for Databasesp. 6
Choosing the Correct Configuration to Support HA Requirementsp. 11
Protecting Data Beyond Application Availabilityp. 15
Preparing for Disasters Business Continuity Managementp. 20
Chapter 2 Understanding the Benefits of Implementing Oracle RAC on Sun Cluster Softwarep. 23
Using Oracle on the Solaris Operating Systemp. 24
Understanding the Value of Oracle and Sun Mature Technologiesp. 28
Understanding the Robustness of Sun Cluster Softwarep. 28
Understanding Options for Accessing Memory Remotelyp. 33
Understanding Options for Storing Datap. 35
Supporting Enterprise Continuity Solutionsp. 37
Looking at the Future of Oracle and Sun Clusterp. 42
Chapter 3 Understanding the Oracle RAC Architecture and Sun Cluster Software Internalsp. 43
Designing a Hardware Architecture to Support High Availabilityp. 44
Using an Operating System That Supports High Availabilityp. 51
Examining Sun Cluster Software Internalsp. 54
Understanding the Interaction of Sun Cluster Packages for OPS/RACp. 70
Examining Oracle RAC Functionalityp. 78
Chapter 4 Applying Preferred Practices to Oracle RAC and Sun Cluster Implementationsp. 91
Installing Oracle RAC in a Sun Cluster 3.x Environmentp. 91
Understanding Oracle Data Configurationp. 101
Configuring Data for Oracle RACp. 109
Configuring Archive Log Locationsp. 116
Understanding Client Connectionsp. 125
Managing Client Connections in Oracle 9i RACp. 129
Tuning Sun Cluster 3.x Software for Oracle RACp. 133
Chapter 5 Examining High Availability Real-World Implementationsp. 141
Analyzing Real-World Customer Solutionsp. 142
Providing High Availability Services in the Banking Sectorp. 144
Supporting the Seasonal HA Requirements of the Resort Industryp. 153
Improving Performance With Oracle RAC and Sun's Remote Shared Memoryp. 159
Addressing HA With an HA Oracle Agent in a Consolidated Environmentp. 161
Appendix A History of Oracle's Parallel Database Technologyp. 165
Sun Cluster 2.x and Oracle OPSp. 166
Cluster Architectures and Oracle Parallel Server Technologyp. 175
Oracle's Cache Coherency Protocolp. 178
The Famous Pingp. 178
Always in Turn Please Enqueuesp. 180
Oracle 9i: Cache Fusion II All Fusion?p. 182
Appendix B Sample Service Level Agreementp. 183
Service Levelsp. 185
Appendix C Examples of the scsetup Utilityp. 187
Setting Up the Oracle RAC Framework Resource Groupp. 187
Registering a VxVM Diskgroup in the Cluster With the scsetup Utilityp. 190
Registering VxVM Volumes With the scsetup Utilityp. 192