Re: Centralized Alert Log Monitoring

You can user AlertView on both. It's really a good product and well worth the price...;-) Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, January 07, 2002 2:50 PM

>
> Thanks all for the reply.
> To make the problem more challenging, I would like to add that ( sorry for
> not mentioning about this in my original E-mail ) our shop has both NT and
> Unix.
> Any ideas?
>
> Dennis Meng
> Database Administrator
> Focal Communications
> 847-954-8328
>
>
>
> "Brian Haas"
> <bhaas_at_musiciansf To: Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
> riend.com> cc:
> Sent by: Subject: Re: Centralized
Alert Log Monitoring
> root_at_fatcity.com
>
>
> 01/07/02 01:27 PM
> Please respond to
> ORACLE-L
>

>
>
>
>
>
> Dennis,
>
> I'm not sure if you have any NT boxes or not, but for the unix side have
> you considered setting up an NFS share? You could store one copy of the
> script there and mount that share on the db servers. Then just schedule it
> like you normally would (cron,at). Depending how your script works, you
> may need to abstract out hard coded values, and pass them as command line
> parameters for file locations, sid, etc. We do this for our web site code
> and all of our utility scripts. It makes maintenence much easier.
>
>
> HTH,
>
> -Brian
>
>
>
>
> On Mon, 7 Jan 2002 dmeng_at_focal.com wrote:
> >Hi All,
> >Currently I am the only DBA for the 15 productin databases in our
company.
> >I have written shell scripts on all database servers to parse the
> alert.log
> >file and look for Oracle errors and send page/E-mail if problems are
> found.
> >While this works it is sometimes painful to maintain - if I want to
change
> >something I have to go to different servers to change the scripts one by
> >one. I figure it would be nice if we can have a centralized solution
where
> >I can monitor alert logs remotely and don't have to hop from server to
> >server. Are there any tools/scripts that enable DBAs to do this? I know
> >OEM can do that with the Advanced Events but now you have to buy the
> >Diagnostics pack for that.
> >TIA
> >Dennis Meng
> >Database Administrator
> >Focal Communications
> >847-954-8328
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Brian Haas
> INET: bhaas_at_musiciansfriend.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dmeng_at_focal.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).