Step 3 - Review Appliance Configuration
Oracle Database Appliance Command Line Interface
The Oracle Database Appliance command line interfaces (odacli
, odaadmcli
) are tools that can also be used to install, configure, and interrogate the status of Oracle Database Appliance. ODACLI assists in the fast deployment, patching, and easy management of Oracle Database Appliance.
Review the following odaadmcli
commands that provide information about Oracle Database Appliance configuration.
The sample output displayed in the simulator may not match exactly with the sample output on an actual appliance. For more details, refer to the Oracle Database Appliance documentation library for the latest release.
Command: odaadmcli show server
Description: Displays the server/node status, including Oracle ILOM IP address, firmware version, power consumption, and other details. This is helpful for an at-a-glance view of basic server and node information.
$ sudo odaadmcli show server
Power State : On
Open Problems : 0
Model : ODA X7-2-HA
Type : Rack Mount
Part Number : ODA X7-2-HA
Serial Number : 1750XD0003
Primary OS : Not Available
ILOM Address : 10.145.203.81
ILOM MAC Address : 00:10:E0:DA:CD:66
Description : Oracle Database Appliance X7-2 High Availability 1750XD0003
Locator Light : Off
Actual Power Consumption : 302 watts
Ambient Temperature : 20.250 degree C
Open Problems Report : System is healthy
Command: odacli describe-system
Description: Displays Oracle Database Appliance deployment status.
$ sudo odacli describe-system
Appliance Information
----------------------------------------------------------------
ID: oda
Platform:
Data Disk Count: 9
CPU Core Count: 36
Created: July 19, 2021 8:25:14 PM GMT
System Information
----------------------------------------------------------------
Name: oda
Domain Name: example.com
Time Zone: GMT
DB Edition: EE
DNS Servers: 1.1.1.1
NTP Servers:
Disk Group Information
----------------------------------------------------------------
DG Name Redundancy Percentage
------------------------- ------------------------- ------------
Data Flex 80
Reco Flex 20
Redo High 100
Flash Flex 100
Command: odaadmcli show processor
Description: This command displays information about the CPUs running in the system.
$ sudo odaadmcli show processor
NAME HEALTH HEALTH_DETAILS PART_NO. LOCATION MODEL MAX_CLK_SPEED TOTAL_CORES ENABLED_CORES
CPU_0 OK - SR3AX P0 (CPU 0) Intel(R) Xeon(R) Gold 6140 CP 2.300 GHz 18 NA
CPU_1 OK - SR3AX P1 (CPU 1) Intel(R) Xeon(R) Gold 6140 CP 2.300 GHz 18 NA
Command: odaadmcli show memory
Description: This command displays information about the memory.
$ sudo odaadmcli show memory
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION MANUFACTURER MEMORY_SIZE CURR_CLK_SPEED ECC_Errors
DIMM_0 OK - 3A4K40BB2-CTD 00CE021743373400D8 P0/D0 Samsung 32 GB 2666 MHz 0
DIMM_11 OK - 3A4K40BB2-CTD 00CE02174337340065 P0/D1 Samsung 32 GB 2666 MHz 0
DIMM_12 OK - 3A4K40BB2-CTD 00CE0217433734000D P1/D0 Samsung 32 GB 2666 MHz 0
DIMM_14 OK - 3A4K40BB2-CTD 00CE02174237318364 P1/D2 Samsung 32 GB 2666 MHz 0
DIMM_16 OK - 3A4K40BB2-CTD 00CE0217423731A19A P1/D4 Samsung 32 GB 2666 MHz 0
DIMM_19 OK - 3A4K40BB2-CTD 00CE02174237318394 P1/D7 Samsung 32 GB 2666 MHz 0
DIMM_2 OK - 3A4K40BB2-CTD 00CE02174337340078 P0/D2 Samsung 32 GB 2666 MHz 0
DIMM_21 OK - 3A4K40BB2-CTD 00CE0217423731A195 P1/D9 Samsung 32 GB 2666 MHz 0
DIMM_23 OK - 3A4K40BB2-CTD 00CE02174237318365 P1/D1 Samsung 32 GB 2666 MHz 0
DIMM_4 OK - 3A4K40BB2-CTD 00CE0217433734007B P0/D4 Samsung 32 GB 2666 MHz 0
DIMM_7 OK - 3A4K40BB2-CTD 00CE02174337340013 P0/D7 Samsung 32 GB 2666 MHz 0
DIMM_9 OK - 3A4K40BB2-CTD 00CE02174337340101 P0/D9 Samsung 32 GB 2666 MHz 0
Command: odaadmcli show power
Description: This command displays information about the power details for the appliance.
$ sudo odaadmcli show power
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION INPUT_POWER OUTPUT_POWER INLET_TEMP EXHAUST_TEMP
Power_Supply_0 OK - 7333459 465824T+1647D30456 PS0 Present 135 watts 20 degrees C 42.500 degree C
Power_Supply_1 OK - 7333459 465824T+1647D30762 PS1 Present 146 watts 20 degrees C 51.500 degree C
Command: odaadmcli show cooling
Description: This command displays information about the cooling of the appliance.
$ sudo odaadmcli show cooling
NAME HEALTH HEALTH_DETAILS LOCATION FAN % FAN SPEED
Fan_0 OK - FM0 35 % 6900 RPM
Fan_1 OK - FM0 34 % 5900 RPM
Fan_10 OK - FM2 32 % 6200 RPM
Fan_11 OK - FM2 31 % 5500 RPM
Fan_12 OK - FM3 32 % 6300 RPM
Fan_13 OK - FM3 31 % 5500 RPM
Fan_14 OK - FM3 32 % 6300 RPM
Fan_15 OK - FM3 31 % 5500 RPM
Fan_2 OK - FM0 36 % 6800 RPM
Fan_3 OK - FM0 34 % 5900 RPM
Fan_4 OK - FM1 35 % 6800 RPM
Fan_5 OK - FM1 34 % 5900 RPM
Fan_6 OK - FM1 32 % 6300 RPM
Fan_7 OK - FM1 29 % 5100 RPM
Fan_8 OK - FM2 32 % 6300 RPM
Fan_9 OK - FM2 31 % 5500 RPM