当前位置：文档库 › Exadata硬件检查

Exadata硬件检查

一、检查数据库服务器状态

1、检查ilom状态有没有部件报错，正常输出为空。

# ipmitool sunoem cli "show faulty"

-> show faulty

Target | Property | Value

--------------------+------------------------+---------------------------------

-> Session closed

Disconnected

2、检查硬盘状态，正常都为online,spun up

# /opt/MegaRAID/MegaCli/MegaCli64 -Pdlist -a0 | grep "Slot\|Firmware state"

Slot Number: 0

Firmware state: Online, Spun Up

Slot Number: 1

Firmware state: Online, Spun Up

Slot Number: 2

Firmware state: Online, Spun Up

Slot Number: 3

Firmware state: Online, Spun Up

3、检查硬件raid状态，正常为optimal

# /opt/MegaRAID/MegaCli/MegaCli64 -LdInfo -lAll -aAll

Adapter 0 -- Virtual Drive Information:

Virtual Drive: 0 (Target Id: 0)

Name :DBSYS

RAID Level : Primary-5, Secondary-0, RAID Level Qualifier-3

Size : 1.633 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 557.861 GB

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 4

Span Depth : 1

Creation Date : 04-02-2015

Creation Time : 02:36:39 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU

Current Cache Policy: WriteThrough, ReadAheadNone, Direct, No Write Cache

if Bad BBU

Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Exit Code: 0x00

4、检查硬件firmware状态，正常为success

#/opt/oracle.SupportTools/CheckHWnFWProfile -c strict

[SUCCESS] The hardware and firmware matches supported profile for

server=ORACLE_SERVER_X5-2

5、检查Infiniband网络状态，正常都为success

# /opt/oracle.SupportTools/ibdiagtools/verify-topology

[ DB Machine Infiniband Cabling Topology Verification Tool ]

Every node is connected to two leaf switches in a single rack.......................................................[SUCCESS]

Every inter-leaf switch link is connected correctly in a single rack................................................[SUCCESS]

Every leaf switch in an interconnected quarter rack is correctly connected to other rack in a multi-rack group......[NOT APPLICABLE]

Every leaf switch is connected to every spine switch in a multi-rack group..........................................[NOT APPLICABLE]

Every rack has balanced inter-leaf-and-spine switch links in a multi-rack group.....................................[NOT APPLICABLE]

No spine switch is connected to another spine switch in a multi-rack group..........................................[NOT APPLICABLE]

Every spine switch is connected to two external spine switches in a multi-rack group................................[NOT APPLICABLE]

No external spine switch is connected to a leaf switch in a multi-rack group........................................[NOT APPLICABLE]

No external spine switch is connected to another external spine switch in a multi-rack group........................[NOT APPLICABLE]

6、检查RAID卡上的电池状态，正常Battery State为Optimail。

# /opt/MegaRAID/MegaCli/MegaCli64 -AdpBbuCmd -a0

BBU status for Adapter: 0

BatteryType: CVPM02

Voltage: 10694 mV

Current: 0 mA

Temperature: 18 C

Battery State: Optimal

BBU Firmware Status:

Charging Status : None

Voltage : OK Temperature : OK Learn Cycle Requested : No Learn Cycle Active : No Learn Cycle Status : OK Learn Cycle Timeout : No I2c Errors Detected : No Battery Pack Missing : No Battery Replacement required : No Remaining Capacity Low : No Periodic Learn Required : No Transparent Learn : No No space to cache offload : No Pack is about to fail & should be replaced : No Cache Offload premium feature required : No Module microcode update required : No Pack energy : 342 J

Capacitance : 110

Remaining reserve space : 0

Battery backup charge time : 0 hours

BBU Design Info for Adapter: 0

Date of Manufacture: 09/12, 2014

Design Capacity: 288 J

Design Voltage: 9500 mV

Serial Number: 18222

Manufacture Name: LSI

Firmware Version : 6071-04A

Device Name: CVPM02

Device Chemistry: EDLC

Battery FRU: N/A

TMM FRU: N/A

Module Version = 6071-04A

Transparent Learn = 1

App Data = 0

BBU Properties for Adapter: 0

Auto Learn Period: 28 Days

Next Learn time: Wed Sep 2 15:06:36 2015

Learn Delay Interval:0 Hours

Auto-Learn Mode: Transparent

Exit Code: 0x00

7、检查文件系统使用率没有超过90％甚至100%

# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VGExaDb-LVDbSys1

30G 27G 1.2G 97% /

tmpfs 252G 633M 252G 1% /dev/shm /dev/sda1 504M 40M 439M 9% /boot

/dev/mapper/VGExaDb-LVDbOra1

99G 23G 72G 24% /u01

8、检查光纤网口的状态，Link detected 为yes

# ethtool eth4

Settings for eth4:

Supported ports: [ FIBRE ]

Supported link modes: 1000baseT/Full

10000baseT/Full

Supported pause frame use: No

Supports auto-negotiation: Yes

Advertised link modes: 1000baseT/Full

10000baseT/Full

Advertised pause frame use: No

Advertised auto-negotiation: Yes

Speed: 1000Mb/s

Duplex: Full

Port: FIBRE

PHYAD: 0

Transceiver: external

Auto-negotiation: on

Supports Wake-on: d

Wake-on: d

Current message level: 0x00000007 (7)

drv probe link

Link detected: yes

# ethtool eth5

Settings for eth5:

Supported ports: [ FIBRE ]

Supported link modes: 1000baseT/Full

10000baseT/Full

Supported pause frame use: No

Supports auto-negotiation: Yes

Advertised link modes: 1000baseT/Full

10000baseT/Full

Advertised pause frame use: No

Advertised auto-negotiation: Yes

Speed: 1000Mb/s

Duplex: Full

Port: FIBRE

PHYAD: 0

Transceiver: external

Auto-negotiation: on

Supports Wake-on: d

Wake-on: d

Current message level: 0x00000007 (7)

drv probe link

Link detected: yes

9、检查Infiniband网口的状态，正常状态为Active & LinkUp

# ibstatus

Infiniband device 'mlx4_0' port 1 status:

default gid: fe80:0000:0000:0000:0010:e000:0148:1e79

base lid: 0x3

sm lid: 0x2

state: 4: ACTIVE

phys state: 5: LinkUp

rate: 40 Gb/sec (4X QDR)

link_layer: IB

Infiniband device 'mlx4_0' port 2 status:

default gid: fe80:0000:0000:0000:0010:e000:0148:1e7a

base lid: 0x4

sm lid: 0x2

state: 4: ACTIVE

phys state: 5: LinkUp

rate: 40 Gb/sec (4X QDR)

link_layer: IB

二、检查存储服务器状态

1、检查ilom状态有没有部件报错，正常输出为空。

# ipmitool sunoem cli "show faulty"

-> show faulty

Target | Property | Value

--------------------+------------------------+---------------------------------

-> Session closed

Disconnected

2、检查硬盘状态，正常都为online,spun up

# /opt/MegaRAID/MegaCli/MegaCli64 -Pdlist -a0 | grep "Slot\|Firmware state"

Slot Number: 0

Firmware state: Online, Spun Up

Slot Number: 1

Firmware state: Online, Spun Up

Slot Number: 2

Firmware state: Online, Spun Up

Slot Number: 3

Firmware state: Online, Spun Up

Slot Number: 4

Firmware state: Online, Spun Up

Slot Number: 5

Firmware state: Online, Spun Up

Slot Number: 6

Firmware state: Online, Spun Up

Slot Number: 7

Firmware state: Online, Spun Up

Slot Number: 8

Firmware state: Online, Spun Up

Slot Number: 9

Firmware state: Online, Spun Up

Slot Number: 10

Firmware state: Online, Spun Up

Slot Number: 11

Firmware state: Online, Spun Up

3、检查硬件raid状态，正常为optimal

# /opt/MegaRAID/MegaCli/MegaCli64 -LdInfo -lAll -aAll

Adapter 0 -- Virtual Drive Information:

Virtual Drive: 0 (Target Id: 0)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:40 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 1 (Target Id: 1)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:41 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 2 (Target Id: 2)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:41 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 3 (Target Id: 3)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:41 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 4 (Target Id: 4)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:42 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 5 (Target Id: 5)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:42 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 6 (Target Id: 6)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:43 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 7 (Target Id: 7)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:43 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 8 (Target Id: 8)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:44 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 9 (Target Id: 9)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:44 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 10 (Target Id: 10)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:45 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU

Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Virtual Drive: 11 (Target Id: 11)

Name :

RAID Level : Primary-0, Secondary-0, RAID Level Qualifier-0

Size : 3.637 TB

Physical Sector Size: 512

Logical Sector Size : 512

VD has Emulated PD : No

Parity Size : 0

State : Optimal

Strip Size : 1.0 MB

Number Of Drives : 1

Span Depth : 1

Creation Date : 05-08-2015

Creation Time : 03:45:45 PM

Default Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Direct, No Write Cache if Bad BBU Default Access Policy: Read/Write

Current Access Policy: Read/Write

Disk Cache Policy : Disabled

Encryption Type : None

Bad Blocks Exist: No

PI type: No PI

Is VD Cached: No

Exit Code: 0x00

4、检查硬件firmware状态，正常为success

#/opt/oracle.SupportTools/CheckHWnFWProfile -c strict

[SUCCESS] The hardware and firmware matches supported profile for server=ORACLE_SERVER_X5-2L