RE: Alert log and trace file monitor for Winders?

Have you tried looking at swatch, or adapting my Perl program from the (Gawd!) late 90's to use wsh? You could also remove the DBD::Oracle piece of the code (AFAICR, I only used that to find the location of the alert log). Or, use OEM Grid Control.

--

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich Sent: Tuesday, January 24, 2006 12:34 PM To: ORACLE-L
Subject: Alert log and trace file monitor for Winders?

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_at_quadtechworld.com      QuadTech, Sussex, WI USA

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 24 2006 - 14:54:14 CST