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 .
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.