2007-06-20

ORA-600/ORA-7445 Troubleshooter

Everyone dreads the Oracle ORA-00600 and ORA-07445 errors: they are the most esoteric errors in Oracle.

A tool called "ORA-600/ORA-7445 Troubleshooter" is available at Metalink to help figuring out what is happening and maybe to solve it.
It asks for the first argument of ORA-00600/ORA-07445 error with an optional database version number.

For example, to see the description of the error:

ORA-00600: internal error code, arguments: [723], [25908], [25908], [memory leak]

You enter 723 in the "ORA-600 First Argument" field.

Did you knew that the first argument is a pointer to where in the code the error was caught and thus is the key information in identifying the problem?

You can also copy and paste the "Call Stack Trace" there and then when you click on the "Search Call Stack" button an advanced MetaLink search is performed to find documents containing relevant sections from the call stack.

Call Stack extracts from the following files are supported:
  • Generic foreground and background server trace files located in background_dump_dest and user_dump_dest
  • OpenVMS NETV2 and BEQ log files located in ORA_ROOT:[NETWORK.LOG]
  • WINDOWS CORE.LOG files
  • GDB (debugger) backtrace call stacks (best endeavors)

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.