Re: Alert Log file.

On Wed, 12 Jan 2005 16:52:30 +0300, Vinod Gopinath BMMI IS <vinodg_at_bmmi.com.bh> wrote:
> Oracle 8.2 on Win2K
> There is no entry happening on alert log file for past 2 days. This is
> an retial system, so lot of transaction happenes daily. There is enough
> space in the disk.
> My worry is that all of a sudden the system shouldn't stop and throw
> some vague error.
> Can some one help me on as to why there is no entry is alert log file. I
> even bounced the db once still no luck.

First thing that come to mind is do:

select name, value
from v$parameter
where name like '%background_dump%';

and check that the alert log is where you expect it to be. It wouldn't be the first time that I've known a system where someone has changed the location for the alert log and not bothered to tell anyone.

Once you've checked where it is, and assuming that it's where you think it is, check if there's free disk space and that Oracle can write to that location. Sometimes sysadmins get a bit sloppy with changing permissions

Stephen

-- 
It's better to ask a silly question than to make a silly assumption.
--
http://www.freelists.org/webpage/oracle-l