O'Reilly logo

Oracle® 11g For Dummies® by Michael Wessler, Chris Ruel, Chris Zeis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Troubleshooting an Oracle Database

In This Chapter

  • Using troubleshooting methodology

  • Troubleshooting with Oracle database logs

  • Employing other diagnostic utilities

No matter what the salespeople claim, any system made by mortal beings will have issues and sometimes even break; that's reality. Worse yet, those same salespeople who claimed their system was perfect aren't around to fix it when it does break; that's your job. Fortunately, this chapter provides the information you need.

Before jumping into database-specific diagnostic techniques, we give you a method for troubleshooting at the system level. Remember: Oracle exists as part of an overall information system. Here you explore the methods and tools you need to operate at system level.

Oracle provides a wealth of information, almost an overload, in its multiple log and trace files. Between the different files and tracing levels, odds are the information you need to solve the problem is there somewhere...if you know where to look for it. We provide that info.

Just when you thought you couldn't get any more information about your Oracle database, we do just that via Oracle diagnostic tools and scripts. We're not showing tools that provide pointless data; we explain tools that provide fast, actionable information.

Troubleshooting with System Methodology

If an Oracle crash hasn't happened to you yet, it will happen sometime. And when it does, it won't be at a convenient time.

The problem is that people assume that because they ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required