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:
- vi the gsd.sh/srvctl/srvconfig file in the $ORACLE_HOME/bin directory. In Windows, right-click the OraHomebingsd.bat file and choose Edit.
- At the end of the file, look for the following line:
exec $JRE -classpath $CLASSPATH oracle.ops.mgmt.daemon.OPSMDaemon $MY_OHOME
- Add the following just before the -classpath in the exec $JRE line:
- At the end of the gsd.sh 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.
|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.|
This was first published in May 2007