Exadata Serial Numbers
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:
Apparently by convention the Exadata Rack serial number is appended to the end of ILOM system identifier string. Here’s an example:
[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:
So you would log on to each machine and run this. Here’s the output from one of the DB Servers in our system:
> /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"
Hi Kerry,
In the Owner’s Guide of Exadata, serial number is get with the following command :
Does this command return the same from DB machine host and cell storage ?
You mentionned “Exadata Rack serial number”, does this serial number correspond to a value return by the above command on the db machine an/or cell storage.
Regards.
Hi guys
The master serial number is set during installation of Exadata via ipmitool.
According to documentation :
“The rack master serial number is located on the top left side wall, when viewed from rear, inside the rack on the rear of the chassis.
It is also on the front rack frame on the left side inside the door, in the center near
the vented panels.”
Product_serial_number on DB machine and storage server are serial number of each host.
best regards
Thanks dawei,
Our rack has the serial number sticker in the back but not on the front. Someone may have taken the one on the front door off. The sticker matches the paperwork, which matches the output of the ipmitool sunoem cli ‘show /SP system_identifier’ command.
davidr,
That command shows the serial number of whatever machine you are logged into, so no it is different from machine to machine and is not the master serial number.
Kerry
Hi all
Seems my Sun X4170 labels have been wiped out or cleaned from the top cover and i need to retireve the Serial number of this particular server.
Is there any command in Solaris Unix that i can see or retrieve the serail of the server.
Much appreciated.
/opt/oracle.SupportTools/CheckHWnFWProfile -S
You’ll need to be root to run the command.
Technically, using the system_identifier is not the Rack Level serial number, tho most of the time it is the same. That field is openly modifiable and was only used for the X2 version of the Exadata since the proper field did not yet exist. The proper command is
> ipmitool sunoem cli ‘show /System/serial_number’
the following command shows the server serial number:
> ipmitool sunoem cli ‘show /System/component_serial_number’