Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
Database Management Services, Oracle Database Appliance - ODA, Oracle Database Management Solution, Oracle Databases, Remote Database Management, Uncategorized

ODA is basically a 2-node RAC cluster database system running Oracle Linux operating (OEL), Oracle Database Enterprise Edition or Standard Edition, Oracle Grid Infrastructure (Clusterware and ASM). All these together provides the Oracle Database high availability running on ODA.

In 2016, Oracle added 3 new models to expand Oracle Database Appliance portfolio. These 3 new models are:
  • Oracle Database Appliance X6-2S (single-instance database)
  • Oracle Database Appliance X6-2M (single-instance database)
  • Oracle Database Appliance X6-2L (single-instance database)
The High Available ODA X6-2 is now known as X6-2 HA which consists of 2 nodes and a storage shelf and optionally an additional storage shelf.

In October 2017, Oracle announced Oracle Database Appliance X7-2 (Small, Medium and HA). ODA X7-2 comes with more computing resources compared with X6-2 Models.

  • Oracle Database Appliance X7-2S (single-instance database)
  • Oracle Database Appliance X7-2M (single-instance database)
  • Oracle Database Appliance X7-2 HA
With ODA X7-2, the ODA Large configuration is discontinued.
With the different model families there is always a confusion that which command line tool to be used for managing, monitoring and administrating Oracle Database Appliance.
In this article we will explain different command line tools that can be used to manage and administer an Oracle Database Appliance Small, Medium, Large and HA models for both Bare Metal and Virtualized Platform environment.
Let’s look at the different command line tools available:
OAKCLI: oakcli stands for Oracle Appliance Kit Command Line Interface. oakcli utility is used to manage Oracle Database Appliance. It used to carry out management tasks such as, Deploying, Patching, validating, monitoring, troubleshooting, Create Database, create database homes, configuring core key, manage Virtual machines and so on.

ODACLI: It is used for Hardware and administrative tasks on the Oracle Database Appliance, Example: Hardware monitoring and Storage Configuration

ODAADMICLI: It is used for everyday task on the Oracle Database Appliance, Example: Database Creation, Patches and upgrades, Job creation and manage and so on.

The following table provides a quick reference on when to use oakcli Vs. odacli/odaadmcli
  • For Oracle Database Appliance software version or older use the tools as shown in the following table
ODA X6-2 S, M, L
ODA X3-2
ODA X7-2 S, M
ODA X4-2
ODA X7-2 HA (Bare Metal only) 
ODA X5-2
ODA X7-2 HA (VM Only)

  • For Oracle Database Appliance software version and later user the tools as shown in the following table

All hardware versions running Virtualized platform
All hardware versions running Bare Metal (physical)

Examples using oakcli, odacli and odaadmcli:
[root@odanode1 ~]# odacli describe-appliance
Appliance Information
                     ID: 9aef262c-xxxx-xxxx-xxxx-0d877c03d762
               Platform: ODA
        Data Disk Count: 2
         CPU Core Count: 10
                Created: May 23, 2017 3:08:03 AM CST
System Information
                   Name: odanode
            Domain Name:
              Time Zone: Asia/Pacific
             DB Edition: EE
            DNS Servers:
            NTP Servers:
Disk Group Information
DG Name                   Redundancy                Percentage
————————- ————————- ————
Data                      Normal                    80
Reco                      Normal                    20
[root@odanode1 ~]# odaadmcli show disk
        NAME            PATH            TYPE            STATE           STATE_DETAILS
        pd_00           /dev/nvme0n1    NVD             ONLINE          Good
        pd_01           /dev/nvme1n1    NVD             ONLINE          Good
[root@odanode1 ~]# odaadmcli show diskgroup
[root@odanode1 ~]# odaadmcli show env_hw
BM ODA X6-2 Small
[root@odanode1 ~]# odaadmcli show storage
==== BEGIN STORAGE DUMP ========
Host Description: Oracle Corporation:ORACLE SERVER X6-2
Total number of controllers: 2
        Id          = 0
        Pci Slot    = 10
        Serial Num  = xxxxxxxxxx
        Vendor      = Samsung
        Model       = MS1PC2DD3ORA3.2T
        FwVers      = KPYABR3Q
        strId       = nvme:19:00.00
        Pci Address = 19:00.0
        Id          = 1
        Pci Slot    = 11
        Serial Num  = xxxxxxxxxxx
        Vendor      = Samsung
        Model       = MS1PC2DD3ORA3.2T
        FwVers      = KPYABR3Q
        strId       = nvme:1b:00.00
        Pci Address = 1b:00.0
Total number of expanders: 0
Total number of PDs: 2
        /dev/nvme0n1    Samsung           NVD 3200gb slot:  0  pci : 19
        /dev/nvme1n1    Samsung           NVD 3200gb slot:  1  pci : 1b
==== END STORAGE DUMP =========
[root@odanode1 ~]# oakcli show env_hw
Public interface : COPPER
[root@odanode1 ~]# oakcli show oda_base
ODA base domain
ODA base CPU cores :36
ODA base domain memory :362
ODA base template :/OVS/template.tar.gz
ODA base vlans :[‘priv1’, ‘net1’]
ODA base current status :Running
[root@odanode1 ~]# oakcli show env_hw
VM-oda_base ODA X7-2 HA

In this article we have learned about Oracle Database Appliance X6-2 and X7-2 model family. Also, we have learned when to use different ODA command lines tools such as oakcli, odacli and odaadmcli to manage and administer an Oracle Database Appliance.

eBook - Oracle Exadata X8M Patching Recipes | Netsoftmate