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 support.oracle.com, the nice and quick way to start troubleshooting is to type “600.1” on the search box

post001_img01

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.

post001_img02

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

post001_img03

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)

post001_img04

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)

post001_img05

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

post001_img06

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

post001_img07

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:

post001_img08

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

post001_img09

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:

WordPress.com Logo

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

Google photo

You are commenting using your Google 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