It’s been a while since my last post!
Today, I wanted to share with you some useful commands to extract information from Exadata (product name, serial numbers, …).
This can be helpful for the opening of an new SR for example, or for inventorying components in a CMDB.
Here is the list of interesting elements that can be extracted (the list is not exhaustive, but these are the ones I use most often):
– Exadata product name
– Exadata rack serial number
– Compute nodes and cell nodes serial number
– Compute nodes and cell nodes internal component’s serial number
– Inifiniband switches serial number
– Cisco switch serial number
– PDU’s serial number
For some components, there are several methods for extracting the same information. I will give them all, so you can choose the one you prefer 🙂
Since the hardware layer of the ZDLRA is an Exadata, the commands also work on it.
(For confidentiality purposes, I’ve replaced some information with “*”.)
Unless specified otherwise, all commands must be run as root.
Product name
The command can be executed from any compute node or cell node.
[root@exanode1 ~]# dmidecode -s system-product-name ORACLE SERVER X7-2
The product name can also be retrieved by connecting to any compute node or cell node ilom web interface.
Rack serial number
The command can be executed from any compute node or cell node.
[root@exanode1 ~]# ipmitool sunoem cli "show /SP system_identifier" Connected. Use ^D to exit. -> show /SP system_identifier /SP Properties: system_identifier = Zero Data Loss Recovery Appliance X7 AK******** -> Session closed Disconnected
You can also use the following command. It will give you the Rack serial number and the serial number of the node (compude node or cell node) from which it was executed.
[root@exanode1~]# ipmitool sunoem cli 'show System' | grep -i Serial serial_number = AK******** <= Rack serial number rfid_serial_number = ************************ component_serial_number = ********** <= Node serial number
The rack serial number can also be retrieved by connecting to any compute node or cell node ilom web interface.
Compute nodes and cell nodes serial number
You can use the previous command, but there is also a command that retrieves only the serial number of the node.
It must be executed from the node for which you want to retrieve the serial number.
[root@exanode1 ~]# dmidecode -s system-serial-number **********
If you want to retrieve the serial number of all nodes in a single command, it is possible to use “dcli”.
[root@exanode1 ~]# dcli -g /root/all_group -l root "dmidecode -s system-serial-number" exanode1: ********** exanode2: ********** exacell01: ********** exacell02: ********** exacell03: ********** exacell04: ********** exacell05: ********** exacell06: **********
The serial number can also be retrieved by connecting to the compute node or cell node ilom web interface.
Compute nodes and cell nodes internal component’s serial numbers
Oracle provides a script named “CheckHWnFWProfile” which provides a large amount of information about the internal components of a node.
It’s not the most useful script because it gives a lot (too much?) of information, but it’s always useful to know it.
It must be executed from the node (compute node or cell node) for which you want to retrieve the serial information.
[root@exanode1 ~]# /opt/oracle.SupportTools/CheckHWnFWProfile -S
Inifiniband switches serial number
There are 2 ways to retrieve infiniband switch serial numbers: by connecting directly to the switch :
[root@exa-iba0 ~]# showfruinfo [...] Sun_FRU_LabelR: Sun_Serial_Number : ********** FRU_Part_Dash_Number : *******
(The proper serial number is the one shown below the line “Sun_FRU_LabelR”.)
Or from a compute node (replace “exa-iba0” with the name of your switch):
[root@exanode1 ~]# ipmitool -H exa-iba0 -U root sunoem cli "show /SYS product_serial_number" Password: [...] -> show /SYS product_serial_number /SYS Properties: product_serial_number = **********
Cisco switch serial number
For Cisco switch, you must connect directly to the switch with the “admin” account.
exa-adm0# show module Mod Ports Module-Type Model Status --- ----- ------------------------------------- --------------------- --------- 1 54 48x100/1G + 4x10G/25G + 2x40G/100G Et N9K-C9348GC-FXP active * Mod Sw Hw Slot --- ---------------- ------ ---- 1 7.0(3)I7(3) 1.0 NA Mod MAC-Address(es) Serial-Num --- -------------------------------------- ---------- 1 **-**-**-**-**-** to **-**-**-**-**-** *********** Mod Online Diag Status --- ------------------ 1 Pass * this terminal session
PDU’s serial number
For PDUs, there are also 2 ways to retrieve the serial number: from the command line, or by using the web interface.
Commande line
The command can be executed from any compute node or cell node.
The main problem with the command line method is that you only get the serial number, but not the PDU name.
First PDU:
[root@exanode1 ~]# ipmitool sunoem cli "show /System/Power/Power_Supplies/Power_Supply_0" Connected. Use ^D to exit. -> show /System/Power/Power_Supplies/Power_Supply_0 /System/Power/Power_Supplies/Power_Supply_0 Targets: Properties: health = OK health_details = - part_number = ******* serial_number = *******+********** manufacturer = DELTA ELECTRONICS (THAILAND) location = PS0 (Power Supply 0) input_power = Present output_power = 141 watts Commands: cd show -> Session closed Disconnected
Second PDU:
[root@exanode1 ~]# ipmitool sunoem cli "show /System/Power/Power_Supplies/Power_Supply_1"
Web interface
You can also connect to the web interface of the PDU throught your browser (https://pdu_hostname) and click on “Module Info” on the left pannel. You PDU serial number will be written here.
I hope you find this post useful. Stay tuned for more DBA stuff!
