HealthCheck<\/b> HealthCheck scripts run from \/usr\/oracle\/healthcheck healthcheck binaries can be copied from Frame to Frame by tar’ing all the files up and scp to new location.<\/p>\n
Change all Cell\/DBNode passwords at once<\/b> PASSWORD=<value> dcli -l root -g ~\/all_group “echo ${PASSWORD} | passwd –stdin root”<\/p>\n
Status of Cluster<\/b> \/usr\/oracle\/grid\/product\/ora11gR2\/bin\/crsctl stat res -t<\/p>\n
Hardware sensors Status or detailed sensor info<\/b> ipmitool sdr | grep -v ok ipmitool sensor<\/p>\n
Gather all diagnostics information<\/b> \/opt\/oracle.SupportTools\/onecommand\/diagget.sh<\/p>\n
Hardware Profile<\/b> \/opt\/oracle.SupportTools\/CheckHWnFWProfile -S > tmp\/CheckHWnFWProfile_dm10db01.cbp.dhs.gov.txt<\/p>\n
Infiniband\/RDS Status<\/b> ibstatus rds-info -n<\/p>\n
Status of network connections<\/b> ip n s ip sar -n DEV 1 3 ip -s link show<\/p>\n
Confirm Storage Cell Status<\/b> dcli -l root -g ~\/cell_group ‘cellcli -e list cell’<\/p>\n
Additional Reading (MOS Notes)<\/b> 888828.1 – Database Machine and Exadata Storage Server 11g Release 2 (11.2) Supported Versions 1078889.1 – Exadata calibrate reports substandard IOPS on SAS drives 1093890.1 – Steps To Shutdown\/Startup The Exadata & RDBMS Services and Cell\/Compute Nodes 757552.1 – Oracle Exadata Best Practices 1120955.1 – Exadata V2: How To Startup or Shutdown An Exadata Or Compute Node Server Thru ILOM? 735323.1 – Exadata Storage Server Diagnostic Collection Guide 1053498.1 – Network Diagnostics information for Oracle Database Machine Environments 1072676.1 – Exadata General FAQ 1070954.1 – Oracle Exadata Database Machine exachk or HealthCheck 735323.1 – Exadata Storage Server Diagnostic Collection Guide 1071221.1 – Oracle Sun Database Machine Backup and Recovery Best Practices 359395.1 – Remote Diagnostic Agent (RDA) 4 – RAC Cluster Guide 085606 – Yum repo – http:\/\/www.oracle.com\/technetwork\/topics\/linux\/yum-repository-setup-085606.html<\/a> 1317159.1 – Changing IP addresses on Exadata Database Machine 361468.1 – HugePages on Oracle Linux 64-bit Best Practices: http:\/\/www.oracle.com\/technetwork\/database\/features\/availability\/exadata-maa-best-practices-155385.html<\/a><\/p>\n <\/p>\n DB NODES<\/p>\n Automated Diagnostics Repository (ADR) Report<\/b> adrci> show homes adrci> set homepath <diag path for the instance that generated the incident> adrci> ips create package incident <incident number> adrci> ips generate package 1 in \/tmp<\/p>\n Reset BMC<\/b> dcli -l root -g ~\/dbs_group ipmitool bmc reset cold<\/p>\n Display Disks Status<\/b> dcli -l root -g ~\/cell_group ‘cellcli -e list griddisk attributes name,size,status,asmmodestatus’ dcli -l root -g ~\/cell_group ‘cellcli -e list celldisk’<\/p>\n Display Sensor Status<\/b> ipmitool sensor<\/p>\n Temperature<\/b> dcli -l root -g \/root\/all_group ipmitool sensor get T_AMB | grep -I Reading dcli -l root -g \/root\/cell_group ‘cellcli -e list cell detail’ | grep -i Reading<\/p>\n Restart OS Watcher<\/b> \/opt\/oracle.oswatcher\/osw\/stopOSW.sh \/opt\/oracle.cellos\/vldrun -script oswatcher<\/p>\n <\/p>\n INFINIBAND<\/p>\n Shows IB ports and status on the IB switch<\/b> listlinkup<\/p>\n IB\/RDS Status<\/b> ibstatus rds-info -n<\/p>\n Status of network connections<\/b> ip n s sar -n DEV 1 3 ip -s link show<\/p>\n <\/p>\n STORAGE CELLS<\/p>\n Capture all alerts from cell history based on a time stamp<\/b> dcli -l root -g ~\/cell_group cellcli -e “list alerthistory where begintime \\> \\’2011-05-25T00:00:00-05:00\\'”<\/p>\n Check\/change default disk timeout for cells (cell failure)<\/b> The default value for the timer is 3.6 hours, 0 is default. This column is in seconds. SQL> SELECT NAME, repair_timer from v$asm_disks; SQL> ALTER DISKGROUP DATA SET ATTRIBUTE ‘DISK_REPAIR_TIME’=’8.5H’;<\/p>\n Get cell disk info<\/b> cellcli -e list griddisk attributes name,size,offset,status<\/p>\n Help with cellcli<\/b> cellcli -e help alter cell<\/p>\n Reset BMC<\/b> dcli -l root -g ~\/cell_group cellcli -e “alter cell restart bmc”<\/p>\n Restart cell services<\/b> cellcli -e ‘alter cell restart services all’<\/p>\n Flashcache Disk Resurrection Procedure<\/b> disable alerts & monitoring cell shutdown init 6 cell startup (Run the command below until all disks are “active online yes”) cellcli -e list griddisk attributes name,status,asmmodestatus,asmdeactivationoutcome<\/p>\n Flashcache Disk Resurrection Procedure<\/b> disable alerts & monitoring cell shutdown init 6 cell startup (Run the command below until all disks are “active online yes”) cellcli -e list griddisk attributes name,status,asmmodestatus,asmdeactivationoutcome<\/p>\n Flash Cache Status\/Creation<\/b> dcli -l root -g ~\/cell_group cellcli -e ‘list flashcache’ cellcli -e ‘drop celldisk all flashdisk force’ cellcli -e ‘create celldisk all flashdisk’ cellcli -e ‘create flashcache all’<\/p>\n List total I\/O error counts<\/b> Can indicate a pending proactive\/predictive failure. dcli -l root -g ~\/cell_group cellcli -e “list griddisk where errorCount > 0 detail”<\/p>\n","protected":false},"excerpt":{"rendered":" HealthCheck HealthCheck scripts run from \/usr\/oracle\/healthcheck healthcheck binaries can be copied from Frame to Frame by tar’ing all the files up and scp to new location. Change all Cell\/DBNode passwords at once PASSWORD=<value> dcli -l root -g ~\/all_group “echo ${PASSWORD} | passwd –stdin root” Status of Cluster \/usr\/oracle\/grid\/product\/ora11gR2\/bin\/crsctl stat res -t Hardware sensors Status or […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-247","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=247"}],"version-history":[{"count":2,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions"}],"predecessor-version":[{"id":249,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions\/249"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}