Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!atl-c02.usenetserver.com!news.usenetserver.com!feed2.newsreader.com!newsreader.com!newshosting.com!nx02.iad01.newshosting.com!newsfeed.bahnhof.se!feeder1.news.jippii.net!nntp.inet.fi!inet.fi!ndtc4500!ash.uu.net!an02.austin.ibm.com!ausnews.austin.ibm.com!not-for-mail From: Ed Stevens Newsgroups: comp.databases.oracle.server Subject: Re: oracle scan log script Date: Wed, 05 May 2004 07:18:31 -0500 Organization: IGS Internet News Server (AUSTIN) Lines: 49 Message-ID: References: <6dabc692.0404301850.14046823@posting.google.com> <6dabc692.0405041640.4b578285@posting.google.com> NNTP-Posting-Host: gsine10.us.sine.ibm.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: ausnews.austin.ibm.com 1083759238 17002 9.14.6.40 (5 May 2004 12:13:58 GMT) X-Complaints-To: abuse@ausnews.austin.ibm.com NNTP-Posting-Date: Wed, 5 May 2004 12:13:58 +0000 (UTC) X-Newsreader: Forte Free Agent 1.92/32.572 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260836 Ahh, now we're getting somewhere. Your problem isn't "how to write a script to scan the alert log." It is "how to get notified (in something resembling a timely manner when something goes wrong." To write the script you'd need to be able to define "something 'odd'" and identify the character string that would identify "something 'odd'". And you'd want to be able to deal with avoiding reporting the same oddity occurance every time you ran the script. Have you looked into OEM? It has a very good reporting capability for all sorts of things -- some of which show up in the alert log and some of which don't. That quite nicely addresses your real problem. It can e-mail and/or page (or send email to an address which is really a text pager). I started down the same road you are looking at, but abandond that in favor of OEM reporting and have been using that for some time now. Due to localized reasons, I'm not able to use the paging, but do receive e-mails when 'something odd' happens in my databases. On 4 May 2004 17:40:46 -0700, tpreto7@sapo.pt (Teresa) wrote: >Hello and Thank you > >I'm only looking for a general unix script that can scan the oracle >alert.log file for any kind of oracle error's. For the output it >would be an email whenever there is something 'odd' writte to the log. > > >Ed Stevens wrote in message news:... >> On 30 Apr 2004 19:50:13 -0700, tpreto7@sapo.pt (Teresa) wrote: >> >> >Hello >> > >> >Does any one have a general script that scans the oracle logs? I'm >> >looking for a script that can scan the alert.log etc >> >Thanks! >> >Teresa >> >> While my first reply does give you a one-line script that scans the >> alert log, I should have asked for more info . . >> >> First off ... what operating system? >> >> Second, what is it you're scanning for? How do you anticipate using >> this script? How do you plan on using the output? >> >> Most important -- what is the real problem you're trying to solve?