Creating Highly Available Database Solutions: Oracle Real Application Clusters (RAC) and Sun Cluster 3. x Software

Overview

This book explains how to architect and deploy high availability (HA) solutions with Oracle Real Application Clusters (Oracle RAC) in a Sun™ 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 ...

See more details below
Paperback
$46.19
BN.com price
(Save 16%)$54.99 List Price
Other sellers (Paperback)
  • All (10) from $8.34   
  • New (7) from $44.13   
  • Used (3) from $8.34   
Sending request ...

Overview

This book explains how to architect and deploy high availability (HA) solutions with Oracle Real Application Clusters (Oracle RAC) in a Sun™ 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.
Read More Show Less

Product Details

Meet the Author

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.

Read More Show Less

Read an Excerpt

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.
Read More Show Less

Table of Contents

Acknowledgments iii

Preface xiii

Chapter 1: Understanding High Availability for Databases 1

Assessing the Criticality of a Solution 2

Assessing High Availability Requirements for Databases 6

Choosing the Correct Configuration to Support HA Requirements 11

Protecting Data–Beyond Application Availability 15

Preparing for Disasters–Business Continuity Management 20

Chapter 2: Understanding the Benefits of Implementing Oracle RAC on Sun Cluster Software 23

Using Oracle on the Solaris Operating System 24

Understanding the Value of Oracle and Sun Mature Technologies 28

Understanding the Robustness of Sun Cluster Software 28

Understanding Options for Accessing Memory Remotely 33

Understanding Options for Storing Data 35

Supporting Enterprise Continuity Solutions 37

Looking at the Future of Oracle and Sun Cluster 42

Chapter 3: Understanding the Oracle RAC Architecture and Sun Cluster Software Internals 43

Designing a Hardware Architecture to Support High Availability 44

Using an Operating System That Supports High Availability 51

Examining Sun Cluster Software Internals 54

Understanding the Interaction of Sun Cluster Packages for OPS/RAC 70

Examining Oracle RAC Functionality 78

Chapter 4: Applying Preferred Practices to Oracle RAC and Sun Cluster Implementations 91

Installing Oracle RAC in a Sun Cluster 3.x Environment 91

Understanding Oracle Data Configuration 101

Configuring Data for Oracle RAC 109

Configuring Archive Log Locations 116

Understanding Client Connections 125

Managing Client Connections in Oracle 9i RAC 129

Tuning Sun Cluster 3.x Software for Oracle RAC 133

Chapter 5: Examining High Availability Real-World Implementations 141

Analyzing Real-World Customer Solutions 142

Providing High Availability Services in the Banking Sector 144

Supporting the Seasonal HA Requirements of the Resort Industry 153

Improving Performance With Oracle RAC and Sun’s Remote Shared Memory 159

Addressing HA With an HA Oracle Agent in a Consolidated Environment 161

Appendix A: History of Oracle’s Parallel Database Technology 165

Sun Cluster 2.x and Oracle OPS 166

Cluster Architectures and Oracle Parallel Server Technology 175

Oracle’s Cache Coherency Protocol 178

The Famous Ping 178

Always in Turn Please–Enqueues 180

Oracle 9i: Cache Fusion II–All Fusion? 182

Appendix B: Sample Service Level Agreement 183

Service Levels 185

Appendix C: Examples of the scsetup Utility 187

Setting Up the Oracle RAC Framework Resource Group 187

Registering a VxVM Diskgroup in the Cluster With the scsetup Utility 190

Registering VxVM Volumes With the scsetup Utility 192

Read More Show Less

Preface

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.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)