Nagios Support Forum

Is there any work around to rectify this.

Since this is expected behavior for both the plugin and acknowledgements, no. However a few posts back I mentioned another plugin that will let you monitor individual tables and you can acknowledge them separately.

We used plugin suggested by you. If we do not use the '-d' option it will check all table spaces on that database. Below are the example.

CHECKS PARTICULAR TSPACE
bash-3.2$ ./check_oracle_tablespace.sh -s 'ISRVE' -d 'HC_DATA1' -w 85 -c 90
TABLESPACE WARNING: HC_DATA1 89%

CHECKS ALL TSPACES (no ‘-d’ option)
bash-3.2$ ./check_oracle_tablespace.sh -s 'ISRVE' -w 85 -c 90
TABLESPACE CRITICAL: DAILY_ACT_C 90%; GRSDW_DATA 91%; RES_ANAL_NEW 91%; SYSAUX 90%; XSAT_DATA 90% WARNING: DATA3 85%; HC_DATA1 89%; ISRVETOOLS 87%; MSS_DATA 89%; OUT_CSE_MIR_DATA 87%; OWBSYS 86%; PARTITION_TS_Q1 85%; PARTITION_TS_Q2 89%; PARTITION_TS_Q3 88%; PARTITION_TS_Q4 86%; PARTLIFE_STG 85%; RE_ORG 85%; RTF_HIST_SUM 85%; SNMDM_DATA 85%; SNMDW_DATA 85%; SVC_VAR_F_IDX_TBLS 89%; TOOLS 89%; UNDOTBS2 85%; XIM_MIR_DATA 85%; XSATDM_DATA 87%; XSATDM_IDX 86%; XSATDW_DATA 89%

The problem with individual table space monitoring is we have many databases on the server and each database has more than 30 table space.
I am trying different options. I know that setting notification interval to 0, will send only single alert. Is there any option to stop alerts after few notifications, say after 10 critical alerts (without acknowledging).

You could always set up an escalation chain that handles the emails properly until the tenth one and sends the rest to a dummy email account.

We have never dealt with notification escalations. I will check the details about it and get back to you.

As per my understanding, notifications 1 and 2 are for the default contact groups. Though it is not logical, would it work if we keep the same contact groups for escalation 3 to 10 as well. After 10th notification we will use dummy contacts.

Suppose we set last notification to 0 in escalation, after 10th notification, will notifications be sent out to default contact groups in service definition or to contact groups in last escalation.

Notification escalations can work on any notification, not just 3 onward. You can set first_notification to 1 if you'd like.

http://nagios.sourceforge.net/docs/3_0/escalations.html
http://nagios.sourceforge.net/docs/3_0/ ... escalation

Did you read over the escalation help and definition pages I linked? They should explain everything.

As per the second link:

last_notification: This directive is a number that identifies the last notification for which this escalation is effective. For instance, if you set this value to 5, this escalation will not be used if more than five notifications are sent out for the service. Setting this value to 0 means to keep using this escalation entry forever (no matter how many notifications go out).

Thank you. Those were the links I was going through. I understand how host and service escalations works now.

I will give it a try and let you know.