Analyze ALRT.LOG
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Analyze ALRT.LOG

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    Analyze ALRT.LOG

    Check ALRT.LOG

    some contents looks like:
    Errors in file: XXX\ora00293.trc
    Errors in file: XXX\ora00123.trc
    Errors in file: XXX\ora00302.trc
    Errors in file: XXX\ora00077.trc
    Errors in file: XXX\prodLGWR.trc

    ORA-01110: Data file 6:XXXX
    ORA-01114: IO Error writing block to file 6 (block #1)
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() Failure, unable to write to file
    O/S-Error: (OS 5) Access is denied

    Errors in file: XXX\ora00275.trc


    I knew the media error occuried that time , And already recovered manually , from those message , Can we get a conclusion what's the cause of this error ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Only thing you can tell from the message is
    Oracle was unable to write to that file due to OS error.

    It can be OS that locked the file, It can be "permissions" for the file, It can be hardware that caused problem.

    Sanjay

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    What are you running?

    I've seen this type of error on a Solaris box running Oracle 9.x and Using the Itelligent agent. The dbsnmp process has a memory leak on SOLARIS boes only which gobbles Swap space until it consumes it all... then the server grinds to a halt.

    If you are on Solaris, do a top and see how much RES memeory the process is using. It it's using copious amounts, Kill this process to an see if it makes a difference. The process will automatically start after it's killed.
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    WinNT + Oracle8.0.x
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Oh.. well... I think that shelves the Solaris issue then.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

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