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