CRS & RAC Troubleshooting

Defining the Issue Layers

What layers are involved in the issue:

• Oracle Clusterware
  • CRS daemon
  • CSS daemon
  • HangCheckTimer [Linux] / Oprocd (not Linux)
  • EVM
  • OCR
  • Voting
• General RDBMS
• Operating System
• Hardware

Defining the IssueCause vs. Effects

• Causes:
  • Resource issues
  • Oracle issues
  • OS issues
• Effects:
  • Hangs/Spins
  • Instances Crashes and Evictions
  • Node Reboots and Evictions
  • Oracle Errors (ORA-600, ORA-7445, ORA-29740)

Defining the IssueDescription

• When describing the problem while creating the SR via Metalink it is important that you use phrases that will help identify known issues either in bugs or Metalink content.
• In the body of the SR try to be as detailed as possible about the environment.
• Nobody knows the system better than the you.
• Talk to the sys-admin as well regarding OS/Network related issues.

Creating a Timeline

• A timeline helps identify the times to concentrate on when reviewing files
• A timeline can be built from reviewing the files themselves once they are provided to support but this will only slow resolution time down
• Timelines should include an ordering of cause and effects as well as include all participating nodes
• Include specific times, ie…
• At 3:00am PST we noticed that node2 was hanging.

Gathering DataCRS 10.2.0.x (continued)

• CRS and other resource issues:
  • ORA_CRS_HOME
    • log//cssd/oclsmon
    • log//cssd
    • log//client
    • log//crsd
    • log//evmd
    • log//racg
  • ORACLE_HOME (rdbms)
    • racg/dump
    • ORACLE_BASE//hdump

© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Data Gathering for Troubleshooting CRS Issues
2. Diagnosability for CRS / EVM / RACG
3. How to troubleshooting RAC Vip Problem
4. Data Gathering for Troubleshooting RAC Issues
5. Data gathering for troubleshooting Oracle Real Application Cluster issues
6. Database Links: Troubleshooting ORA-2085 “database link %s connects to %s”
7. Troubleshooting Guide (TSG) – Large Objects (LOBs)
8. Advanced Troubleshooting of CSS Heartbeat Failures (Network)
9. Know about RAC Clusterware Process OPROCD
10. CRS PSU 10.2.0.4.4 Readme (BUNDLE Patch for Base Bug 9294403)