Oracle 11g R1/R2 Real Application Clusters Essentials

In this book you’ll find a practical tutorial on configuring, installing, and designing Oracle 11g Real Application Clusters. Packed with real-world examples and troubleshooting tips, it aims to make the complex as simple as possible.

Oracle 11g R1/R2 Real Application Clusters Essentials

Progressing
Ben Prusinski, Syed Jaffer Hussain

In this book you’ll find a practical tutorial on configuring, installing, and designing Oracle 11g Real Application Clusters. Packed with real-world examples and troubleshooting tips, it aims to make the complex as simple as possible.
$41.99
$69.99
RRP $41.99
RRP $69.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free Sample

Book Details

ISBN 139781849682664
Paperback552 pages

About This Book

  • Understand sophisticated components that make up your Oracle RAC environment such as the role of High Availability, the RAC architecture required, the RAC installation and upgrade process, and much more!
  • Get hold of new Oracle RAC components such as the new features of Automatic Storage Management (ASM), performance tuning, and troubleshooting.
  • Packed with practical, real-world examples, expert tips and troubleshooting advice on how to administer a complex Oracle 11g RAC environment.
  • Bonus Oracle 11g RAC R2 information included with this book and e-book
  • This book is the updated release of our previous Oracle 11g R1/R2 Real Application Clusters Handbook. If you already own a copy of that Handbook, there is no need to upgrade to this book.

Who This Book Is For

If you are an Oracle DBA who wants to administer Real Application Clusters, then this book is for you. Basic understanding of Oracle DBA is required. No experience of Oracle RAC is required.

Table of Contents

Chapter 1: High Availability
High availability concepts
Fault-tolerant systems and high availability
High availability solutions for Oracle
Summary
Chapter 2: Oracle 11g RAC Architecture
Oracle 11g RAC architecture
Hardware architecture for Oracle 11g RAC
Network architecture for Oracle 11g RAC
Storage architecture for Oracle 11g RAC
Storage protocols for RAC
Oracle 11g RAC components
New ASM features and RAC
New Oracle 11g ASM Disk Group compatibility features
Summary
Chapter 3: Clusterware Installation
Preparing for a cluster installation
Oracle 11g R1 Clusterware installation
Oracle 11g R2 Clusterware installation
Removing/Reconfiguring a Grid Infrastructure configuration
Summary
Chapter 4: Automatic Storage Management
Overview of Automatic Storage Management (ASM)
ASM instance configuration and management
Overview of ASMCMD
ASM 11g R1 new features
ASM 11g R2 new features
ASM backup strategies
Summary
Chapter 5: Managing and Troubleshooting Oracle 11g Clusterware
Oracle 11g RAC Clusterware administration
Managing Oracle 11g Clusterware utilities
Troubleshooting Oracle 11g Clusterware
New features in Oracle 11g R2 Clusterware
Summary
Chapter 6: RAC Database Administration and Workload Management
RAC database configuration and creation
What's new in Oracle 11g R1 and R2 databases?
RAC database administration
Automatic Workload Management
What's new in Oracle 11g services' behavior?
Summary
Chapter 7: Backup and Recovery
An overview of backup and recovery
An overview of Recovery Manager (RMAN)
Backup types and methods
RMAN new features in 11g R1 and 11g R2
RMAN best practices for RAC
OCR and Voting disk backup and recovery strategies
Summary
Chapter 8: Performance Tuning
Tuning differences: single instance versus RAC
New Oracle 11g performance tuning features
New performance features in Oracle 11gR2
Analyzing the Cache Fusion impact on RAC performance
Monitoring RAC cluster interconnect performance
Oracle cluster interconnects
Monitoring RAC wait events
Summary
Chapter 9: Oracle 11g Clusterware Upgrade
Overview of an upgrade
Upgrading Oracle 10g R2 Clusterware to Oracle 11g R1
Upgrading to Oracle 11g R2 Clusterware
Downgrading Oracle Clusterware after an upgrade
Summary
Chapter 10: Real-world Scenarios
Adding a new node to an existing cluster
Removing a node from the cluster
Adding an RAC database instance
Deleting an RAC database instance
Converting a single-instance database to an RAC database
Converting a single-instance database to an RAC database
Relocating an RAC database and instances across nodes
Summary
Chapter 11: Enabling RAC for EBS
EBS architecture
Oracle 11g RAC suitability
Installing EBS 12.1.1
EBS implementation on Oracle 11g RAC
RAC-enabling EBS 12.1.1
Establishing applications environment for Oracle RAC
Setting up load balancing
Configuring Parallel Concurrent Processing
Cloning EBS concepts in brief
Summary
Chapter 12: Maximum Availability
Oracle 11g Streams for RAC
Best practices for Streams in an RAC environment
New features for Streams in Oracle 11g R2
Oracle 11g Data Guard and RAC
New features for Data Guard in Oracle 11g R2
Summary

What You Will Learn

  • Learn how to administer, implement, and manage Oracle 11g RAC environments for real world deployments
  • Discover the key architectural design and installation techniques required to successfully deploy Oracle 11g RAC
  • Effectively manage the complex 11g Clusterware, using key troubleshooting tips and techniques
  • Successfully implement database creation methods, manage the Oracle RAC database and handle workload in your RAC environment efficiently
  • Appropriately plan your backup and recovery strategy
  • Know when and how to upgrade your Oracle RAC environment effectively
  • Discover how to deploy Oracle 11g RAC with complex standard-off-the-shelf systems like Oracle EBS
  • Understand new key features for Oracle 11g R1/R2 RAC and ASM

In Detail

Oracle RAC or Real Application Clusters is a grid computing solution that allows multiple nodes (servers) in a clustered system to mount and open a single database that resides on shared disk storage. Should a single system (node) fail, the database service will still be available on the remaining nodes. Oracle RAC is an integral part of the Oracle database setup. You have one database with multiple users accessing it, in real time. This book will enable DBAs to get their finger on the pulse of the Oracle 11g RAC environment quickly and easily.

This book will cover all areas of the Oracle RAC environment and is indispensable if you are an Oracle DBA who is charged with configuring and implementing Oracle11g R1, with bonus R2 information included. This book presents a complete method for the configuration, installation, and design of Oracle 11g RAC, ultimately enabling rapid administration of Oracle 11g RAC environments.

This practical handbook documents how to administer a complex Oracle 11g RAC environment. Packed with real world examples, expert tips and troubleshooting advice, the book begins by introducing the concept of Oracle RAC and High Availability. It then dives deep into the world of RAC configuration, installation and design, enabling you to support complex RAC environments for real world deployments. Chapters cover Oracle RAC and High Availability, Oracle 11g RAC Architecture, Oracle 11g RAC Installation, Automatic Storage Management, Troubleshooting, Workload Management and much more.

By following the practical examples in this book, you will learn every concept of the RAC environment and how to successfully support complex Oracle 11g R1 and R2 RAC environments for various deployments within real world situations.

This book is the updated release of our previous Oracle 11g R1/R2 Real Application Clusters Handbook. If you already own a copy of that Handbook, there is no need to upgrade to this book.

Authors

Table of Contents

Chapter 1: High Availability
High availability concepts
Fault-tolerant systems and high availability
High availability solutions for Oracle
Summary
Chapter 2: Oracle 11g RAC Architecture
Oracle 11g RAC architecture
Hardware architecture for Oracle 11g RAC
Network architecture for Oracle 11g RAC
Storage architecture for Oracle 11g RAC
Storage protocols for RAC
Oracle 11g RAC components
New ASM features and RAC
New Oracle 11g ASM Disk Group compatibility features
Summary
Chapter 3: Clusterware Installation
Preparing for a cluster installation
Oracle 11g R1 Clusterware installation
Oracle 11g R2 Clusterware installation
Removing/Reconfiguring a Grid Infrastructure configuration
Summary
Chapter 4: Automatic Storage Management
Overview of Automatic Storage Management (ASM)
ASM instance configuration and management
Overview of ASMCMD
ASM 11g R1 new features
ASM 11g R2 new features
ASM backup strategies
Summary
Chapter 5: Managing and Troubleshooting Oracle 11g Clusterware
Oracle 11g RAC Clusterware administration
Managing Oracle 11g Clusterware utilities
Troubleshooting Oracle 11g Clusterware
New features in Oracle 11g R2 Clusterware
Summary
Chapter 6: RAC Database Administration and Workload Management
RAC database configuration and creation
What's new in Oracle 11g R1 and R2 databases?
RAC database administration
Automatic Workload Management
What's new in Oracle 11g services' behavior?
Summary
Chapter 7: Backup and Recovery
An overview of backup and recovery
An overview of Recovery Manager (RMAN)
Backup types and methods
RMAN new features in 11g R1 and 11g R2
RMAN best practices for RAC
OCR and Voting disk backup and recovery strategies
Summary
Chapter 8: Performance Tuning
Tuning differences: single instance versus RAC
New Oracle 11g performance tuning features
New performance features in Oracle 11gR2
Analyzing the Cache Fusion impact on RAC performance
Monitoring RAC cluster interconnect performance
Oracle cluster interconnects
Monitoring RAC wait events
Summary
Chapter 9: Oracle 11g Clusterware Upgrade
Overview of an upgrade
Upgrading Oracle 10g R2 Clusterware to Oracle 11g R1
Upgrading to Oracle 11g R2 Clusterware
Downgrading Oracle Clusterware after an upgrade
Summary
Chapter 10: Real-world Scenarios
Adding a new node to an existing cluster
Removing a node from the cluster
Adding an RAC database instance
Deleting an RAC database instance
Converting a single-instance database to an RAC database
Converting a single-instance database to an RAC database
Relocating an RAC database and instances across nodes
Summary
Chapter 11: Enabling RAC for EBS
EBS architecture
Oracle 11g RAC suitability
Installing EBS 12.1.1
EBS implementation on Oracle 11g RAC
RAC-enabling EBS 12.1.1
Establishing applications environment for Oracle RAC
Setting up load balancing
Configuring Parallel Concurrent Processing
Cloning EBS concepts in brief
Summary
Chapter 12: Maximum Availability
Oracle 11g Streams for RAC
Best practices for Streams in an RAC environment
New features for Streams in Oracle 11g R2
Oracle 11g Data Guard and RAC
New features for Data Guard in Oracle 11g R2
Summary

Book Details

ISBN 139781849682664
Paperback552 pages
Read More