Thanks for the suggestion.
It would be great if anyone of you is having the procedure handy for this task.
But one thing I want to mentioned here is that the database is running thru
oracle user and emagent is running thru grid user, so we need to setup
passwordless connection(ssh) for every server in order to run emcli command via
procedure and it would be very tedious task for entire setup or correct me if I
am wrong.
Regards,
Arun Chugh
Regards,
Arun Chugh
Sent from my iPhone
On 26-Mar-2016, at 5:59 PM, Niall Litchfield <niall.litchfield@xxxxxxxxx>
wrote:
You should
a) have procedures and script(s) for shutting down databases that everyone
follows
b) 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@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx>
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--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info