TRACE FILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: TRACE FILE

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Hi all

    I just checked my alert log and it stated the following
    Thu May 23 14:48:10 2002
    Errors in file E:\oracle\admin\db_name\udump\ORA00172.TRC.

    so I went to udump to check upon the aboved mentioned trace
    file.
    When I opened it the dump file generated is dated Thu Apr 18
    08:06:40 2002.
    with FATAL ERROR IN TWO-TASK SERVER: error 12571
    ***2002-04-18 08:06:40.349
    ksedmp: internal or fatal error
    Current SQL statement for this session
    BEGIN " RECORDS3"."DROP_ALL_TEMP_TABLES" ; END;

    QUESTION:
    I thought that the trace file generated by the alert log file time will correspond or match the one in the udump.

    Why will a trace file generated today for something that happened a month ago?

    Also we have detected ORA-00600 INTERNAL ERRORS.
    Can you please advise?
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You only checked the beginning of that trace file. It means that the first error recorded in that trace file happened on Thu Apr 18. But that doesn't mean that this is the only event recorded in that trace file. Use search utility of your text editor and you'll find that there is at least one more error recorded in that trace file - the one that happened at Thu May 23.

    Trace files are named based on the process_id of the process that encounters the error. If the file with that name does not yet exist Oracle creates one. But if the file with that name allready exists Oracle simply append the trace of the error at the end of the existing file.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width