e-Commerce Applications Using Oracle8i and Java from Scratch

Common Problems in Oracle Systems

When running an Oracle system, the following types of errors are commonly encountered:

• Database Crash— A database crash can be evidenced in the form of an error message such as ORA-600 errors, an access violation, or other error messages that may appear in the alert log or the application. The actual process of diagnosing the error will depend on the exact error you encounter. An ORA-600 error or access violation normally (99 percent of the time) generates a trace file in the dump destination and an entry is placed in the alert log (this entry can help in finding out the name and location of the trace file). The trace file contains important diagnostic information such as the stack trace, memory dump, process ...