Skip to Content
Author's profile photo Janos Mucsi-Besze

How to locate an incident trace within ADRCI

This one is very useful while collecting and sending data either to Oracle or SAP.

As in my example, I had a problem with ORA-600 [16500].

1.) Execute “show problem”

show problem.png

2.) Execute “show tracefiles”.

      Here we have to use LAST_INCIDENT as a filter.

show tracefiles.png

    The path here does not include $ORACLE_BASE. Please consider this while searching for the file in OS level.

3.) You can either attach only the corresponding tracefile for further analyze or you can use “IPS CREATE PACKAGE” + “IPS GENERATE PACKAGE” to create an archive with all relevant information.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Fatih YUKSEL
      Fatih YUKSEL

      Thank you so much.

      Author's profile photo Janos Mucsi-Besze
      Janos Mucsi-Besze
      Blog Post Author