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.
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 ...