Re: Shell Script to Supress OEM alerts during shutdown immediate

1. have procedures and script(s) for shutting down databases that everyone follows
2. include the necessary emcli commands in the scripts

If someone doesn't follow procedure then I'd say that an alert and an on-call page is exactly what you want to happen.

On Sat, Mar 26, 2016 at 10:54 AM, Arun Chugh <arun.chugh1610_at_gmail.com> wrote:

> Hi,
>
> Thanks for the response.
>
> Yes, this could be one of the solution but what happens, we forget to put
> the blackout in OEM and start getting the alerts for the same, so we want
> the automatic solution of it, if any DBA put down the DB with "shutdown
> immediate" we should not receive any alerts.
>
> Regards,
> Arun Chugh
>
> Sent from my iPhone
>
> On 26-Mar-2016, at 4:05 PM, Ls Cheng <exriscer_at_gmail.com> wrote:
>
> Hi
>
> You mean Blackout? You can run emcli, this is an example
>
> emcli create_blackout \
> -name="MAINTENANCE" \
> -add_targets="XXXX:oracle_database;ZZZZ:oracle_listener" \
> -reason="MAINTENANCE WINDOW" \
> -schedule="frequency:once;duration:0:30"
>
> It blackouts 2 targets, one database and one listener for 30 minutes
>
> Regards
>
>
>
>
> On Sat, Mar 26, 2016 at 11:25 AM, Arun Chugh <arun.chugh1610_at_gmail.com>
> wrote:
>
>> Hello Team,
>>
>> Our requirement is to automatically supress the OEM alerts whenever the
>> database undergoes "shutdown immediate" during the refresh or maintenance
>> windows.
>>
>> If someone have any script, please share. Thanks !!!
>>
>> Regards,
>> Arun Chugh
>>
>> Sent from my iPhone--
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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