MyOracleSupport – ORA-600 / ORA-7445 analysis tools

MyOracleSupport – ORA-600 / ORA-7445 analysis tools

It used to be a panic-mode -alert when one would get an ORA-600 / ORA-7445 error. This has slowly transitioned to a rather manageable non-panicking level (even ignorable).

As usual, these kinds of errors point us to MyOracleSupport (MOS), so once we land on, the nice and quick way to start troubleshooting is to type “600.1” on the search box


This will take us to the well know ORA-600/ORA-7445/ORA-700 Error Look-up Tool.

That would be our first stop to try and troubleshoot the error.


I’m not going to spend time on this as the tool has been around for a good while and most DBAs are quite used to this tool to do a first screening of the error and even do a first MOS search.

The purpose of this post is the specific ORA-7445 / ORA-600 troubleshooting tools


The mechanicals are pretty much the same for either error, so for the sake of this post we’ll use the new ORA-7445 link, so go ahead and click on the link to land on the tool’s main page.

You are presented with two options, to troubleshoot a new issue or to review a troubleshoot (saved) report from a previous session (clicking on the help “?” icon will give you an explanation on the options)


Let’s pick the first option, to troubleshoot a new issue and click next (on the top-right of the page)

Now we’re on the file upload step – depending on your choice of files to upload you have three choices: TFA packages, IPS packages or a trace file + alertlog (optional)


More in depth details on trace file collection are explained on Doc. 2165632.1

A TFA package is the recommended approach – to generate the .zip package you run:

$TFA_HOME/bin/tfactl diagcollect -srdc ora7445

An IPS package works nicely too – to generate the .zip package you run

Connect to “adrci” tool, set the proper home and generate the package:

adrci> set homepath diag/rdbms/mydb/MYDB1
adrci> show incident
INCIDENT_ID          PROBLEM_KEY                   CREATE_TIME
-------------------- ----------------------------- ---------------------------------
12345                ORA 7445 [kfkNotify()+25]     2017-03-05 21:00:21.444000 +00:00
adrci> ips pack incident 12345 in /tmp

Alternatively, if there are several similar incidents, you can generate the package for a problem instead

adrci> ips pack problem 12 in /tmp

Upload the generated file by clicking on “Choose File” and then click on the “Upload” button.

In this example we are using an IPS package


Once uploaded click next and let the tool do the analyzing – wait for it to end and you’ll land on the “Review Recommendations” step.

Below an example of the expected output


You may get a good lead or even an acceptable solution to your problem there, however, if the analysis returns no acceptable feedback (or nothing is found) there’s a second section that is quite interesting and helpful – have a look at the “Your Feedback” section, more precisely the “Create SR” button:


This is particularly useful for a quick SR creation, as most of the options will be filled out for you – all you need to reconfirm is the product version, the desired support ID to use and the OS version (and of course the severity of the SR)

You might also want to give it a more meaningful title as the one offered could be too generic.

Note there’s also an option to save the troubleshooting session if you ever need to go back to validate it.

This is what the “Create SR” popup looks like


When I had to use this approach, I found that a sev. 2 was promptly attended to and got very good analysts to help.

Thanks for taking the time to read this – hopefully you’ve found it helpful

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s