Alert Log files

[kkpareek]

Hi,

At this location, I am finding an alert_sid.log file which is not written for days. What could be the reason? How to enable the writting in this alert.log file? I never faced such thing in other locations.

K K pareek

[svk]

check the BACKGROUND_DUMP_DEST variable in init.
Is it pointing to same directory ?

[thanigai]

First try to check whether that is the correct file or not.
To check that give some command at sql promt..
SQL>alter database backup controlfile to trace...
database altered
or shutdown and startup database
Now check in the alert_sid_file whether this command is
recorded....If so it is okay....Otherwise check the dumpdest in database level.....
By querying..
SQL>select name from v$parameter where name like 'DUMP_DEST';
You will get the path....check with your alert_sid_log path..if it maches okay...
Some times if there is no load it may not write for days too....

Note:If the dump_dest is not correct.....database will not open.....You will get error saying
logfile could not open.....??????????????????.Sr Experts can throw some
points on this.

Thanks.
Thanigaivasan