Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching, Zero-Downtime Upgrade, GoldenGate

Oracle Exadata ,Oracle ODA, Oracle ZDLRA


当前位置： 首页 » 技术文章 » Exadata

ODA存储诊断工具odasundiag.sh and oakcli stordiag

时间: 2017-05-21 22:49:42  | 作者: ohsdba  | 
如非注明，本站文章皆为原创。欢迎转载，转载时请注明出处和作者信息。
在Exadata上，我们可以通过sundiag.sh收集硬件的信息，在ODA或者ODA虚拟化上，我们可以odasundiag.sh脚本去收集硬件的信息，通过oakcli stordiag去收集详细的磁盘信息，比如SSD的使用情况等。

oakcli show disk 

[root@x5odadb0 ~]# oakcli show disk
NAME           PATH           TYPE           STATE          STATE_DETAILS
e0_pd_00       /dev/sda       HDD            ONLINE         Good           
e0_pd_01       /dev/sdb       HDD            ONLINE         Good           
e0_pd_02       /dev/sdc       HDD            ONLINE         Good           
e0_pd_03       /dev/sdd       HDD            ONLINE         Good           
e0_pd_04       /dev/sde       HDD            ONLINE         Good           
e0_pd_05       /dev/sdf       HDD            ONLINE         Good           
e0_pd_06       /dev/sdg       HDD            ONLINE         Good           
e0_pd_07       /dev/sdaa      HDD            ONLINE         Good           
e0_pd_08       /dev/sdab      HDD            ONLINE         Good           
e0_pd_09       /dev/sdac      HDD            ONLINE         Good           
e0_pd_10       /dev/sdad      HDD            ONLINE         Good           
e0_pd_11       /dev/sdae      HDD            ONLINE         Good           
e0_pd_12       /dev/sdaf      HDD            ONLINE         Good           
e0_pd_13       /dev/sdag      HDD            ONLINE         Good           
e0_pd_14       /dev/sdah      HDD            ONLINE         Good           
e0_pd_15       /dev/sdai      HDD            ONLINE         Good           
e0_pd_16       /dev/sdaj      SSD            ONLINE         Good           
e0_pd_17       /dev/sdam      SSD            ONLINE         Good           
e0_pd_18       /dev/sdan      SSD            ONLINE         Good           
e0_pd_19       /dev/sdak      SSD            ONLINE         Good           
e0_pd_20       /dev/sdal      SSD            ONLINE         Good           
e0_pd_21       /dev/sdao      SSD            ONLINE         Good           
e0_pd_22       /dev/sdap      SSD            ONLINE         Good           
e0_pd_23       /dev/sdaq      SSD            ONLINE         Good           
[root@x5odadb0 ~]#

oakcli stordiag e0_pd_16 

[root@x5odadb0 install]# oakcli stordiag e0_pd_16 
Node Name : x5odadb0
 Test : Diagnostic Test Description

   1  : OAK Check
        NAME            PATH            TYPE            STATE           STATE_DETAILS
        e0_pd_16       /dev/sdaj      SSD            ONLINE         Good

   2  : ASM Check
        ASM Disk Status                        :  group_number   state   mode_s  mount_s header_s
        /dev/mapper/SSD_E0_S16_1320344604p1    :         2       NORMAL  ONLINE  CACHED  MEMBER

   3  : Check SSD Media used endurance indicator
        SS Media used endurance indicator: 0%

   4  : Multipathd Status
        multipathd running on system

   5  : Multipath Status
        Device List : /dev/sdq   /dev/sdaj
        Info:
             SSD_E0_S16_1320344604 (35000cca04eb2dc1c) dm-8 HGST,HSCAC2DA4SUN400G
             size=373G features='0' hwhandler='0' wp=rw
             `-+- policy='round-robin 0' prio=1 status=active
               |- 2:0:16:0 sdq  65:0   active ready running
               `- 3:0:16:0 sdaj 66:48  active ready running

   6  : Check Partition using parted
        Check using active device path: /dev/sdq
        Partition check on device /dev/sdq  :  PASS
        Partition list found by parted for active device path: /dev/sdq
              1      2097kB  400GB  400GB  primary
        Check using passive device path: /dev/sdaj
        Partition check on device /dev/sdaj  :  PASS
        Partition list found by parted for passive device path: /dev/sdaj
              1      2097kB  400GB  400GB  primary
   7  : Device Mapper Diagnostics
        Mapper Device : dm-8
        Partition List: SSD_E0_S16_1320344604p1
        Permissions :
                      /dev/mapper/SSD_E0_S16_1320344604p1 : brw-rw----  grid  asmadmin
        Open Ref Count:
        SSD_E0_S16_1320344604p1      :  7


   8  : asmappl.config and multipath.conf consistency check
          /opt/oracle/extapi/asmappl.config file is in sync between nodes
          /etc/multipath.conf file is in sync between nodes

   9  : fwupdate
        ID        Manufacturer   Model               Chassis Slot   Type   Media   Size (GB) FW Version XML Support
        c0d16     HGST           HSCAC2DA4SUN400G    0       16     sas    SSD     373       A29A       N/A
        c1d16     HGST           HSCAC2DA4SUN400G    0       16     sas    SSD     373       A29A       N/A


  10  : Fishwrap
          Controller "mpt3sas:00:04.0"
                Disk  /dev/sdq: HGST HSCAC2DA4SUN400G (s/n "001620JQBB9A        0QY5BB9A"), bay 16
          Controller "mpt3sas:00:05.0"
                Disk  /dev/sdaj: HGST HSCAC2DA4SUN400G (s/n "001620JQBB9A        0QY5BB9A"), bay 16

  11  : SCSI INQUIRY
        Active multipath device /dev/sdq  :  PASS
        Active multipath device /dev/sdaj  :  PASS

  12  : Multipath Conf for device
           multipath {
             wwid 35000cca04eb2dc1c
             alias SSD_E0_S16_1320344604
       }

  13  : Last few LSI Events Received for slot 16
          [INFO]: No LSI events are recorded in OAKD logs

  14  : Version Information
          OAK              :  12.1.2.9.0
          kernel           :  2.6.39-400.290.1.el6uek.x86_64
          mpt2sas          :  17.00.06.00
          Multipath        :  0.4.9
          Disk Firmware    :  A29A

  15  : OAK Conf Parms
        Device : queue_depth     Timeout         max_sectors_kb  nr_requests     read_ahead_kb   scheduler
      /dev/sdq :     64              30               1024           4096           128            noop [deadline] cfq
     /dev/sdaj :     64              30               1024           4096           128            noop [deadline] cfq

          ******************************
          ********** 2nd NODE **********
          ******************************

 Node Name : x5odadb1
 Test : Diagnostic Test Description

   1  : OAK Check
        NAME            PATH            TYPE            STATE           STATE_DETAILS
        e0_pd_16       /dev/sdao      SSD            ONLINE         Good

   2  : ASM Check
        ASM Disk Status                        :  group_number   state   mode_s  mount_s header_s
        /dev/mapper/SSD_E0_S16_1320344604p1    :         2       NORMAL  ONLINE  CACHED  MEMBER

   3  : Check SSD Media used endurance indicator
        SS Media used endurance indicator: 0%
   4  : Multipathd Status
        multipathd running on system

   5  : Multipath Status
        Device List : /dev/sdq   /dev/sdao
        Info:
             SSD_E0_S16_1320344604 (35000cca04eb2dc1c) dm-28 HGST,HSCAC2DA4SUN400G
             size=373G features='0' hwhandler='0' wp=rw
             `-+- policy='round-robin 0' prio=1 status=active
               |- 2:0:16:0 sdq  65:0   active ready running
               `- 3:0:16:0 sdao 66:128 active ready running

   6  : Check Partition using parted
        Check using active device path: /dev/sdq
        Partition check on device /dev/sdq  :  PASS
        Partition list found by parted for active device path: /dev/sdq
              1      2097kB  400GB  400GB  primary
        Check using passive device path: /dev/sdao
        Partition check on device /dev/sdao  :  PASS
        Partition list found by parted for passive device path: /dev/sdao
              1      2097kB  400GB  400GB  primary

   7  : Device Mapper Diagnostics
        Mapper Device : dm-28
        Partition List: SSD_E0_S16_1320344604p1
        Permissions :
                      /dev/mapper/SSD_E0_S16_1320344604p1 : brw-rw----  grid  asmadmin
        Open Ref Count:
        SSD_E0_S16_1320344604p1      :  9

   8  : asmappl.config and multipath.conf consistency check
          /opt/oracle/extapi/asmappl.config file is in sync between nodes
          /etc/multipath.conf file is in sync between nodes

   9  : fwupdate
        ID        Manufacturer   Model               Chassis Slot   Type   Media   Size (GB) FW Version XML Support
        c0d16     HGST           HSCAC2DA4SUN400G    0       16     sas    SSD     373       A29A       N/A
        c1d16     HGST           HSCAC2DA4SUN400G    0       16     sas    SSD     373       A29A       N/A

  10  : Fishwrap
          Controller "mpt3sas:00:04.0"
                Disk  /dev/sdq: HGST HSCAC2DA4SUN400G (s/n "001620JQBB9A        0QY5BB9A"), bay 16
          Controller "mpt3sas:00:05.0"
                Disk  /dev/sdao: HGST HSCAC2DA4SUN400G (s/n "001620JQBB9A        0QY5BB9A"), bay 16

  11  : SCSI INQUIRY
        Active multipath device /dev/sdq  :  PASS
        Active multipath device /dev/sdao  :  PASS

  12  : Multipath Conf for device
           multipath {
             wwid 35000cca04eb2dc1c
             alias SSD_E0_S16_1320344604
       }

  13  : Last few LSI Events Received for slot 16
          [INFO]: No LSI events are recorded in OAKD logs

  14  : Version Information
          OAK              :  12.1.2.9.0
          kernel           :  2.6.39-400.290.1.el6uek.x86_64
          mpt2sas          :  17.00.06.00
          Multipath        :  0.4.9
          Disk Firmware    :  A29A

  15  : OAK Conf Parms
        Device : queue_depth     Timeout         max_sectors_kb  nr_requests     read_ahead_kb   scheduler
      /dev/sdq :     64              30               1024           4096           128            noop [deadline] cfq
     /dev/sdao :     64              30               1024           4096           128            noop [deadline] cfq

Above details can also be found in the log file=/opt/oracle/oak/log/x5odadb0/stordiag/stordiag_e0_pd_16-2017-05-20-18:59:52.log

[root@x5odadb0 install]#                          

multipath -ll输出

[root@x5odadb0 install]# multipath -ll
HDD_E0_S13_1612136304 (35000cca260173f70) dm-15 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:13:0 sdn  8:208  active ready running
  `- 3:0:13:0 sdag 66:0   active ready running
HDD_E0_S02_1612134916 (35000cca260173a04) dm-0 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:2:0  sdc  8:32   active ready running
  `- 3:0:2:0  sdv  65:80  active ready running
SSD_E0_S22_1320467808 (35000cca04eb4bd60) dm-41 HGST,HSCAC2DA6SUN200G
size=186G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:23:0 sdap 66:144 active ready running
  `- 3:0:23:0 sdau 66:224 active ready running
HDD_E0_S00_1612291584 (35000cca260199e00) dm-2 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:0:0  sda  8:0    active ready running
  `- 3:0:0:0  sdt  65:48  active ready running
HDD_E0_S10_1612355220 (35000cca2601a9694) dm-12 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:10:0 sdk  8:160  active ready running
  `- 3:0:10:0 sdad 65:208 active ready running
SSD_E0_S21_1320467632 (35000cca04eb4bcb0) dm-39 HGST,HSCAC2DA6SUN200G
size=186G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:22:0 sdao 66:128 active ready running
  `- 3:0:22:0 sdat 66:208 active ready running
HDD_E0_S08_1612271224 (35000cca260194e78) dm-7 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:8:0  sdi  8:128  active ready running
  `- 3:0:8:0  sdab 65:176 active ready running
HDD_E0_S09_1612322144 (35000cca2601a1560) dm-10 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:9:0  sdj  8:144  active ready running
  `- 3:0:9:0  sdac 65:192 active ready running
HDD_E0_S07_1612344420 (35000cca2601a6c64) dm-6 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:7:0  sdh  8:112  active ready running
  `- 3:0:7:0  sdaa 65:160 active ready running
SSD_E0_S23_1320469008 (35000cca04eb4c210) dm-44 HGST,HSCAC2DA6SUN200G
size=186G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:24:0 sdaq 66:160 active ready running
  `- 3:0:24:0 sdav 66:240 active ready running
HDD_E0_S03_1612244532 (35000cca26018e634) dm-3 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:3:0  sdd  8:48   active ready running
  `- 3:0:3:0  sdw  65:96  active ready running
HDD_E0_S12_1612137048 (35000cca260174258) dm-13 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:12:0 sdm  8:192  active ready running
  `- 3:0:12:0 sdaf 65:240 active ready running
HDD_E0_S04_1612321172 (35000cca2601a1194) dm-1 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:4:0  sde  8:64   active ready running
  `- 3:0:4:0  sdx  65:112 active ready running
HDD_E0_S11_1611067952 (35000cca26006f230) dm-22 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:11:0 sdl  8:176  active ready running
  `- 3:0:11:0 sdae 65:224 active ready running
SSD_E0_S17_1320347600 (35000cca04eb2e7d0) dm-30 HGST,HSCAC2DA4SUN400G
size=373G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:20:0 sdam 66:96  active ready running
  `- 3:0:20:0 sdar 66:176 active ready running
SSD_E0_S18_1320344696 (35000cca04eb2dc78) dm-32 HGST,HSCAC2DA4SUN400G
size=373G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:21:0 sdan 66:112 active ready running
  `- 3:0:21:0 sdas 66:192 active ready running
SSD_E0_S20_1320464144 (35000cca04eb4af10) dm-14 HGST,HSCAC2DA6SUN200G
size=186G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:18:0 sds  65:32  active ready running
  `- 3:0:18:0 sdal 66:80  active ready running
HDD_E0_S14_1612349508 (35000cca2601a8044) dm-25 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:14:0 sdo  8:224  active ready running
  `- 3:0:14:0 sdah 66:16  active ready running
HDD_E0_S05_1612344404 (35000cca2601a6c54) dm-4 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:5:0  sdf  8:80   active ready running
  `- 3:0:5:0  sdy  65:128 active ready running
HDD_E0_S15_1612242988 (35000cca26018e02c) dm-23 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:15:0 sdp  8:240  active ready running
  `- 3:0:15:0 sdai 66:32  active ready running
SSD_E0_S19_1320344516 (35000cca04eb2dbc4) dm-9 HGST,HSCAC2DA4SUN400G
size=373G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:17:0 sdr  65:16  active ready running
  `- 3:0:17:0 sdak 66:64  active ready running
SSD_E0_S16_1320344604 (35000cca04eb2dc1c) dm-8 HGST,HSCAC2DA4SUN400G
size=373G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:16:0 sdq  65:0   active ready running
  `- 3:0:16:0 sdaj 66:48  active ready running
HDD_E0_S01_1612292572 (35000cca26019a1dc) dm-5 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:1:0  sdb  8:16   active ready running
  `- 3:0:1:0  sdu  65:64  active ready running
HDD_E0_S06_1612316556 (35000cca26019ff8c) dm-11 HGST,H7280A520SUN8.0T
size=7.2T features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 2:0:6:0  sdg  8:96   active ready running
  `- 3:0:6:0  sdz  65:144 active ready running
[root@x5odadb0 install]#


关键词:x5-2 oda cloud 

相关文章

Oracle Cloud Native Solutions
Oracle Kubernetes Engine
Terraform,docker,wercker,k8s
Vagrant with oracle
Oracle自治数据仓库云
OMC - How to Install Gateway Agent
Oracle大数据之交互式快速参考
Oracle数据库云服务
Oracle数据库备份云服务
Oracle RAC and Third Party Cloud
Oracle Database Multilingual Engine(MLE)
Oracle GraalVM

推荐文章

联系我们

Oracle Software Download Index

Oracle Database Upgrade

Oracle SQLMaria

Oracle Database Document

Oracle Cloud Document

Oracle Cloud中文链接

eDelivery

GoldenGate

My Oracle Support

Exadata Document

Oracle Linux

Oracle Fusion Middleware

MySQL Document

PostgreSQL

Python

Apache

Github

Sourceforge

CNCF

Ruby

Go

ipcheck

ipaddressguide

db-engines

Linux Kernel

Top