Oracle RAC: Debugging CRS and GSD using DTRACING

Oracle RAC tracing facility can be enabled to provide additional screen output in Oracle 10g. The steps are outlined in this excerpt from "Oracle Database 10g: Real Application Clusters Handbook."

Oracle RAC: Debugging CRS and GSD using DTRACING

Oracle Server management configuration tools include a diagnostic and trace facility. For verbose output for SRVCTL, GSD, GSDCTL, or SRVCONFIG, tracing can be enabled to provide additional screen output. The following steps explain the process of setting and tracing the other programs:

  1. vi the file in the $ORACLE_HOME/bin directory. In Windows, right-click the OraHomebingsd.bat file and choose Edit.
  2. At the end of the file, look for the following line: exec $JRE -classpath $CLASSPATH oracle.ops.mgmt.daemon.OPSMDaemon $MY_OHOME
  3. Add the following just before the -classpath in the exec $JRE line: -DTRACING.ENABLED=true -DTRACING.LEVEL=2
  4. At the end of the file, the string should now look like this: exec $JRE -DTRACING.ENABLED=true -DTRACING.LEVEL=2 -classpath.....

NOTE Beginning with Oracle Database 10gd, setting the environment variable SRVM_TRACE to true traces all the SRVM files such as GSD, SRVCTL, and OCRCONFIG.

In a Nutshell

In this chapter, you have seen the basic to advanced methods of collecting diagnostic information when a hang situation occurs. You also studied the steps in node reconfiguration and IMR internals. Most of the complex problems may require assistance from Oracle Support, and this chapter will help you when dealing with Oracle Support personnel.

Use the following table of contents to navigate to chapter excerpts or click here to view RAC Troubleshooting in its entirety.

Oracle Database 10g: Real Application Clusters Handbook
  Home: Oracle RAC troubleshooting: Introduction
  1: Oracle RAC: Log directory structure in cluster ready services
  2: Oracle RAC: Log directory structure in Oracle RDBMS
  3: Oracle RAC and the Lamport algorithm
 4: Oracle RAC: ON and OFF
  5: Oracle RAC: Database performance issues
  6: Oracle RAC: Debugging node eviction issues
  7: Oracle RAC: Member voting
  8: Oracle RAC: Cluster reconfiguration steps
  9: Oracle RAC: Debugging CRS and GSD using DTRACING
About the book:   
Oracle Database 10g: Real Applications Clusters Handbook Learn to implement Oracle real application clusters from the ground up. Maximize database availability, scalability, and efficiency. Find RAC concepts, administration, tuning, and troubleshooting information. You'll learn how to prepare and create Oracle RAC databases and servers, and automate administrative tasks. You'll also get full coverage of cutting-edge Oracle RAC diagnostic tools, backup and recovery procedures, performance tweaks and custom application design strategies. Buy this book at McGraw-Hill/Osborne
About the author:   
K Gopalakrishnan is a senior principal consultant with the Advanced Technology Services group at Oracle Corporation, specializing exclusively in performance tuning, high availability, and disaster recovery. He is a recognized expert in Oracle RAC and Database Internals and has used his extensive expertise in solving many vexing performance issues all across the world for telecom giants, banks, financial institutions, and universities.

Dig Deeper on Database software management