-
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
-
Perform SHOW PARAMETER background_dump_dest
Check whether the destination directory is correct.
-
I have checked it already,the directory is correct. Any more ?
Prasad
-
Check free space, rights ...
Ales The whole difference between a little boy and an adult man is the price of toys
-
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
-
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
-
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."
-
Taken log switches. But it not recorded. Database is running nicely.
What is the problem ?
Prasad
-
Make sure you are checking correct alert log file.
OCP 8.0, 8i, 9i
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|