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.

Regards,

János

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply