Vendor Management Strategies for the CIOOracle 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:
-DTRACING.ENABLED=true -DTRACING.LEVEL=2 - 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.
Requires Membership to View
To gain access to this and all member only content, please provide the following information:
By submitting your registration information to SearchSystemsChannel.com you agree to receive email communications from the TechTarget network of sites, and/or third party content providers that have relationships with TechTarget, based on your topic interests and activity, including updates on new content, event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile, unsubscribing via email or by contacting us here
- Your use of SearchSystemsChannel.com is governed by our Terms of Use
- We designed our Privacy Policy to provide you with important disclosures about how we collect and use your registration and other information. We encourage you to read the Privacy Policy, and to use it to help make informed decisions.
- If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States.
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