Monitoring Exadata Storage Cells - Oracle Exadata Recipes: A Problem-Solution Approach - page 367

cm01cel02: 2_2
cm01cel03: 2_2
[oracle@cm01dbm01 ~]$
[oracle@cm01dbm01 ~]$ dcli -c cm01cel01 cellcli -e drop alerthistory 2_1, 2_2
cm01cel01: Alert 2_1 successfully dropped
cm01cel01: Alert 2_2 successfully dropped
[oracle@cm01dbm01 ~]$

In this output, we've specified two comma-separated alerts in our drop alerthistory command. This is
required because the alerts are related as part of an alert sequence. If you attempt to drop a single alert that is part of a
sequence, an error message will be raised:

[oracle@cm01dbm01 ~]$ dcli -c cm01cel02 cellcli -e drop alerthistory 2_1
cm01cel02:
cm01cel02: CELL-02643: DROP ALERTHISTORY command did not include all members of the alert sequence
for 2_1. All members of the sequence must be dropped together.
[oracle@cm01dbm01 ~]$

To drop all of your alerts, use the drop alerthistory all command:

[oracle@cm01dbm01 ~]$ dcli -g ./cell_group cellcli -e drop alerthistory all
cm01cel01: No alerts qualified for this drop operation
cm01cel02: Alert 2_1 successfully dropped
cm01cel02: Alert 2_2 successfully dropped
cm01cel03: Alert 2_1 successfully dropped
cm01cel03: Alert 2_2 successfully dropped
[oracle@cm01dbm01 ~]$

■ With the drop alerthistory CellCli command, you cannot use a where condition; alerts need to either be
dropped by their specific name, a comma-separated list of alerts names, or with the all clause.

Note

How It Works
Similar to how Exadata Storage Servers capture metrics as discussed in Recipe 13-3, Exadata triggers alerts on
the storage servers when events occur that compromise the function of the storage cell. Exadata's MS process is
responsible for capturing alert conditions when it discovers a cell hardware issue, software or configuration issues,
a CELLSRV internal error, or when a metric has exceeded an alert threshold. Exadata DMAs can view these triggered
alerts using the CellCLI list alerthistory command, via Oracle Enterprise Manager, and/or optionally configure
the cell to automatically send e-mail and/or SNMP messages when an alert is raised.
Exadata Storage Servers come with a number of predefined alerts. You can use the list alertdefinition
detail command from CellCLI to display information about each alert, as displayed in the following code:

CellCLI> list alertdefinition detail
name: ADRAlert
alertShortName: ADR
alertSource: "Automatic Diagnostic Repository"
alertType: Stateless
description: "Incident Alert"
metricName: