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 ?
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."