trusted online casino malaysia

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:

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:

[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:


> /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"

6 Comments

  1. davidr says:

    Hi Kerry,

    In the Owner’s Guide of Exadata, serial number is get with the following command :

    ipmitool sunoem cli "show /SYS product_serial_number"
    Connected.Use ^ D to exit.
    >show /SYS product_serial_number
    /SYS
    Properties:
    product_serial_number =
    

    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.

    • dawei says:

      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

  2. osborne says:

    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

  3. Nuno Trocado says:

    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.

  4. osborne says:

    /opt/oracle.SupportTools/CheckHWnFWProfile -S

    You’ll need to be root to run the command.

  5. Anonymous says:

    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’

Leave a Reply