Tuesday, October 22, 2013

One or more storage server has test stateless alerts with null "examinedby" fields

This error gets reported in exacheck for exadata storage nodes regularly.
Most of the error is just a test trap. We have to update the "examined by " to clean it.

Its Very simple !

Just login to exadata storage node as root or cell admin

Just use the command "alter alerthistory 64 examinedby="sameer";"
where 64 - is the alert number reported in exacheck
Sameer - is the name of the DBA addressing it

[root@storage01 ~]# cellcli
CellCLI: Release 11.2.3.2.1 - Production on Tue Oct 22 21:06:43 GMT+05:30 2013

Copyright (c) 2007, 2012, Oracle.  All rights reserved.
Cell Efficiency Ratio: 5,443

CellCLI> list alerthistory
         53_1    2013-07-17T02:01:37+05:30       info    "The disk controller battery is executing a learn cycle and may temporarily enter WriteThrough Caching mode as part of the learn cycle. Disk write throughput might be temporarily lower during this time. The flash drives are not affected. The battery learn cycle is a normal maintenance activity that occurs quarterly and runs for approximately 1 to 12 hours.  Note that many learn cycles do not require entering WriteThrough caching mode.  When the disk controller cache returns to the normal WriteBack caching mode, an additional informational alert will be sent.  Battery Serial Number : 1528  Battery Type          : iBBU08  Battery Temperature   : 45 C  Full Charge Capacity  : 1384 mAh  Relative Charge       : 96 %  Ambient Temperature   : 26 C"
         53_2    2013-07-17T08:04:57+05:30       clear   "All disk drives are in WriteBack caching mode.  Battery Serial Number : 1528  Battery Type          : iBBU08  Battery Temperature   : 49 C  Full Charge Capacity  : 1379 mAh  Relative Charge       : 50 %  Ambient Temperature   : 25 C"
         54      2013-07-29T15:52:26+05:30       info    "This is a test trap"
         55      2013-08-06T11:33:16+05:30       info    "This is a test trap"
         56      2013-08-06T12:52:30+05:30       info    "This is a test trap"
         57      2013-08-06T18:22:19+05:30       info    "This is a test trap"
         58      2013-08-22T18:41:53+05:30       info    "This is a test trap"
         59      2013-08-23T17:00:43+05:30       info    "This is a test trap"
         60      2013-08-27T15:11:24+05:30       info    "This is a test trap"
         61      2013-09-13T17:39:32+05:30       info    "This is a test trap"
         62      2013-09-17T23:50:01+05:30       info    "This is a test trap"
         63_1    2013-10-17T02:00:32+05:30       info    "The disk controller battery is executing a learn cycle and may temporarily enter WriteThrough Caching mode as part of the learn cycle. Disk write throughput might be temporarily lower during this time. The flash drives are not affected. The battery learn cycle is a normal maintenance activity that occurs quarterly and runs for approximately 1 to 12 hours.  Note that many learn cycles do not require entering WriteThrough caching mode.  When the disk controller cache returns to the normal WriteBack caching mode, an additional informational alert will be sent.  Battery Serial Number : 1528  Battery Type          : iBBU08  Battery Temperature   : 44 C  Full Charge Capacity  : 1376 mAh  Relative Charge       : 97 %  Ambient Temperature   : 29 C"
         63_2    2013-10-17T07:49:29+05:30       clear   "All disk drives are in WriteBack caching mode.  Battery Serial Number : 1528  Battery Type          : iBBU08  Battery Temperature   : 49 C  Full Charge Capacity  : 1367 mAh  Relative Charge       : 50 %  Ambient Temperature   : 28 C"
         64      2013-10-22T20:39:06+05:30       info    "This is a test trap"

CellCLI>; alter alerthistory 64 examinedby="sameer";
Alert 64 successfully altered



No comments:

Post a Comment