alert log is not updating..
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: alert log is not updating..

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    alert log is not updating..

    Hi

    We have 9i db on win2k3. Since last two days our alert log file
    is not showing anything . But database is running smoothly without
    having any problem. Why alter log file is not updating ? Is there
    any problem ? If So, what is it ?


    Thanks in adv
    Prasad

  2. #2
    Join Date
    Oct 2000
    Posts
    250
    Perform SHOW PARAMETER background_dump_dest
    Check whether the destination directory is correct.

  3. #3
    Join Date
    Nov 2002
    Posts
    115
    I have checked it already,the directory is correct. Any more ?
    Prasad

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Check free space, rights ...
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    does it have any reason to update the alert.log? Perform a log switch (if you're logging log switches) and see if that is recorded.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    if you cannot update the alert log you are fubared. If oracle cannot wrie to the alert log it will terminate itself when it tries to do so

    try a log switch as suggested.
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by stmontgo
    if you cannot update the alert log you are fubared. If oracle cannot wrie to the alert log it will terminate itself when it tries to do so

    try a log switch as suggested.
    No thats not true at all..... Oracle can run even if it cannot write to alert.log file. However, if Windows permissions are not set correctly (or have recently been incorrectly changed) the database can potentially suffer serious problems such as errors writing to files and/or crashing.

    Check if SYSTEM has necessary permissions to write to alertlog file. If SYSTEM does not have full permissions to where the alert log resides, there will be no writes made to the alert log file.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Nov 2002
    Posts
    115
    Taken log switches. But it not recorded. Database is running nicely.
    What is the problem ?
    Prasad

  9. #9
    Join Date
    Jul 2000
    Posts
    119
    Make sure you are checking correct alert log file.
    OCP 8.0, 8i, 9i

  10. #10
    Join Date
    Dec 1999
    Posts
    217
    Check the maxsize set for the alert log. At times if it has reached the maxsize it stops writing to the alert log.

    -Chintz

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