Search

OakieTags

more tags

Who's online

There are currently 0 users and 34 guests online.

Recent comments

Affiliations

Home

Exadata Serial Numbers

Submitted by Kerry Osborne on Fri, 2011-02-18 02:51

Just a quick post (mostly so I can find the info quickly myself when I want it). Here’s how to get the master serial number for an Exadata Rack:

ipmitool sunoem cli ‘show /SP system_identifier’

Apparently by convention the Exadata Rack serial number is appended to the end of ILOM system identifier string. Here’s an example:

#99cc00">?View Code NONE
[enkdb01:root] /root 
> ipmitool sunoem cli 'show /SP system_identifier'
Connected. Use ^D to exit.
-> show /SP system_identifier
 
  /SP
    Properties:
        system_identifier = Sun Oracle Database Machine _YOUR_SERIAL_NUMBER_HERE_
 
 
-> Session closed
Disconnected

Thanks to Dan Norris for that bit of info.

You can also get the individual serial numbers for each component in an Exadata Rack like this:

/opt/oracle.SupportTools/CheckHWnFWProfile -S

So you would log on to each machine and run this. Here’s the output from one of the DB Servers in our system:

#99cc00">?View Code NONE
 
> /opt/oracle.SupportTools/CheckHWnFWProfile -S
 
====START SERIAL NUMBERS====
==Motherboard, from dmidecode==
--System serial--
1019XF5059            
--Motherboard serial--
0328MSL-10144H0XE2    
--Chassis serial--
1019XF5059            
==Infiniband HCA==
ID: qFalcon QDR
PN: 375-3606-02          
EC: 50
SN: 1388FMH-1005500316      
V0: PCIe Gen2 x8    
==InfiniBand Switch==
 Use the /opt/oracle.SupportTools/CheckSWProfile.sh -S option to get the switch serial numbers
==Disk Controller==
Product Name    : LSI MegaRAID SAS 9261-8i
Serial No       : SV00800405
==Disks==
Enclosure:Slot Type Make Model Serial
252:0 SAS HITACHI H103014SCSUN146G 1017FAJW9E
252:1 SAS HITACHI H103014SCSUN146G 1017FBAY8E
252:2 SAS HITACHI H103014SCSUN146G 1017FAK0BE
252:3 SAS HITACHI H103014SCSUN146G 1017FB8PHE
==Motherboard, RAM etc from ipmitool==
FRU Device Description : Builtin FRU Device (LUN 0, ID 0)
 Product Manufacturer  : SUN MICROSYSTEMS
 Product Name          : ILOM INTEGRATED SP  
 
FRU Device Description : /SYS (LUN 0, ID 3)
 Board Product         : ASSY,MOTHERBOARD,X4170/X4270/X4275  
 Board Serial          : 0328MSL-10144H0XE2
 Board Part Number     : 501-7917-11
 Board Extra           : 54
 Board Extra           : X4170/4270/4275
 Product Manufacturer  : SUN MICROSYSTEMS
 Product Name          : SUN FIRE X4170 SERVER   
 Product Part Number   : 602-4927-02
 Product Serial        : 1019XF5059
 Product Extra         : 080020FFFFFFFFFFFFFF00212883E184
 
FRU Device Description : MB (LUN 0, ID 4)
 Board Product         : ASSY,MOTHERBOARD,X4170/X4270/X4275  
 Board Serial          : 0328MSL-10144H0XE2
 Board Part Number     : 501-7917-11
 Board Extra           : 54
 Board Extra           : X4170/4270/4275
 Product Manufacturer  : SUN MICROSYSTEMS
 Product Name          : SUN FIRE X4170 SERVER   
 Product Part Number   : 602-4927-02
 Product Serial        : 1019XF5059
 Product Extra         : 080020FFFFFFFFFFFFFF00212883E184
 
FRU Device Description : MB/BIOS (LUN 0, ID 5)
 Product Manufacturer  : AMERICAN MEGATRENDS 
 Product Name          : SYSTEM BIOS 
 Product Part Number   : AMIBIOS8
 Product Version       : 07060223
 
FRU Device Description : MB/NET0 (LUN 0, ID 43)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:80
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:80
 
FRU Device Description : mb.net0.fru (LUN 0, ID 43)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:80
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:80
 
FRU Device Description : MB/NET1 (LUN 0, ID 44)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:81
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:81
 
FRU Device Description : mb.net1.fru (LUN 0, ID 44)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:81
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:81
 
FRU Device Description : MB/NET2 (LUN 0, ID 45)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:82
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:82
 
FRU Device Description : mb.net2.fru (LUN 0, ID 45)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:82
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:82
 
FRU Device Description : MB/NET3 (LUN 0, ID 46)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:83
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:83
 
FRU Device Description : mb.net3.fru (LUN 0, ID 46)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:83
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:83
 
FRU Device Description : /UUID (LUN 0, ID 6)
 Product Extra         : 080020FFFFFFFFFFFFFF00212883E184
 
FRU Device Description : SP/NET0 (LUN 0, ID 1)
 Product Manufacturer  : ASPEED  
 Product Name          : ETHERNET CONTROLLER 
 Product Part Number   : AST2100
 Product Serial        : 00:21:28:83:e1:84
 Product Extra         : 01
 Product Extra         : 00:21:28:83:e1:84
 
FRU Device Description : SP/NET1 (LUN 0, ID 2)
 Product Manufacturer  : ASPEED  
 Product Name          : ETHERNET CONTROLLER 
 Product Part Number   : AST2100
 Product Serial        : 00:21:28:83:e1:85
 Product Extra         : 01
 Product Extra         : 00:21:28:83:e1:85
 
FRU Device Description : MB/P0 (LUN 0, ID 16)
 Product Manufacturer  : INTEL   
 Product Name          : INTEL(R) XEON(R) CPU           E5540  @ 2.53GHZ 
 Product Part Number   : 060A
 Product Version       : 05
 
FRU Device Description : MB/P1 (LUN 0, ID 17)
 Product Manufacturer  : INTEL   
 Product Name          : INTEL(R) XEON(R) CPU           E5540  @ 2.53GHZ 
 Product Part Number   : 060A
 Product Version       : 05
 
FRU Device Description : MB/P0/D0 (LUN 0, ID 24)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 1A86965A
 
FRU Device Description : MB/P0/D1 (LUN 0, ID 25)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04B25956
 
FRU Device Description : MB/P0/D2 (LUN 0, ID 26)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0462594F
 
FRU Device Description : MB/P0/D3 (LUN 0, ID 27)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04125951
 
FRU Device Description : MB/P0/D4 (LUN 0, ID 28)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04525976
 
FRU Device Description : MB/P0/D5 (LUN 0, ID 29)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04525964
 
FRU Device Description : MB/P0/D6 (LUN 0, ID 30)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0432597B
 
FRU Device Description : MB/P0/D7 (LUN 0, ID 31)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0422595A
 
FRU Device Description : MB/P0/D8 (LUN 0, ID 32)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0432595A
 
FRU Device Description : MB/P1/D0 (LUN 0, ID 33)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D634EE4
 
FRU Device Description : MB/P1/D1 (LUN 0, ID 34)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2DC34EA7
 
FRU Device Description : MB/P1/D2 (LUN 0, ID 35)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D234E9F
 
FRU Device Description : MB/P1/D3 (LUN 0, ID 36)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D634E94
 
FRU Device Description : MB/P1/D4 (LUN 0, ID 37)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D534EE1
 
FRU Device Description : MB/P1/D5 (LUN 0, ID 38)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D334EE3
 
FRU Device Description : MB/P1/D6 (LUN 0, ID 39)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 1A76965D
 
FRU Device Description : MB/P1/D7 (LUN 0, ID 40)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 1AB6965B
 
FRU Device Description : MB/P1/D8 (LUN 0, ID 41)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04625970
 
FRU Device Description : PCIE1/F20CARD (LUN 0, ID 225)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : PCIE2/F20CARD (LUN 0, ID 226)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : PS0 (LUN 0, ID 63)
 Board Mfg             : EMERSON
 Board Product         : A237
 Board Serial          : 1357ZHO-1012BF1NLY
 Board Part Number     : 300-2143-04
 Power Supply Record
  Capacity                   : 760 W
  Peak VA                    : 880 VA
  Inrush Current             : 25 A
  Inrush Interval            : 200 ms
  Input Voltage Range 1      : 90-264 V
  Input Voltage Range 2      : 0-0 V
  Input Frequency Range      : 47-63 Hz
  A/C Dropout Tolerance      : 12 ms
  Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin de-assertion'
  Peak capacity              : 760 W
  Peak capacity holdup       : 15 s
  Combined capacity          : not specified
  Fan lower threshold        : 0 RPS
 DC Output Record
  Output Number              : 2
  Standby power              : No
  Nominal voltage            : 12.00 V
  Max negative deviation     : 11.88 V
  Max positive deviation     : 12.12 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.050 A
  Maximum current draw       : 6.230 A
 DC Output Record
  Output Number              : 2
  Standby power              : Yes
  Nominal voltage            : 3.30 V
  Max negative deviation     : 3.20 V
  Max positive deviation     : 3.40 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.000 A
  Maximum current draw       : 0.360 A
 
FRU Device Description : PS1 (LUN 0, ID 64)
 Board Mfg             : EMERSON
 Board Product         : A237
 Board Serial          : 1357ZHO-1010BF1LGG
 Board Part Number     : 300-2143-04
 Power Supply Record
  Capacity                   : 760 W
  Peak VA                    : 880 VA
  Inrush Current             : 25 A
  Inrush Interval            : 200 ms
  Input Voltage Range 1      : 90-264 V
  Input Voltage Range 2      : 0-0 V
  Input Frequency Range      : 47-63 Hz
  A/C Dropout Tolerance      : 12 ms
  Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin de-assertion'
  Peak capacity              : 760 W
  Peak capacity holdup       : 15 s
  Combined capacity          : not specified
  Fan lower threshold        : 0 RPS
 DC Output Record
  Output Number              : 2
  Standby power              : No
  Nominal voltage            : 12.00 V
  Max negative deviation     : 11.88 V
  Max positive deviation     : 12.12 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.050 A
  Maximum current draw       : 6.230 A
 DC Output Record
  Output Number              : 2
  Standby power              : Yes
  Nominal voltage            : 3.30 V
  Max negative deviation     : 3.20 V
  Max positive deviation     : 3.40 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.000 A
  Maximum current draw       : 0.360 A
 
FRU Device Description : DBP (LUN 0, ID 210)
 Board Product         : BD,ASY,1U,8DSK BKPL,SATA
 Board Serial          : C00UHC
 Board Part Number     : 511-1283-03
 Board Extra           : 50
 Board Extra           : SASBP
 
FRU Device Description : PDB (LUN 0, ID 211)
 Board Product         : ASY,PDB,H1M1G1  
 Board Serial          : F06TJC
 Board Part Number     : 501-7696-10
 Board Extra           : 50
 Board Extra           : PDB
 Product Part Number   : 602-4927-02
 Product Serial        : 1019XF5059
 
FRU Device Description : PADCRD (LUN 0, ID 222)
 Board Product         : BD,ASY,PADDLE,1U
 Board Serial          : 0226LHF-101000049B
 Board Part Number     : 541-3512-02
 Board Extra           : 51
 Board Extra           : 1U Paddle
 
FRU Device Description : FB0 (LUN 0, ID 212)
 Board Product         : ASY,FAN,BOARD,H1M1G1
 Board Serial          : 0226LHF-1010A402TW
 Board Part Number     : 541-2112-04
 Board Extra           : 52
 Board Extra           : FANBD
 
FRU Device Description : FB1 (LUN 0, ID 213)
 Board Product         : ASY,FAN,BOARD,H1M1G1
 Board Serial          : 0226LHF-1010A402TH
 Board Part Number     : 541-2112-04
 Board Extra           : 52
 Board Extra           : FANBD
 
FRU Device Description : DBP/HDD0 (LUN 0, ID 47)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD1 (LUN 0, ID 48)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD2 (LUN 0, ID 49)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD3 (LUN 0, ID 50)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD4 (LUN 0, ID 51)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD5 (LUN 0, ID 52)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD6 (LUN 0, ID 53)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD7 (LUN 0, ID 54)
 Device not present (Requested sensor, data, or record not found)
 
====END SERIAL NUMBERS====
 
[enkdb01:root] /root


(UPDATE: the command mentioned by davidr in the comments gives the serial number for the server you are connected to, be it DB or Storage): The command is:

         ipmitool sunoem cli "show /SYS product_serial_number"