ORA-7445 Troubleshooting

 

QUICKLINK: Note 7445.1 ORA-600/ORA-7445 Lookup tool
Note 1082674.1 : A Video To Demonstrate The Usage Of The ORA-600/ORA-7445 Lookup Tool [Video]

 Have you observed an ORA-07445 error reported in your alert log?

While the ORA-600 error is "captured" as a handled exception in the Oracle source code, the ORA-7445 is an unhandled exception error due to an OS exception which should result in the creation of a core file.  An ORA-7445 is a generic error, and can occur from anywhere in the Oracle code. The precise location of the error is identified by the core file and/or trace file it produces.  

Looking for the best way to diagnose?

Whenever an ORA-7445 error is raised a core file is generated.  There may be a trace file generated with the error as well.

 

Prior to 11g, the core files are located in the CORE_DUMP_DEST directory.   Starting with 11g, there is a new advanced fault diagnosability infrastructure to manage trace data.  Diagnostic files are written into a root directory for all diagnostic data called the ADR home.   Core files at 11g will go to the ADR HOME/cdump directory.   For more information on the Oracle 11g Diagnosability feature see

Note 453125.1 11g Diagnosability Frequently Asked Questions

Note 443529.1 11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support[Video]

 

NOTE:  While the core file is captured in the Diagnosability infrastructure, the file may not be included with a diagnostic package.

1.  Check the Alert Log

The alert log may indicate additional errors or other internal errors at the time of the problem.   In some cases, the ORA-7445 error will occur along with ORA-600, ORA-3113, ORA-4030 errors.  The ORA-7445 error can be side effects of the other problems and you should review the first error and associated core file or trace file and work down the list of errors.

 

Note 1020463.6 DIAGNOSING ORA-3113 ERRORS

Note 1812.1 TECH:  Getting a Stack Trace from a CORE file

Note 414966.1 RDA Documentation Index

 

If the ORA-7445 errors are not associated with other error conditions, ensure the trace data is not truncated. If you see a message at the end of the file

 

"MAX DUMP FILE SIZE EXCEEDED"

 

the MAX_DUMP_FILE_SIZE parameter is not setup high enough or to 'unlimited'. There could be vital diagnostic information missing in the file and discovering the root issue may be very difficult.  Set the MAX_DUMP_FILE_SIZE appropriately and regenerate the error for complete trace information.

For pointers on deeper analysis of these errors see

 

Note 390293.1 Introduction to 600/7445 Internal Error Analysis

Note 211909.1 Customer Introduction to ORA-7445 Errors

2.  Search 600/7445 Lookup Tool

Visit My Oracle Support to access the ORA-00600 Lookup tool (Note 7445.1). The ORA-600/ORA-7445 Lookup tool may lead you to applicable content in My Oracle Support on the problem and can be used to investigate the problem with argument data from the error message or you can pull out key stack pointers from the associated trace file to match up against known bugs.

3.  "Fine tune" searches in Knowledge Base

As the ORA-7445 error indicates an unhandled exception in the Oracle source code, your search in the Oracle Knowledge Base will need to focus on the stack data from the core file or the trace file.

Keep in mind that searches on generic argument data will bring back a large result set.  The more you can learn about the environment and code leading to the errors, the easier it will be to narrow the hit list to match your problem.

Note 7445.1 ORA-600/ORA-7445 Troubleshooter
Note 1082674.1 A Video To Demonstrate The Usage Of The ORA-600/ORA-7445 Lookup Tool [Video]

NOTE:  If no trace file is captured, see Note 1812.1 TECH:  Getting a Stack Trace from a CORE file.  Core files are managed through 11g Diagnosability, but are not packaged with other diagnostic data automatically.  The core files can be quite large, but may be useful during analysis within Oracle Support.


4.  If assistance is required from Oracle

Should it become necessary to get assistance from Oracle Support on an ORA-7445 problem, please provide at a minimum, the

  • Alert log
  •  Associated tracefile(s) or incident package at 11g
  • Patch level  information
  • Core file(s)
  •  Information about changes in configuration and/or application prior to  issues
  •  If error is reproducible, a self-contained reproducible testcase: Note.232963.1 How to Build a Testcase for Oracle Data Server Support to Reproduce ORA-600 and ORA-7445 Errors
  • RDA report or Oracle Configuration Manager information
  • Oracle Configuration Manager Quick Start Guide
  • Note 548815.1 My Oracle Support Configuration Management FAQ
  • Note 414966.1 RDA Documentation Index


***For reference to the content in this blog, refer to Note 1092855.1 Master Note for Diagnosing ORA-7445



Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

News and Troubleshooting tips for Oracle Database and Enterprise Manager

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today