Alert log doesn't have timestamp
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Alert log doesn't have timestamp

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Alert log doesn't have timestamp

    Hello all..

    ORacle 9.2/sun 5.8

    I was looking into alertlog and i see some errors, but it doesn't say at what time those errors occured or on which date they happened ?...

    how do we find that out ?...


    any help is appreciated.

    Thanks
    Ron

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    What where the errors? Did they generate trace files? If so you will be able to establish the time and date from the trace output.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    thanks jovery...

    this is what i see on my alert log.
    *******************************************************************
    ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
    ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
    ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
    ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
    ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
    ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
    ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
    ****************************************************************


    now how do i see if it generated the trace file ?...and where can i find that trace file ?

    Thanks
    Ron

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Do you have a process which is trying to take an online backup of the temp tablespace or is trying to alter the storage parameters both or which are not possible/required with a locally managed temp tablespace?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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