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@musiciansf        To:     Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>     
                    riend.com>               cc:                                       
                              
                    Sent by:                 Subject:     Re: Centralized Alert Log 
Monitoring                       
                    [EMAIL PROTECTED]                                                   
                              
                                                                                       
                              
                                                                                       
                              
                    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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to