CHAPTER 14RAC Troubleshooting

In this chapter we look into the details of debugging Oracle Real Application Clusters, from simple startup problems to complex system hang or crash problems. As a single piece of software, Oracle RDBMS is the one of the most complex commercial products in the world. But with the help of a solid and extensive diagnostics framework, you can usually diagnose even complex problems simply by viewing and interpreting Oracle’s detailed trace files.

Each instance in a cluster has its own alert logs, which will be the first and foremost thing to examine whenever a problem is reported. Alert logs show detailed information about the basic settings of the database, including the non-default parameters used. Alert logs also ...

Get Oracle Database 10g Real Application Clusters Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.