Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Events that are automatically recorded when a problem occurs on the Exadata cell node must be cleared when the problem is corrected. The cleaning process can be done automatically and sometimes it is not cleaned automatically. In this case, if you want to send a weekly or daily report, you will be constantly informed about the problem.
You can access detailed information about an event on the cell node via cellcli with the following command:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | CellCLI> list alerthistory 45_2 detail name: 45_2 alertDescription: "A generic component suspected of causing a fault" alertMessage: "A generic component is suspected of causing a fault. Component Name : /SYS/MB/RISER1/PCIE4/F20CARD Fault class : fault.chassis.device.esm.eol.exceeded Fault message : http://www.sun.com/msg/SPX86-8002-S3" alertSequenceID: 45 alertShortName: Hardware alertType: Stateful beginTime: 2015-02-16T13:11:55+02:00 examinedBy: failedMail: oracle.exadata@interiva.com metricObjectName: /SYS/MB/RISER1/PCIE4/F20CARD_FAULT notificationState: 3 sequenceBeginTime: 2015-01-30T07:12:25+02:00 severity: critical alertAction: "For additional information, please refer to http://www.sun.com/msg/SPX86-8002-S3" |
Use the following command to check if there are any errors on the cellnode:
1 2 | CellCLI> alter cell validate configuration Cell orclceladm01 successfully altered |
If no errors are returned, all problems are resolved. In this case, you can clear all relevant event logs. You can use the following command to clean.
Delete Exadata cell node alert history:
1 2 3 | CellCLI> drop alerthistory 45_1,45_2 Alert 45_1 successfully dropped Alert 45_2 successfully dropped |
If you perform the drop for a single event and if there are other events that are linked to this event, it will fail as follows. Therefore, you have to drop all the events related to the problem at once.
1 2 3 | CellCLI> drop alerthistory 45_2 CELL-02643: DROP ALERTHISTORY command did not include all members of the alert sequence for 45_2. All members of the sequence must be dropped together. |
Use the following command to delete all event records:
1 2 3 | CellCLI> drop alerthistory all Alert 57_1 successfully dropped Alert 57_2 successfully dropped |
After deleting all records, no results will be returned in alerthistory.
1 | CellCLI> list alerthistory |
