Exadata useful commands cellcli

Exadata useful commands

cellcli>  List cell detail

this gives all the details related to storage cell server

cellcli> list alerthistory

Displays all the alerts sent

cellcli> list alerthistory 1 detail

lists alert detail with additional information

cellcli> drop alerthistory 1,2,3

Drops alerthistory so it wont repeat alerts and also if you clear all alerts it wont send weekly alert summary report

cellcli> alter cell smtpToAddr='xxx-DBA-Alerts@xxx.local,xxxunix@xxx.local'

Configure email alerts. You can modify email above to your liking to recieve alerts

CellCLI> alter cell validate mail

If there is an error it will show here or it will send an test email.

CellCLI> drop quarantine all;

Drops all the quarantined sql before

Cellcli> list offload group

If cellsrv crashes some times offload group will be in stopped state. To check the status use above commands

cellcli> alter offloadgroup <group_name> restart;

To restart the offload group


****************************************************************************

Cell server Alert log location
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log

Refer
https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/cellcli.htm#SAGUG20555