Home > Oracle RAC: Debugging CRS and GSD using DTRACING
Chapter Excerpt:
EMAIL THIS

Oracle RAC: Debugging CRS and GSD using DTRACING

09 May 2007

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

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 gsd.sh/srvctl/srvconfig 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 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.


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.



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Database Clustering and Mirroring
FAQ: SQL Server 2008 high-availability services
Oracle RAC troubleshooting advice and application migration tips
What skill sets do I need to support a fault-tolerant, high-availability system?
Oracle RAC: Log directory structure in cluster ready services
Oracle RAC: Log directory structure in Oracle RDBMS
Oracle RAC: ON and OFF
Oracle RAC and the Lamport algorithm
Oracle RAC: Debugging node eviction issues
Oracle RAC: Cluster reconfiguration steps
Oracle RAC: Member voting

Relational Database Management Systems (RDBMSes)
SQL Server 2008 Reporting Services for high-availability deployment
SQL Server 2008 Reporting Services for Internet deployment
SQL Server 2008 hardware and software requirements
Key features in SQL Server 2008 Reporting Services editions
Optimizing SQL Server 2008 performance
SQL Server 2008 features study guide
Troubleshooting a failed SQL Server 2008 installation
Microsoft SQL Server 2008 guide
Oracle Database 11g study guide
Federated databases

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


HomeNewsTopicsITKnowledge ExchangeTipsMultimediaWhite PapersBlogsEvents
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2006 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts