Re: Alert log and trace file monitor for Winders?

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Rich.Jesse@xxxxxxxxxxxxxxxxx
  • Date: Tue, 24 Jan 2006 19:56:39 +0000

you could always do the alert.log from pl/sql itself in 9.2
<http://www.niall.litchfield.dial.pipex.com/scripts/admin/read_alertlog.sql>

Niall

On 1/24/06, Jesse, Rich <Rich.Jesse@xxxxxxxxxxxxxxxxx> wrote:
>
> Hey all,
>
> I'm upgrading some Oracle DBs from 8i to 9iR2 and as luck would have it,
> they're on (or will be) on Winders Server 2K3.  So my custom POSIX
> script for monitoring the alert log and trace files won't work.  :(
>
> There's CygWin, but as I have zero control over this server (and don't
> want any), I'm hesitant to attempt it.  I've installed CygWin dozens of
> times on desktops, but I really don't want to try and tackle a
> full-blown WinServer in a Corporate lockdown environment, either
> politically or technically.
>
> I've been scouring the Freelist archives as well as orafaq (and Google),
> and the only thing I can find that comes close is Ron Reidy's Perl
> script.  Unfortunately, the almost-a-Perl that comes installed with
> Oracle-Apache doesn't have DBI/DBD-Oracle, so that option's out for the
> same reason as CygWin.
>
> So, is there by chance a non-DBI log monitor program already written
> that will work with Oracle's installed Perl?  I could hack one up in a
> day or two, but just didn't want to reinvent the square wheel if I
> didn't have to.  There's was none to be found even on jaredstill.com,
> either (which is COMPLETELY different from jstill.com).  ;)
>
> Anyone?
>
> TIA,
> Rich
>
> Rich Jesse                        System/Database Administrator
> rich.jesse@xxxxxxxxxxxxxxxxx      QuadTech, Sussex, WI USA
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Other related posts: