<<Back to Exadata Main Page
Listing Exadata storage cells and their configuration info
login to your Exadata Cell Server and execute below command
# imageinfo
Kernel version: 2.6.39-400.284.1.el6uek.x86_64 #1 SMP Mon Sep 12 19:26:25 PDT 20 16 x86_64
Cell version: OSS_12.1.2.3.3_LINUX.X64_161013
Cell rpm version: cell-12.1.2.3.3_LINUX.X64_161013-1.x86_64
Active image version: 12.1.2.3.3.161013
Active image kernel version: 2.6.39-400.284.1.el6uek
Active image activated: 2016-10-25 14:54:29 +0200
Active image status: success
Active system partition on device: /dev/md5
Active software partition on device: /dev/md7
Cell boot usb partition: /dev/sdm1
Cell boot usb version: 12.1.2.3.3.161013
Inactive image version: 12.1.2.3.2.160721
Inactive image activated: 2016-09-13 16:03:45 +0200
Inactive image status: success
Inactive system partition on device: /dev/md6
Inactive software partition on device: /dev/md8
Inactive marker for the rollback: /boot/I_am_hd_boot.inactive
Inactive grub config for the rollback: /boot/grub/grub.conf.inactive
Inactive kernel version for the rollback: 2.6.39-400.281.1.el6uek.x86_64
Rollback to the inactive partitions: Possible
You can query similar information from v$cell_config view as well
SQL>
SELECT
cellname cv_cellname
, CAST(extract(xmltype(confval), '/cli-output/cell/releaseVersion/text()') AS VARCHAR2(20)) cv_cellVersion
, CAST(extract(xmltype(confval), '/cli-output/cell/flashCacheMode/text()') AS VARCHAR2(20)) cv_flashcachemode
, CAST(extract(xmltype(confval), '/cli-output/cell/cpuCount/text()') AS VARCHAR2(10)) cpu_count
, CAST(extract(xmltype(confval), '/cli-output/cell/upTime/text()') AS VARCHAR2(20)) uptime
, CAST(extract(xmltype(confval), '/cli-output/cell/kernelVersion/text()') AS VARCHAR2(30)) kernel_version
, CAST(extract(xmltype(confval), '/cli-output/cell/makeModel/text()') AS VARCHAR2(50)) make_model
FROM
v$cell_config -- gv$ isn't needed, all cells should be visible in all instances
WHERE
conftype = 'CELL'
ORDER BY
cv_cellname;
# imageinfo
Kernel version: 2.6.39-400.284.1.el6uek.x86_64 #1 SMP Mon Sep 12 19:26:25 PDT 20 16 x86_64
Cell version: OSS_12.1.2.3.3_LINUX.X64_161013
Cell rpm version: cell-12.1.2.3.3_LINUX.X64_161013-1.x86_64
Active image version: 12.1.2.3.3.161013
Active image kernel version: 2.6.39-400.284.1.el6uek
Active image activated: 2016-10-25 14:54:29 +0200
Active image status: success
Active system partition on device: /dev/md5
Active software partition on device: /dev/md7
Cell boot usb partition: /dev/sdm1
Cell boot usb version: 12.1.2.3.3.161013
Inactive image version: 12.1.2.3.2.160721
Inactive image activated: 2016-09-13 16:03:45 +0200
Inactive image status: success
Inactive system partition on device: /dev/md6
Inactive software partition on device: /dev/md8
Inactive marker for the rollback: /boot/I_am_hd_boot.inactive
Inactive grub config for the rollback: /boot/grub/grub.conf.inactive
Inactive kernel version for the rollback: 2.6.39-400.281.1.el6uek.x86_64
Rollback to the inactive partitions: Possible
You can query similar information from v$cell_config view as well
SQL>
SELECT
cellname cv_cellname
, CAST(extract(xmltype(confval), '/cli-output/cell/releaseVersion/text()') AS VARCHAR2(20)) cv_cellVersion
, CAST(extract(xmltype(confval), '/cli-output/cell/flashCacheMode/text()') AS VARCHAR2(20)) cv_flashcachemode
, CAST(extract(xmltype(confval), '/cli-output/cell/cpuCount/text()') AS VARCHAR2(10)) cpu_count
, CAST(extract(xmltype(confval), '/cli-output/cell/upTime/text()') AS VARCHAR2(20)) uptime
, CAST(extract(xmltype(confval), '/cli-output/cell/kernelVersion/text()') AS VARCHAR2(30)) kernel_version
, CAST(extract(xmltype(confval), '/cli-output/cell/makeModel/text()') AS VARCHAR2(50)) make_model
FROM
v$cell_config -- gv$ isn't needed, all cells should be visible in all instances
WHERE
conftype = 'CELL'
ORDER BY
cv_cellname;
Listing Database Server Image and Version/PSU
login into your Exadata database Server and execute Imageinfo command. If you want to find some historic information execute imagehistory command
# imageinfo
Kernel version: 2.6.39-400.284.1.el6uek.x86_64 #1 SMP Mon Sep 12 19:26:25 PDT 2016 x86_64
Image kernel version: 2.6.39-400.284.1.el6uek
Image version: 12.1.2.3.3.161013
Image activated: 2016-10-26 11:58:58 +0200
Image status: success
System partition on device: /dev/mapper/VGExaDb-LVDbSys1
Kernel version: 2.6.39-400.284.1.el6uek.x86_64 #1 SMP Mon Sep 12 19:26:25 PDT 2016 x86_64
Image kernel version: 2.6.39-400.284.1.el6uek
Image version: 12.1.2.3.3.161013
Image activated: 2016-10-26 11:58:58 +0200
Image status: success
System partition on device: /dev/mapper/VGExaDb-LVDbSys1
# imagehistory
Version : 12.1.2.3.1.160411
Image activation date : 2016-07-12 18:23:54 +0200
Imaging mode : fresh
Imaging status : success
Version : 12.1.2.3.2.160721
Image activation date : 2016-09-29 09:02:40 +0200
Imaging mode : patch
Imaging status : success
Version : 12.1.2.3.3.161013
Image activation date : 2016-10-26 11:58:58 +0200
Imaging mode : patch
Imaging status : success
Image activation date : 2016-07-12 18:23:54 +0200
Imaging mode : fresh
Imaging status : success
Version : 12.1.2.3.2.160721
Image activation date : 2016-09-29 09:02:40 +0200
Imaging mode : patch
Imaging status : success
Version : 12.1.2.3.3.161013
Image activation date : 2016-10-26 11:58:58 +0200
Imaging mode : patch
Imaging status : success
To List the database Version and path detail execute opatch lsinventory from $ORACLE_HOME/OPatch location as oracle user
$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.7
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.7
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2017-10-05_11-13-19AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-10-05_11-13-19AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname:
ARU platform id: 226
ARU platform description:: Linux x86-64
Local Machine Information::
Hostname:
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are 1 products installed in this Oracle Home.
Interim patches (4) :
Patch 24315824 : applied on Thu Oct 27 13:31:52 CEST 2016
Unique Patch ID: 20676808
Patch description: "Database PSU 12.1.0.2.161018, Oracle JavaVM Component (OCT2016)"
Created on 21 Sep 2016, 07:44:21 hrs PST8PDT
Unique Patch ID: 20676808
Patch description: "Database PSU 12.1.0.2.161018, Oracle JavaVM Component (OCT2016)"
Created on 21 Sep 2016, 07:44:21 hrs PST8PDT
to provide better readability output is trimmed
Listing IB (Infiniband) Version info
Connect to Infiniband switch with ilom-operator or ilom-admin account, and runversion comman
Oracle(R) Integrated Lights Out Manager
Version ILOM 3.0 r47111
Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
->
-> version
SP firmware 2.1.8-1
SP firmware build number: 47111
SP firmware date: Thu Feb 19 12:16:50 IST 2015
SP filesystem version: 0.1.22
-> version
SP firmware 2.1.8-1
SP firmware build number: 47111
SP firmware date: Thu Feb 19 12:16:50 IST 2015
SP filesystem version: 0.1.22
Listing PDU (Power Distribution Unit) info
Connect to PDU and execute help PDU-SystemInfo command for help menu
pducli->help PDU-SystemInfo
Command 'get' with parameters:
get pdu_name => response xxxxx (with xxxxx is PDU Name)
get pdu_product_id => response xxxxx (with xxxxx is PDU Product-ID)
get pdu_rack_serial_number => response xxxxx (with xxxxx is PDU Rack-SerialNumber)
get pdu_location => response xxxxx (with xxxxx is PDU Location)
get pdu_part_number => response xxxxx (with xxxxx is PDU PartNumber)
get pdu_serial_number => response xxxxx (with xxxxx is PDU SerialNumber)
get pdu_date_of_manufacture => response xxxxx (with xxxxx is PDU Date-of-Manufacture)
get pdu_product_description => response xxxxx (with xxxxx is PDU Product-Description)
get pdu_hardware_version => response xxxxx (with xxxxx is PDU Hardware-Version)
get pdu_firmware_version => response xxxxx (with xxxxx is PDU Firmware-Version)
get pdu_bootloader_version => response xxxxx (with xxxxx is PDU Bootloader-Version)
get pdu_mac_address => response xxxxx (with xxxxx is PDU MAC-Address)
get pdu_display_info_time => response xx (with xx is seconds: 1-60 allowed)
get pdu_web_gui_refresh_interval => response xx (with xx is seconds: 1-60 allowed)
Command 'set' with parameters:
set pdu_name=xxxxx (with xxxxx is PDU Name)
set pdu_product_id=xxxxx (with xxxxx is PDU Product-ID)
set pdu_rack_serial_number=xxxxx (with xxxxx is PDU Rack-SerialNumber)
set pdu_location=xxxxx (with xxxxx is PDU Location)
set pdu_display_info_time=xx (with xx is seconds: 1-60 allowed)
set pdu_web_gui_refresh_interval=xx (with xx is seconds: 1-60 allowed)
pducli->get pdu_hardware_version
pducli->pdu_hardware_version=V2/C
pducli->get pdu_firmware_version
pducli->pdu_firmware_version=V2.04 - 27.05.2015
pducli->get pdu_bootloader_version
pducli->pdu_bootloader_version=V0.01 - 15.10.2013
pducli->help PDU-SystemInfo
Command 'get' with parameters:
get pdu_name => response xxxxx (with xxxxx is PDU Name)
get pdu_product_id => response xxxxx (with xxxxx is PDU Product-ID)
get pdu_rack_serial_number => response xxxxx (with xxxxx is PDU Rack-SerialNumber)
get pdu_location => response xxxxx (with xxxxx is PDU Location)
get pdu_part_number => response xxxxx (with xxxxx is PDU PartNumber)
get pdu_serial_number => response xxxxx (with xxxxx is PDU SerialNumber)
get pdu_date_of_manufacture => response xxxxx (with xxxxx is PDU Date-of-Manufacture)
get pdu_product_description => response xxxxx (with xxxxx is PDU Product-Description)
get pdu_hardware_version => response xxxxx (with xxxxx is PDU Hardware-Version)
get pdu_firmware_version => response xxxxx (with xxxxx is PDU Firmware-Version)
get pdu_bootloader_version => response xxxxx (with xxxxx is PDU Bootloader-Version)
get pdu_mac_address => response xxxxx (with xxxxx is PDU MAC-Address)
get pdu_display_info_time => response xx (with xx is seconds: 1-60 allowed)
get pdu_web_gui_refresh_interval => response xx (with xx is seconds: 1-60 allowed)
Command 'set' with parameters:
set pdu_name=xxxxx (with xxxxx is PDU Name)
set pdu_product_id=xxxxx (with xxxxx is PDU Product-ID)
set pdu_rack_serial_number=xxxxx (with xxxxx is PDU Rack-SerialNumber)
set pdu_location=xxxxx (with xxxxx is PDU Location)
set pdu_display_info_time=xx (with xx is seconds: 1-60 allowed)
set pdu_web_gui_refresh_interval=xx (with xx is seconds: 1-60 allowed)
pducli->get pdu_hardware_version
pducli->pdu_hardware_version=V2/C
pducli->get pdu_firmware_version
pducli->pdu_firmware_version=V2.04 - 27.05.2015
pducli->get pdu_bootloader_version
pducli->pdu_bootloader_version=V0.01 - 15.10.2013
Listing ILOM config info
Connect to ILOM server with root user and execute version command
Oracle(R) Integrated Lights Out Manager
Version 3.2.7.26.a r112579
Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
Warning: HTTPS certificate is set to factory default.
Hostname: xxxxxxx
-> version
SP firmware 3.2.7.26.a
SP firmware build number: 112579
SP firmware date: Wed Sep 28 14:24:25 CST 2016
SP filesystem version: 0.2.10
SP firmware 3.2.7.26.a
SP firmware build number: 112579
SP firmware date: Wed Sep 28 14:24:25 CST 2016
SP filesystem version: 0.2.10
Comments
Post a Comment