Book Image

Oracle 11g R1 / R2 Real Application Clusters Handbook

Book Image

Oracle 11g R1 / R2 Real Application Clusters Handbook

Overview of this book

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. RAC is an integral part of the Oracle database setup: one database, 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 practical handbook documents how to administer a complex Oracle 11g RAC environment. It covers all areas of the Oracle 11g R1 RAC environment, with bonus R2 information included, and is indispensable if you are an Oracle DBA charged with configuring and implementing Oracle11g. It presents a complete method for the design, installation, and configuration of Oracle 11g RAC, ultimately enabling rapid administration of Oracle 11g RAC environments.Packed with real-world examples, expert tips, and troubleshooting advice, the book begins by introducing the concept of RAC and High Availability. It then dives deep into the world of RAC design, installation, and configuration, enabling you to support complex RAC environments for real-world deployments. Chapters cover 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 the 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 in real-world situations.
Table of Contents (20 chapters)
Oracle 11g R1/R2 Real Application Clusters Handbook
Credits
About the Authors
About the Reviewers
Preface

Managing Oracle 11g Clusterware utilities


Oracle provides a suite of utilities and scripts that are to be used by the database administrator in charge of an Oracle 11g RAC environment. It is imperative to master these tools so that the 11g Clusterware can be monitored on a proactive basis to avoid any failures or downtimes in the clustered environment for Oracle 11g RAC. The key Clusterware administration utilities that we will discuss in this chapter include the following:

  • CRSCTL (Clusterware Control utility)

  • CRS_STAT (Cluster Ready Services Statistics)

  • OCRCHECK (Oracle Cluster Registry Check Utility)

  • OCRCONFIG (Oracle Cluster Registry Config Utility)

  • CLSCFG (Clusterware Config Tool)

  • CLUVFY (Clusterware Verification Utility)

CRSCTL

The CRSCTL command utility is an essential tool to master in the DBA toolbox for Clusterware maintenance and administration. It provides Clusterware monitoring functions as well as the ability to add and remove key components of the Oracle 11g Clusterware such as adding...