Advertisement

Tuesday, August 20, 2019

Oracle Exadata: How I removed specific Alerts (Diagnostic Package cannot be uploaded to ASR server)

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/://'


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