On a weekly basis, I was getting emails (after patching to release 18) that Diagnostic Package.
I then checked with Oracle about this and found out this is a new feature (12 release) and it is okay to ignore. But I was really bugged by the nuisance emails. So I thought of clearing it.
But I have more than 5 Exadatas which are full racks and I do not want to clear all alerts but these itself (for Diagnostic Package)
So, I came up with a small automation which will generate the right commands for me.
Here is what I did
For Cell Servers
# dcli -l root -g cell_group 'cellcli -e list alerthistory' | grep 'Diagnostic packages' | awk '{print "dcli -l root -c " $1 " \x27" "cellcli -e drop alerthistory " $2 "\x27" " ### " $3}' | sed 's/://'
dcli -l root -c myexacel01 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:16:52-04:00
dcli -l root -c myexacel02 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:19:15-04:00
dcli -l root -c myexacel03 'cellcli -e drop alerthistory 5_1' ### 2018-10-06T19:18:51-04:00
dcli -l root -c myexacel04 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:17:49-04:00
dcli -l root -c myexacel05 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:55-04:00
dcli -l root -c myexacel06 'cellcli -e drop alerthistory 5_1' ### 2018-10-06T19:18:46-04:00
dcli -l root -c myexacel07 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:13-04:00
dcli -l root -c myexacel08 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:19:01-04:00
dcli -l root -c myexacel09 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:36-04:00
dcli -l root -c myexacel10 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:19:26-04:00
dcli -l root -c myexacel11 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:16-04:00
dcli -l root -c myexacel12 'cellcli -e drop alerthistory 5_1' ### 2018-10-06T19:18:11-04:00
dcli -l root -c myexacel13 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:17:53-04:00
dcli -l root -c myexacel14 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:03-04:00
For DB Servers
# dcli -l root -g dbs_group 'dbmcli -e list alerthistory' | grep 'Diagnostic packages' | awk '{print "dcli -l root -c " $1 " \x27" "dbmcli -e drop alerthistory " $2 "\x27" " ### " $3}' | sed 's/://'
I then checked with Oracle about this and found out this is a new feature (12 release) and it is okay to ignore. But I was really bugged by the nuisance emails. So I thought of clearing it.
But I have more than 5 Exadatas which are full racks and I do not want to clear all alerts but these itself (for Diagnostic Package)
So, I came up with a small automation which will generate the right commands for me.
Here is what I did
For Cell Servers
# dcli -l root -g cell_group 'cellcli -e list alerthistory' | grep 'Diagnostic packages' | awk '{print "dcli -l root -c " $1 " \x27" "cellcli -e drop alerthistory " $2 "\x27" " ### " $3}' | sed 's/://'
dcli -l root -c myexacel01 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:16:52-04:00
dcli -l root -c myexacel02 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:19:15-04:00
dcli -l root -c myexacel03 'cellcli -e drop alerthistory 5_1' ### 2018-10-06T19:18:51-04:00
dcli -l root -c myexacel04 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:17:49-04:00
dcli -l root -c myexacel05 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:55-04:00
dcli -l root -c myexacel06 'cellcli -e drop alerthistory 5_1' ### 2018-10-06T19:18:46-04:00
dcli -l root -c myexacel07 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:13-04:00
dcli -l root -c myexacel08 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:19:01-04:00
dcli -l root -c myexacel09 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:36-04:00
dcli -l root -c myexacel10 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:19:26-04:00
dcli -l root -c myexacel11 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:16-04:00
dcli -l root -c myexacel12 'cellcli -e drop alerthistory 5_1' ### 2018-10-06T19:18:11-04:00
dcli -l root -c myexacel13 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:17:53-04:00
dcli -l root -c myexacel14 'cellcli -e drop alerthistory 4_1' ### 2018-10-06T19:18:03-04:00
For DB Servers
# dcli -l root -g dbs_group 'dbmcli -e list alerthistory' | grep 'Diagnostic packages' | awk '{print "dcli -l root -c " $1 " \x27" "dbmcli -e drop alerthistory " $2 "\x27" " ### " $3}' | sed 's/://'
dcli -l root -c mydbnode01 'dbmcli -e drop alerthistory 7_1' ### 2019-08-14T08:06:48-04:00
dcli -l root -c mydbnode02 'dbmcli -e drop alerthistory 7_1' ### 2019-08-14T08:06:42-04:00
dcli -l root -c mydbnode03 'dbmcli -e drop alerthistory 7_1' ### 2019-08-14T08:06:50-04:00
dcli -l root -c mydbnode04 'dbmcli -e drop alerthistory 7_1' ### 2019-08-14T08:06:38-04:00
dcli -l root -c mydbnode05 'dbmcli -e drop alerthistory 7_1' ### 2019-08-14T08:06:43-04:00
No comments:
Write comments