Tuesday, August 7, 2018

Oracle Database Appliance X6-2-HA

Oracle Appliance Manager Command Line Interface (OAKCLI) is a command line interface (CLI) dedicated to Oracle Database Appliance.
The oakcli commands are the primary method for performing database and system administration on Oracle Database Appliance.
You can perform the following tasks with OAKCLI commands:
  • List the hardware components
  • Validate and diagnose the hardware components
  • Install and upgrade software
  • Apply software patches
  • Create and drop databases
  • Install and uninstall Oracle Homes
  • Deploy and manage virtual machines
  • Test Oracle Auto Service Request (Oracle ASR)
  • Enable CPU cores
oakcli utility is located under the direcoty /opt/oracle/oak/bin/oakcli
oakcli logs oakcli commands output under the directory /opt/oracle/oak/log/<hostname>/client/oakcli.log

  • Execute the oakcli -h command to list the different options available with oakcli:
[root@dm-oda0 ~]# oakcli -h
Usage: oakcli show – Shows disk, diskgroup, expander, controller, server, processor, memory, iraid, power, cooling, network,ib, enclosure, storage, fs, raidsyncstatus, version, dbhomes, dbstorage, databases, db_config_params, env_hw, ASR
oakcli configure – configures the Network or ASR or additional Net or IB2Fiber
oakcli update-cpucore – Enable specified number of cores
oakcli describe-cpucore – List enabled number of cores
oakcli expand – Expand storage
oakcli locate – Locates a disk
oakcli deploy – Deploys the Database Appliance
oakcli update – Updates the Database Appliance
oakcli validate – Validates the Database Appliance
oakcli manage – Manages the OAK repository, diagcollect etc.,
oakcli unpack – Unpack the given package to OAK repository
oakcli copy – Copies the deployment config file
oakcli upgrade – Upgrades database
oakcli stordiag – Run storage diagnostic tool on both Nodes
oakcli reconfigure- Reconfigures kernel params
oakcli test – Test ASR
oakcli orachk – Performs configuration settings check on ODA
oakcli create – Creates Database, DB storage, snapshotdb, dbhome, db_config_params file
oakcli delete – Deletes Database, DB storage, dbhome, db_config_params file
oakcli modify – Performs modify operations on Database
oakcli resize – Resizes DB storage

  • Execute the following command to list all the options that can be used with oakcli show
[root@dm-oda0 ~]# oakcli show -h
Usage:
oakcli show {disk|diskgroup|expander|fs|raidsyncstatus|controller|server|processor|memory|iraid|power|cooling|network|ib|enclosure|storage|core_config_key|version|dbhomes|dbstorage|databases|db_config_params|asr|env_hw} [<options>]
where:
disk – About the disk
diskgroup – ASM disk group
expander – Expander
fs – Filesystem
controller – Controller
storage – All storage components
version – Running software version
dbhomes – Installed oracle database homes
dbstorage – Details of ACFS storage setup for the databases
databases – Database names
db_config_params – db_config_params file
asr – ASR configuration
env_hw – Environment and Hardware information
server – Details of server sub-system
processor – Details of processor sub-system
memory – Details of memory sub-system
iraid – Details of internal RAIDs sub-system
power – Details of power supply sub-system
cooling – Details of cooling sub-system
network – Details of network sub-system
ib – Details of infiniband sub-system
enclosure – Details of enclosure sub-system
raidsyncstatus – RAID sync status information
For detailed help on each command and object and its options use:
oakcli <command> <object> -h
  • To check if whether ODA deployment is Bare Metal or Virtualized
[root@dm-oda0 ~]# oakcli show env_hw
BM ODA X6-2 HA
Public interface : COPPER
  • To get the ODA software and component version
[root@dm-oda0 ~]# oakcli show version
Version
——-
12.1.2.12.0
[root@dm-oda0 ~]# oakcli show version -detail
Reading the metadata. It takes a while…
System Version Component Name Installed Version Supported Version
————– ————— —————— —————–
12.1.2.12.0
Controller_INT 4.650.00-7176 Up-to-date
Controller_EXT 13.00.00.00 Up-to-date
Expander 0304 0291
SSD_SHARED {
[ c2d20,c2d21,c2d22, A29A Up-to-date
c2d23,c2d44,c2d45,c2
d46,c2d47 ]
[ c2d0,c2d1,c2d2,c2d A29A Up-to-date
3,c2d4,c2d5,c2d6,c2d
7,c2d8,c2d9,c2d10,c2
d11,c2d12,c2d13,c2d1
4,c2d15,c2d16,c2d17,
c2d18,c2d19,c2d24,c2
d25,c2d26,c2d27,c2d2
8,c2d29,c2d30,c2d31,
c2d32,c2d33,c2d34,c2
d35,c2d36,c2d37,c2d3
8,c2d39,c2d40,c2d41,
c2d42,c2d43 ]
}
SSD_LOCAL 0R3Q Up-to-date
ILOM 3.2.9.23 r116695 Up-to-date
BIOS 38070200 Up-to-date
IPMI 1.8.12.4 Up-to-date
HMP 2.3.5.2.8 Up-to-date
OAK 12.1.2.12.0 Up-to-date
OL 6.8 Up-to-date
GI_HOME 12.1.0.2.170814(2660 Up-to-date
9783,26609945)
DB_HOME {
[ OraDb12102_home1 ] 12.1.0.2.170814(2660 Up-to-date
9783,26609945)
[ OraDb11204_home1 ] 11.2.0.4.170814(2660 Up-to-date
9445,26609929)
}
  • To list shared or local or all
oakcli show disk [-shared | -local | <shared_diskname> [-all]]
[root@dm-oda0 ~]# oakcli show disk -shared
NAME PATH TYPE STATE STATE_DETAILS
e0_pd_00 /dev/sdaw SSD ONLINE Good
e0_pd_01 /dev/sdax SSD ONLINE Good
e0_pd_02 /dev/sdaa SSD ONLINE Good
e0_pd_03 /dev/sdab SSD ONLINE Good
e0_pd_04 /dev/sdac SSD ONLINE Good
e0_pd_05 /dev/sdad SSD ONLINE Good
e0_pd_06 /dev/sdae SSD ONLINE Good
e0_pd_07 /dev/sdaf SSD ONLINE Good
e0_pd_08 /dev/sdag SSD ONLINE Good
e0_pd_09 /dev/sdah SSD ONLINE Good
e0_pd_10 /dev/sdai SSD ONLINE Good
e0_pd_11 /dev/sdaj SSD ONLINE Good
e0_pd_12 /dev/sdak SSD ONLINE Good
e0_pd_13 /dev/sdal SSD ONLINE Good
e0_pd_14 /dev/sdam SSD ONLINE Good
e0_pd_15 /dev/sdan SSD ONLINE Good
e0_pd_16 /dev/sdao SSD ONLINE Good
e0_pd_17 /dev/sdap SSD ONLINE Good
e0_pd_18 /dev/sdaq SSD ONLINE Good
e0_pd_19 /dev/sdar SSD ONLINE Good
e0_pd_20 /dev/sdas SSD ONLINE Good
e0_pd_21 /dev/sdat SSD ONLINE Good
e0_pd_22 /dev/sdau SSD ONLINE Good
e0_pd_23 /dev/sdav SSD ONLINE Good
e1_pd_00 /dev/sda SSD ONLINE Good
e1_pd_01 /dev/sdb SSD ONLINE Good
e1_pd_02 /dev/sdbw SSD ONLINE Good
e1_pd_03 /dev/sdbx SSD ONLINE Good
e1_pd_04 /dev/sdby SSD ONLINE Good
e1_pd_05 /dev/sdbz SSD ONLINE Good
e1_pd_06 /dev/sdca SSD ONLINE Good
e1_pd_07 /dev/sdcb SSD ONLINE Good
e1_pd_08 /dev/sdcc SSD ONLINE Good
e1_pd_09 /dev/sdcd SSD ONLINE Good
e1_pd_10 /dev/sdce SSD ONLINE Good
e1_pd_11 /dev/sdcf SSD ONLINE Good
e1_pd_12 /dev/sdcg SSD ONLINE Good
e1_pd_13 /dev/sdch SSD ONLINE Good
e1_pd_14 /dev/sdci SSD ONLINE Good
e1_pd_15 /dev/sdcj SSD ONLINE Good
e1_pd_16 /dev/sdck SSD ONLINE Good
e1_pd_17 /dev/sdcl SSD ONLINE Good
e1_pd_18 /dev/sdcm SSD ONLINE Good
e1_pd_19 /dev/sdcn SSD ONLINE Good
e1_pd_20 /dev/sdco SSD ONLINE Good
e1_pd_21 /dev/sdcp SSD ONLINE Good
e1_pd_22 /dev/sdcq SSD ONLINE Good
e1_pd_23 /dev/sdcr SSD ONLINE Good
——————————————————————————————————————
  • To Show ASM disk groups on ODA
[root@dm-oda0 ~]# oakcli show diskgroup
DiskGroups
———-
DATA
RECO
REDO
  • To list the ACFS  file system and local file system on ODA
[root@dm-oda0 ~]# oakcli show fs
Type Total Space Free Space Total DG Space Free DG Space Diskgroup Mount Point
ext3 30109M 13019M – – /
ext3 476M 405M – – /boot
ext3 60347M 34614M – – /opt
ext3 100665M 46483M – – /u01
acfs 4790272M 3149760M 39321600M 27629144M DATA /u02/app/oracle/oradata/datastore
acfs 524288M 370638M 39321600M 27629144M DATA /u03
acfs 524288M 366273M 39321600M 27629144M DATA /u04
acfs 524288M 286277M 6461440M 5411940M RECO /u01/app/oracle/fast_recovery_area/datastore
acfs 187392M 96454M 1525760M 963032M REDO /u01/app/oracle/oradata/datastore
  • To get ODA Storage Shelve details
    Note: This ODA has 2 storage shelves with 40 disks.
[root@dm-oda0 u04]# oakcli show storage
==== BEGIN STORAGE DUMP ========
Host Description: Oracle Corporation:ORACLE SERVER X6-2
Total number of controllers: 3
Id = 1
Serial Num = 500605b00c36f9f0
Vendor = LSI Logic
Model = ORCL-EXT-SAS3
FwVers = 13.00.00.00
strId = mpt3sas:03:00.0
Id = 2
Serial Num = 500605b00c36f260
Vendor = LSI Logic
Model = ORCL-EXT-SAS3
FwVers = 13.00.00.00
strId = mpt3sas:13:00.0
Id = 0
Serial Num = SK70770944
Vendor = LSI Logic
Model = LSI MegaRAID 9361-8i
FwVers = 4.650.00-7176
strId = mptmega:23:00.0
Total number of expanders: 4
Id = 1
Serial Num = 5080020001d7ec2c
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Secondary
WWN = 50800200021b6a3e
Id = 3
Serial Num = 5080020001d7ec2c
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Primary
WWN = 50800200021b75fe
Id = 0
Serial Num = 50800200021ce892
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Primary
WWN = 50800200021b87be
Id = 2
Serial Num = 50800200021ce892
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Secondary
WWN = 50800200021bc83e
Total number of PDs: 48
/dev/sdaw HGST SSD 1600gb slot: 0 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdax HGST SSD 1600gb slot: 1 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaa HGST SSD 1600gb slot: 2 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdab HGST SSD 1600gb slot: 3 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdac HGST SSD 1600gb slot: 4 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdad HGST SSD 1600gb slot: 5 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdae HGST SSD 1600gb slot: 6 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaf HGST SSD 1600gb slot: 7 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdag HGST SSD 1600gb slot: 8 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdah HGST SSD 1600gb slot: 9 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdai HGST SSD 1600gb slot: 10 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaj HGST SSD 1600gb slot: 11 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdak HGST SSD 1600gb slot: 12 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdal HGST SSD 1600gb slot: 13 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdam HGST SSD 1600gb slot: 14 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdan HGST SSD 1600gb slot: 15 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdao HGST SSD 1600gb slot: 16 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdap HGST SSD 1600gb slot: 17 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaq HGST SSD 1600gb slot: 18 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdar HGST SSD 1600gb slot: 19 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdas HGST SSD 200gb slot: 20 exp: 0 HSCAC2DA6SUN200G
/dev/sdat HGST SSD 200gb slot: 21 exp: 0 HSCAC2DA6SUN200G
/dev/sdau HGST SSD 200gb slot: 22 exp: 0 HSCAC2DA6SUN200G
/dev/sdav HGST SSD 200gb slot: 23 exp: 0 HSCAC2DA6SUN200G
/dev/sda HGST SSD 1600gb slot: 24 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdb HGST SSD 1600gb slot: 25 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdbw HGST SSD 1600gb slot: 26 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdbx HGST SSD 1600gb slot: 27 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdby HGST SSD 1600gb slot: 28 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdbz HGST SSD 1600gb slot: 29 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdca HGST SSD 1600gb slot: 30 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcb HGST SSD 1600gb slot: 31 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcc HGST SSD 1600gb slot: 32 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcd HGST SSD 1600gb slot: 33 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdce HGST SSD 1600gb slot: 34 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcf HGST SSD 1600gb slot: 35 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcg HGST SSD 1600gb slot: 36 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdch HGST SSD 1600gb slot: 37 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdci HGST SSD 1600gb slot: 38 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcj HGST SSD 1600gb slot: 39 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdck HGST SSD 1600gb slot: 40 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcl HGST SSD 1600gb slot: 41 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcm HGST SSD 1600gb slot: 42 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcn HGST SSD 1600gb slot: 43 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdco HGST SSD 200gb slot: 44 exp: 3 HSCAC2DA6SUN200G
/dev/sdcp HGST SSD 200gb slot: 45 exp: 3 HSCAC2DA6SUN200G
/dev/sdcq HGST SSD 200gb slot: 46 exp: 3 HSCAC2DA6SUN200G
/dev/sdcr HGST SSD 200gb slot: 47 exp: 3 HSCAC2DA6SUN200G
==== END STORAGE DUMP =========
  • To list database storage on ODA
[root@dm-oda0 u04]# oakcli show dbstorage
All the DBs with DB TYPE as non-CDB share the same volumes
DB_NAMES DB_TYPE Filesystem Size Used Available AutoExtend Size DiskGroup
——- ——- ———— —— —– ——— —————- ——–
cfcdev, cfctest1, non-CDB /u01/app/oracle/oradata/datastore 183G 88.81G 94.19G 9G REDO
cfctest2, DEV01DW,
DEV02, DEV03, DWP
RD,  TEST1,
TEST1DW, TEST2
/u02/app/oracle/oradata/datastore 4678G 1602.06G 3075.94G 467G DATA
/u01/app/oracle/fast_recovery_area/datastore 512G 232.43G 279.57G 51G RECO
To show dbhomes
[root@dm-oda0 u04]# oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location
—————- ——————- ————
OraDb11204_home1 11.2.0.4.170814(26609445,26609929) /u01/app/oracle/product/11.2.0.4/dbhome_1
OraDb12102_home1 12.1.0.2.170814(26609783,26609945) /u01/app/oracle/product/12.1.0.2/dbhome_1
To list database on ODA
[root@dm-oda0 u04]# oakcli show databases
Name Type Storage HomeName HomeLocation Version
—– —— ——– ————– —————- ———-
cfcdev RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
TEST1 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
TEST2 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
TEST1DW RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DEV01DW RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
cfctest2 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DWPRD RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
cfctest1 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DEV02 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DEV03 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
  • To check the ODA servers and hardware status
[root@dm-oda0 ~]# oakcli show server
Power State : On
Open Problems : 0
Model : ODA X6-2-HA
Type : Rack Mount
Part Number : ODA X6-2-HA
Serial Number : 1722NM100L
Primary OS : Not Available
ILOM Address : 10.253.99.52
ILOM MAC Address : 00:10:E0:CC:19:EE
Description : Oracle Database Appliance X6-2 High Availability 1727NM0005
Locator Light : Off
Actual Power Consumption : 198 watts
Ambient Temperature : 27.750 degree C
Open Problems Report : System is healthy
[root@dm-oda0 ~]# oakcli show processor
NAME HEALTH HEALTH_DETAILS PART_NO. LOCATION MODEL MAX_CLK_SPEED TOTAL_CORES ENABLED_CORES
CPU_0 OK – 060F P0 (CPU 0) Intel(R) Xeon(R) CPU E5-2630 2.200 GHz 10 NA
CPU_1 OK – 060F P1 (CPU 1) Intel(R) Xeon(R) CPU E5-2630 2.200 GHz 10 NA
[root@dm-oda0 ~]# oakcli show memory
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION MANUFACTURER MEMORY_SIZE CURR_CLK_SPEED ECC_Errors
DIMM_0 OK – 3A4K40BB1-CRC 00CE031721195F2472 P0/D0 Samsung 32 GB 2400 MHz 0
DIMM_11 OK – 3A4K40BB1-CRC 00CE031721195F2471 P0/D1 Samsung 32 GB 2400 MHz 0
DIMM_12 OK – 3A4K40BB1-CRC 00CE031721195F243C P1/D0 Samsung 32 GB 2400 MHz 0
DIMM_15 OK – 3A4K40BB1-CRC 00CE031721195F2E7C P1/D3 Samsung 32 GB 2400 MHz 0
DIMM_20 OK – 3A4K40BB1-CRC 00CE031721195F2E7B P1/D8 Samsung 32 GB 2400 MHz 0
DIMM_23 OK – 3A4K40BB1-CRC 00CE031721195F1B55 P1/D1 Samsung 32 GB 2400 MHz 0
DIMM_3 OK – 3A4K40BB1-CRC 00CE031721195F1F34 P0/D3 Samsung 32 GB 2400 MHz 0
DIMM_8 OK – 3A4K40BB1-CRC 00CE031721195F236B P0/D8 Samsung 32 GB 2400 MHz 0
[root@dm-oda0 ~]# oakcli show iraid
NAME CTRL# PRODUCT SERIAL_NO BIOS_VER FW_VER VDISK_TYPE VDISK_STATE PDISK_MODEL EID:SLT PDISK_STATE SIZE CV_MODEL CV_STATE CV_TEMP
IR_0_0_0 0 LSI MegaRAID 9361-8i SK70770944 6.31.03.1_4.19.08.00_0x061402 4.650.00-7176 RAID1 Optl MS4SC2JH2ORA480G 252:0 Onln 446.102 GB CVPM02 Optimal 26C
IR_0_0_1 0 LSI MegaRAID 9361-8i SK70770944 6.31.03.1_4.19.08.00_0x061402 4.650.00-7176 RAID1 Optl MS4SC2JH2ORA480G 252:1 Onln 446.102 GB CVPM02 Optimal 25C
[root@dm-oda0 ~]# oakcli show power
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION INPUT_POWER OUTPUT_POWER INLET_TEMP EXHAUST_TEMP
Power_Supply_0 OK – 7079395 476856Z+1652CE02CH PS0 Present 87 watts 30.000 degree C 35.938 degree C
Power_Supply_1 OK – 7079395 476856Z+1652CE02E8 PS1 Present 84 watts 30.000 degree C 36.875 degree C
[root@dm-oda0 ~]# oakcli show cooling
NAME HEALTH HEALTH_DETAILS LOCATION FAN % FAN SPEED
Fan_0 OK – FM0 29 % 5600 RPM
Fan_1 OK – FM0 17 % 3000 RPM
Fan_10 OK – FM2 31 % 6100 RPM
Fan_11 OK – FM2 21 % 3700 RPM
Fan_12 OK – FM3 33 % 6400 RPM
Fan_13 OK – FM3 21 % 3700 RPM
Fan_14 OK – FM3 24 % 4700 RPM
Fan_15 OK – FM3 15 % 2600 RPM
Fan_2 OK – FM0 33 % 6400 RPM
Fan_3 OK – FM0 20 % 3600 RPM
Fan_4 OK – FM1 32 % 6300 RPM
Fan_5 OK – FM1 22 % 3800 RPM
Fan_6 OK – FM1 33 % 6400 RPM
Fan_7 OK – FM1 22 % 3800 RPM
Fan_8 OK – FM2 31 % 6100 RPM
Fan_9 OK – FM2 21 % 3700 RPM
  • To check network status on ODA
[root@dm-oda0 ~]# oakcli show network
NAME HEALTH HEALTH_DETAILS LOCATION PART_NO MANUFACTURER MAC_ADDRESS LINK_DETECTED DIE_TEMP
Ethernet_NIC_0 OK – NET0 X540 INTEL 00:10:E0:CC:19:EA yes (eth0) 54.250 degree C
Ethernet_NIC_1 OK – NET1 X540 INTEL 00:10:E0:CC:19:EB yes (eth1) 54.250 degree C
Ethernet_NIC_2 OK – NET2 X540 INTEL 00:10:E0:CC:19:EC yes (eth2) 56.000 degree C
Ethernet_NIC_3 OK – NET3 X540 INTEL 00:10:E0:CC:19:ED no (eth3) 56.250 degree C
[root@dm-oda0 ~]# oakcli show ib
NAME MANUFACTURER MODEL DEVICE# CA_TYPE PORT# STATE LINK_STATUS RATE PORT_GUID NODE_GUID SYS_IMAGE_GUID
IB_mlx4_0_1 Mellanox Techn MT27500 mlx4_0 MT4099 1 Active LinkUp 40 (FD 0x0010e00001c88251 0x0010e00001c88250 0x0010e00001c88253
IB_mlx4_0_2 Mellanox Techn MT27500 mlx4_0 MT4099 2 Active LinkUp 40 (FD 0x0010e00001c88252 0x0010e00001c88250 0x0010e00001c88253
To check ODA servers enclosure
[root@dm-oda0 ~]# oakcli show enclosure
NAME SUBSYSTEM STATUS METRIC
E0_FAN0 Cooling OK 4930 rpm
E0_FAN1 Cooling OK 4550 rpm
E0_FAN2 Cooling OK 4910 rpm
E0_FAN3 Cooling OK 4500 rpm
E0_IOM0 Encl_Electronics OK –
E0_IOM1 Encl_Electronics OK –
E0_PSU0 Power_Supply OK –
E0_PSU1 Power_Supply OK –
E0_TEMP0 Amb_Temp OK 20 C
E0_TEMP1 Midplane_Temp OK 20 C
E0_TEMP2 PCM0_Inlet_Temp OK 25 C
E0_TEMP3 PCM0_Hotspot_Temp OK 21 C
E0_TEMP4 PCM1_Inlet_Temp OK 44 C
E0_TEMP5 PCM1_Hotspot_Temp OK 32 C
E0_TEMP6 IOM0_Temp OK 17 C
E0_TEMP7 IOM1_Temp OK 26 C
E1_FAN0 Cooling OK 4910 rpm
E1_FAN1 Cooling OK 4520 rpm
E1_FAN2 Cooling OK 4910 rpm
E1_FAN3 Cooling OK 4530 rpm
E1_IOM0 Encl_Electronics OK –
E1_IOM1 Encl_Electronics OK –
E1_PSU0 Power_Supply OK –
E1_PSU1 Power_Supply OK –
E1_TEMP0 Amb_Temp OK 22 C
E1_TEMP1 Midplane_Temp OK 20 C
E1_TEMP2 PCM0_Inlet_Temp OK 24 C
E1_TEMP3 PCM0_Hotspot_Temp OK 22 C
E1_TEMP4 PCM1_Inlet_Temp OK 44 C
E1_TEMP5 PCM1_Hotspot_Temp OK 34 C
E1_TEMP6 IOM0_Temp OK 17 C
E1_TEMP7 IOM1_Temp OK 28 C

Other oakcli commands
  • To configure fistnet on ODA
[root@dm-oda0 ~]#oakcli configure firstnet
  • To deploy ODA
[root@dm-oda0 ~]# oakcli deploy
  • To unpack sofware on ODA
[root@odanode1 ~]#oakcli unpack -package p12978712_1212120_Linux-x86-64_1of2.zip
Unpacking will take some time , Please wait…
Successfully unpacked the files to repository.
  • To create Database on ODA
[root@odanode1 ~]# oakcli create database -db demo -oh OraDb11204_home1
  • To validate cabling on ODA
[root@dm-oda0 ~]# oakcli validate -c storagetopology
  • To update/patch ODA server
[root@dm-oda0 ~]# oakcli update -patch 12.1.2.12.0 –server -local
  • To update/patch ODA storage
[root@dm-oda0 ~]# oakcli update -patch 12.1.2.12.0 –storage

No comments:

Post a Comment