Re: how to alert if EM DB is down

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 16 Jul 2013 11:48:56 -0500
Message-ID: <CAP79kiT_9DxiS_gVDKAV5kYBX=tkW77rCBd7mC9fG9o-7m3hiQ_at_mail.gmail.com>

Cronjob if on Unix/Linux, Task Scheduler job if on Windows.

Contents of job should login and check status of database, trap any error and mail/page the DBAs to alert them.

From Windows setting up a mail batch job is more difficult than in Linux/Unix.

Alternatively create a database job in another database with a database link to your EM db and have it run a job to check the status of the database across the database link and alert when exception encountered, again sending an email.

Chris

On Tue, Jul 16, 2013 at 11:43 AM, Prabhu Krishnaswamy < prabhu_adam_at_hotmail.com> wrote:

> Hi Lists,
>
>
> We have an incident occured in our shop wherein our production EM database
> was crashed due to file system issue. We never received any alert as our em
> is down. How to setup an alert if EM DB gone south. Please suggest.
>
>
>
> Thank you
>
> Prabhu
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 16 2013 - 18:48:56 CEST