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
Acknowledgments | p. iii |
Preface | p. xiii |
Chapter 1 Understanding High Availability for Databases | p. 1 |
Assessing the Criticality of a Solution | p. 2 |
Assessing High Availability Requirements for Databases | p. 6 |
Choosing the Correct Configuration to Support HA Requirements | p. 11 |
Protecting Data Beyond Application Availability | p. 15 |
Preparing for Disasters Business Continuity Management | p. 20 |
Chapter 2 Understanding the Benefits of Implementing Oracle RAC on Sun Cluster Software | p. 23 |
Using Oracle on the Solaris Operating System | p. 24 |
Understanding the Value of Oracle and Sun Mature Technologies | p. 28 |
Understanding the Robustness of Sun Cluster Software | p. 28 |
Understanding Options for Accessing Memory Remotely | p. 33 |
Understanding Options for Storing Data | p. 35 |
Supporting Enterprise Continuity Solutions | p. 37 |
Looking at the Future of Oracle and Sun Cluster | p. 42 |
Chapter 3 Understanding the Oracle RAC Architecture and Sun Cluster Software Internals | p. 43 |
Designing a Hardware Architecture to Support High Availability | p. 44 |
Using an Operating System That Supports High Availability | p. 51 |
Examining Sun Cluster Software Internals | p. 54 |
Understanding the Interaction of Sun Cluster Packages for OPS/RAC | p. 70 |
Examining Oracle RAC Functionality | p. 78 |
Chapter 4 Applying Preferred Practices to Oracle RAC and Sun Cluster Implementations | p. 91 |
Installing Oracle RAC in a Sun Cluster 3.x Environment | p. 91 |
Understanding Oracle Data Configuration | p. 101 |
Configuring Data for Oracle RAC | p. 109 |
Configuring Archive Log Locations | p. 116 |
Understanding Client Connections | p. 125 |
Managing Client Connections in Oracle 9i RAC | p. 129 |
Tuning Sun Cluster 3.x Software for Oracle RAC | p. 133 |
Chapter 5 Examining High Availability Real-World Implementations | p. 141 |
Analyzing Real-World Customer Solutions | p. 142 |
Providing High Availability Services in the Banking Sector | p. 144 |
Supporting the Seasonal HA Requirements of the Resort Industry | p. 153 |
Improving Performance With Oracle RAC and Sun's Remote Shared Memory | p. 159 |
Addressing HA With an HA Oracle Agent in a Consolidated Environment | p. 161 |
Appendix A History of Oracle's Parallel Database Technology | p. 165 |
Sun Cluster 2.x and Oracle OPS | p. 166 |
Cluster Architectures and Oracle Parallel Server Technology | p. 175 |
Oracle's Cache Coherency Protocol | p. 178 |
The Famous Ping | p. 178 |
Always in Turn Please Enqueues | p. 180 |
Oracle 9i: Cache Fusion II All Fusion? | p. 182 |
Appendix B Sample Service Level Agreement | p. 183 |
Service Levels | p. 185 |
Appendix C Examples of the scsetup Utility | p. 187 |
Setting Up the Oracle RAC Framework Resource Group | p. 187 |
Registering a VxVM Diskgroup in the Cluster With the scsetup Utility | p. 190 |
Registering VxVM Volumes With the scsetup Utility | p. 192 |