View Single Post

   
  #2 (permalink)  
Old 02-22-2008, 05:09 PM
Peter van Rijn
 
Posts: n/a
Default Re: rotating listener.log

> >
> >it's very strange because alert<SID>.log is filled ok when recreated.

>
> listener.log has nothing to do with alert.log. So you won't


That's not what he says. He is making a comparison between the listener.log,
which is not recreated when deleted, and the alert.log, which is.

The explanation is quite easy. As I said before, the listener.log is not
recreated, because the file is not being closed. The program tnslsnr keeps a
file descriptor open to the inode that represents the file.
The alert.log is NOT being kept open. For every singles write to the file it
is opened before, and closed afterwards. If oracle doesn't find the
alert.log when trying to open it, it is created instead.

regards,
Peter


Reply With Quote