ORA-07445 exception encountered: core dump - 3 steps to resolve

March 22, 2024 | 7 minute read
Gareth Chapman
Senior Principal Program Manager
Text Size 100%:

The error ORA-07445 exception encountered: core dump, can occur anywhere within Oracle code. It's caused by an operating system exception occurring which should result in the creation of a core file.

The error message will show the Oracle function that was executing when it encountered the error and other variables such as memory addresses.

Follow these step-by-step instructions for everything you need to do to resolve ORA-07445.

 

 

Understanding ORA-07445

The ORA-07445 exception encountered: core dump occurs because an operating system exception occurring which should result in the creation of a core file.

The error message will show the Oracle function that was executing when it encountered the error and other variables such as memory addresses.

ORA-07445 Error Structure

 

An entry will be made in the database alert log, which will point to a trace file containing a stack trace of the code leading up to the problem..

ORA-07445 trc file

 

The error is usually causes by either

  • Bad data
  • Severe misconfiguration
  • Bug

The impact can vary from just being an annoyance that shows up in your logs once in a while, to something major that brings the database down.

ORA-07445 Error Troubleshooting Steps

The basic Fix Flow steps for ORA-07445 are:

  1. Use AHF to generate and ORA-07445 Service Request Data Collection (SRDC)
  2. Use ORA-07445 Troubleshooting Tool to find recommendations
  3. Log a new SR using the diagnostic collection

1. Use AHF to generate an ORA-07445 Service Request Data Collection (SRDC)

In the first step we're going to use AHF to generate an ORA-07445 diagnostic collection.

 

The Autonomous Health Framework, or AHF provides a series of capabilities aimed at making it easier for you to maintain your database.

It's the same technology Oracle uses in the cloud to keep the Autonomous Database running, and it's available for you at no extra cost as part of your existing software support agreement.

AHF Services

You can download AHF by logging into My Oracle Support and searching for AHF or you can just go to http://bit.ly/oracleahf, which will take you directly to the download page.

 

AHF diagnostic collection service

AHF is capable of collecting various types of diagnostic collections, with problem specific SRDCs being one of them.

Before AHF, Oracle Support might have asked you to go through many different steps as part of SRDC or Service Request Data Collection for ORA-07445. This would involve collecting and trimming different logs and running scripts, to understand how to perform it correctly required watching a video and reading other knowledge documents.

Now all this SRDC logic is packaged within AHF and you can capture it all with a single command.

 

Login to the machine where the ORA-07445 occurred and as the Oracle user run the command:

tfactl diagcollect –srdc ORA-07445

You'll be prompted to enter the date and time of the ORA-07445 you're interested in, and then the database name

For example

$ tfactl diagcollect -srdc ORA-07445
Enter the time of the ORA-07445 [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : 2024-03-11 10:11:22
Enter the Database Name [Required for this SRDC] : cdb19

Components included in this collection: OS DATABASE NOCHMOS ASM SOSREPORT

Preparing to execute support diagnostic scripts.

Collecting data for local node(s).

TFA is using system timezone for collection, All times shown in PDT.
Scanning files from 2024-03-11 09:41:22 PDT to 2024-03-11 10:14:32 PDT

Collection Id : 20240311101444mymachine1

Detailed Logging at : /u01/app/grid21/oracle.ahf/data/repository/srdc_ora7445_collection_Mon_Mar_11_10_14_47_PDT_2024_node_local/diagcollect_20240311101444_mymachine1.log

Waiting up to 120 seconds for collection to start
2024/03/11 10:14:52 PDT : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2024/03/11 10:14:52 PDT : Collection Name : tfa_srdc_ora7445_Mon_Mar_11_10_14_46_PDT_2024.zip
2024/03/11 10:14:53 PDT : Collecting Additional Diagnostic Information...
2024/03/11 10:14:53 PDT : Getting list of files satisfying time range [03/11/2024 09:41:22, 03/11/2024 10:14:32]
2024/03/11 10:15:34 PDT : Executing TFA rdahcve with timeout of 600 seconds...
2024/03/11 10:15:36 PDT : Executing IPS Incident Package Collection(s)...
2024/03/11 10:15:38 PDT : Generating IPS Pack for 1 incidents on database cdb19
2024/03/11 10:15:46 PDT : Executing SQL Script db_feature_usage.sql on cdb19 with timeout of 600 seconds...
2024/03/11 10:15:46 PDT : Executing Collection for ASM with timeout of 1800 seconds...
2024/03/11 10:15:56 PDT : Collecting ADR incident files...
2024/03/11 10:16:07 PDT : Executing Collection for AFD with timeout of 1860 seconds...
2024/03/11 10:16:11 PDT : Executing Collection for OS with timeout of 1920 seconds...
2024/03/11 10:16:15 PDT : Executing Collection for SOSREPORT with timeout of 1980 seconds...
2024/03/11 10:17:54 PDT : Completed Collection of Additional Diagnostic Information...
2024/03/11 10:17:58 PDT : Completed Local Collection
2024/03/11 10:17:58 PDT : Not Redacting this Collection on Exadata with no redaction option passed ..
2024/03/11 10:17:58 PDT : Not Redacting this Collection ...
2024/03/11 10:17:58 PDT : Collection completed on host: mymachine1
2024/03/11 10:17:58 PDT : Completed collection of zip files.

.---------------------------------------.
|           Collection Summary          |
+-------------+-----------+------+------+
| Host        | Status    | Size | Time |
+-------------+-----------+------+------+
| mymachine1  | Completed | 44MB | 185s |
'-------------+-----------+------+------'

Logs are being collected to: /u01/app/grid21/oracle.ahf/data/repository/srdc_ora7445_collection_Mon_Mar_11_10_14_47_PDT_2024_node_local
/u01/app/grid21/oracle.ahf/data/repository/srdc_ora7445_collection_Mon_Mar_11_10_14_47_PDT_2024_node_local/mymachine1.tfa_srdc_ora7445_Mon_Mar_11_10_14_46_PDT_2024.zip

 

Once it’s finished AHF will package everything for you'in a zip file.

 

Now we can move on to step number two. Use the My Oracle Support ORA-07445 troubleshooting tool to find recommendations.

 

2. Use ORA-07445 Troubleshooting Tool to find recommendations

Log into My Oracle Support and search for ORA-07445, or alternatively go to http://bit.ly/ORA-07445 to access it directly.

When you get to the troubleshooting tool click the Next button at the top right

ORA-07445 MOS Troubleshooting Tool Step 1

Select the first radio button to choose to upload a TFA package. (TFA is one of the components of AHF)

 

Then click the “Choose file” button, select the zip from the failing node that AHF captured for you in step 1.

Then press the Upload button.

ORA-07445 MOS Troubleshooting Tool Step 2

 

Once this is uploaded click the Next button at the top right again.

ORA-07445 MOS Troubleshooting Tool Step 3

 

The troubleshooting tool will then analyze the contents of the diagnostic collection and compare the log entries against it’s list of known problems and recommend a solution.

ORA-07445 MOS Troubleshooting Tool Step 4

If you go through the MOS troubleshooting tool and can’t find a solution, or you just need some more help, then Oracle Support is just a click away.

 

3. Log a new SR using the diagnostic collection

Press the Create SR button at the bottom.

ORA-07445 Create SR Step 1

You’ll then be prompted to clarify your:

  • Product
  • Product Version
  • Support Identifier
  • Operating System
  • SR severity

Then press the Create SR button.

And you’ll get a new SR number.

ORA-07445 Create SR Step 2

 

That’s it!

The AHF diagnostic collection you uploaded originally will be attached to your SR and Oracle Support will take over.

 

Get started now

To get started today download Oracle Autonomous Health Framework.

Gareth Chapman

Senior Principal Program Manager

Gareth is Senior Principal Program Manager for DevOps within Oracle Autonomous Health Framework.


Previous Post

Simplify SSH key management, enhance manageability and improve operational security with Oracle Key Vault 21.8

Peter Wahl | 3 min read

Next Post


Maximize database performance with Oracle Exadata and Oracle Linux

Gursewak Sokhi | 8 min read