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”

2.) Execute “show tracefiles”.

      Here we have to use LAST_INCIDENT as a filter.

    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.

Regards,

János