Re: Alert Log file.

  • From: stephen booth <stephenbooth.uk@xxxxxxxxx>
  • To: vinodg@xxxxxxxxxxx
  • Date: Wed, 12 Jan 2005 14:24:32 +0000

On Wed, 12 Jan 2005 16:52:30 +0300, Vinod Gopinath          BMMI IS
<vinodg@xxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l

Other related posts: