alert log is not updating..

[prasadvd]

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

[ckwan]

Perform SHOW PARAMETER background_dump_dest
Check whether the destination directory is correct.

[prasadvd]

I have checked it already,the directory is correct. Any more ?

[ales]

Check free space, rights ...

[marist89]

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.

[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.

[adewri]

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.

[prasadvd]

Taken log switches. But it not recorded. Database is running nicely.
What is the problem ?

[launchpad]

Make sure you are checking correct alert log file.

[Chintz]

Check the maxsize set for the alert log. At times if it has reached the maxsize it stops writing to the alert log.

-Chintz