Book Image

Oracle 11g R1/R2 Real Application Clusters Essentials

Book Image

Oracle 11g R1/R2 Real Application Clusters Essentials

Overview of this book

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.
Table of Contents (20 chapters)
Oracle 11g R1/R2 Real Application Clusters Essentials
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Clusterware startup sequence for Oracle 11g R2


Understanding how the clusterware startup occurs is critical to the diagnosis and resolution of Oracle RAC problems.

In Unix and Linux operating systems, there is a master daemon process named INIT that functions to start up additional system background processes. The INIT process first spawns the init.ohasd process, which in turn starts up the Oracle High Availability Services Daemon (OHASD). In turn, the OHASD daemon then spawns additional Clusterware processes at each startup level as shown next:

  • Level 1—OHASD spawns:

    • Cssdagent: Agent responsible for spawning CSSD

    • Orarootagent: Agent responsible for managing all root-owned ohasd resources

    • Oraagent: Agent responsible for managing all Oracle-owned ohasd resources

    • cssdmonitor: Monitors CSSD and node health (along wth the cssdagent)

  • Level 2—OHASD rootagent spawns:

    • Cluster Ready Services Daemon (CRSD)—primary daemon responsible for managing cluster resources

    • Cluster Time Synchronization Services Daemon (CTSSD)

    • Diskmon—provides disk monitoring services

    • ASM Cluster File System (ACFS) Drivers 

During the second level of startup for Clusterware, the oraagent spawns the following Clusterware processes for 11g R2:

  • MDNSD: Used for DNS lookup

  • GIPCD: Used for inter-process and inter-node communication

  • GPNPD: Grid Plug and Play Profile Daemon

  • EVMD: Event Monitor Daemon

  • ASM: Resource for monitoring ASM instances

  • Level 3—CRSD spawns:

    • orarootagent: Agent responsible for managing all root-owned CRSD resources

    • oraagent: Agent responsible for managing all Oracle-owned CRSD resources

  • Level 4—CRSD rootagent spawns:

    • Network resource: To monitor the public network

    • SCAN VIP(s): Single Client Access Name Virtual IPs

    • Node VIPs: One per node

    • ACFS Registery: For mounting ASM Cluster File system

    • GNS VIP (optional): VIP for GNS

During this phase for Clusterware startup with 11g R2, the oraagent spawns the following processes:

  • ASM Resouce: ASM Instance(s) resource

  • Diskgroup: Used for managing/monitoring ASM diskgroups 

  • DB Resource: Used for monitoring and managing the DB and instances

  • SCAN Listener: Listener for single client access name, listening on SCAN VIP

  • Listener: Node listener listening on the Node VIP

  • Services: Used for monitoring and managing services

  • ONS: Oracle Notification Service

  • eONS: Enhanced Oracle Notification Service

  • GSD: For 9i backward compatibility

  • GNS (optional): It is a grid naming service that performs name resolution

Log file locations for Oracle 11g RAC and ASM

The important Clusterware daemon logs are located under the <GRID_HOME>/log/<nodename> directory. There are additional logfiles located under the <GRID_HOME>/log/<nodename>directory as listed next:

alert<NODENAME>.log - look here first for most clusterware issues
./admin:
./agent:
./agent/crsd:
./agent/crsd/oraagent_oracle:
./agent/crsd/ora_oc4j_type_oracle:
./agent/crsd/orarootagent_root:
./agent/ohasd:
./agent/ohasd/oraagent_oracle:
./agent/ohasd/oracssdagent_root:
./agent/ohasd/oracssdmonitor_root:
./agent/ohasd/orarootagent_root:
./client:
./crsd:
./cssd:
./ctssd:
./diskmon:
./evmd:
./gipcd:
./gnsd:
./gpnpd:
./mdnsd:
./ohasd:
./racg:
./racg/racgeut:
./racg/racgevtf:
./racg/racgmain:
./srvm:

The cleanup of these logfiles can be automated with a shell script that can be scheduled to run from the cron facility. The cfgtoollogs directory located under the $GRID_HOME and $ORACLE_BASE directories contains other important logfiles such as the rootcrs.pl script and configuration assistants, such as the ASM Configuration Assistant (ASMCA).

ASM logs are located under $ORACLE_BASE/diag/asm/+asm/<ASM Instance Name>/trace

Oracle provides a useful script named diagcollection.pl, which can be found under the <GRID_HOME>/bin directory. This script, when executed, will automatically collect important Oracle 11g Clusterware files that can be sent to Oracle support engineers for analysis. You must be logged into Linux as the root user in order to run this script.