Monday 8 January 2018

Oracle Database Appliance Odacli & Odaadmcli Utilities

Oracle Database Appliance consists of two physical servers (Node 0 and Node 1), a storage shelf and optionally an additional storage shelf. The two independent physical servers are interconnected and direct attached to SAS and SSD storage.

ODA is basically a 2-node RAC cluster database system running Oracle Linux operating (OEL), Oracle Database Enterprise 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.

Courtesy Oracle

The Oracle Database Appliance X6-2 model family offers the lowest hardware price for an Oracle Engineered System. Combined with flexible Oracle Database software licensing, the Oracle Database Appliance X6-2 model family brings Oracle Engineered Systems to within reach of every organization.


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
Courtesy Oracle

Note: With ODA x7-2, looks like the ODA Large configuration is discontinued.

In this article we will demonstrate several different odacli and odaadmcli commands along with output that can be used to manage and administer an Oracle Database Appliance Small, Medium and Large models.


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


ODACLI Commands

  • To display list of commands and options that can be used with odacli  execute the following command
[root@odanode1 ~]# odacli -h
odacli <command> <options>
Commands list (use --help option for help on any command):
        appliance:
                create-appliance
                describe-appliance
        asr:
                configure-asr
                delete-asr
                describe-asr
                test-asr
                update-asr
        component:
                describe-component
        cpucore:
                describe-cpucore
                list-cpucores
                update-cpucore
        credential:
                set-credential
        database:
                create-database
                delete-database
                describe-database
                list-databases
                register-database
        dbhome:
                create-dbhome
                delete-dbhome
                describe-dbhome
                list-dbhomes
                update-dbhome
        dbstorage:
                create-dbstorage
                delete-dbstorage
                describe-dbstorage
                list-dbstorages
        dcsagent:
                update-dcsagent
        job:
                describe-job
                list-jobs
        latestpatch:
                describe-latestpatch
        network:
                create-network
                delete-network
                describe-network
                list-networks
                update-network
        networkinterface:
                describe-networkinterface
                list-networkinterfaces
        repository:
                update-repository
        server:
                update-server
     
  • To describe ODA execute the following command
[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: netsoftmate.com
              Time Zone: Asia/Pacific
             DB Edition: EE
            DNS Servers: 10.1.1.1
            NTP Servers: ntp1.netsoftmate.com

Disk Group Information

----------------------------------------------------------------
DG Name                   Redundancy                Percentage
------------------------- ------------------------- ------------
Data                      Normal                    80
Reco                      Normal                    20


 Options:

    --details, -d
       Detail Info

  • To describe ODA in details execute the following command
[root@odanode1 ~]# odacli describe-appliance -d

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: netsoftmate.com
              Time Zone: Asia/Pacific
             DB Edition: EE
            DNS Servers: 10.1.1.1
            NTP Servers: ntp1.netsoftmate.com

Disk Group Information

----------------------------------------------------------------
DG Name                   Redundancy                Percentage
------------------------- ------------------------- ------------
Data                      Normal                    80
Reco                      Normal                    20

DcsCli Details

----------------------------------------------------------------
                Version: 12.1.2.10-SNAPSHOT
            BuildNumber: jenkins-ol-dcs-cli-release-13
              GitNumber: f91373b8574e383e033301d82b8424115350d065
              BuildTime: null

DcsAgent Details

----------------------------------------------------------------
                Version: 12.1.2.10-SNAPSHOT
            BuildNumber: jenkins-ol-dcs-agent-release-31
              GitNumber: fb8b1776013457d4d80d7acac3ad96fa5ca52327
              BuildTime: null

  • To list ASR details execute the following command
[root@odanode1 ~]# odacli describe-asr

ASR details

----------------------------------------------------------------
                     ID: b8606dd5-99b4-xxxx-aabd-be8cd422754c
                   Name: ASR
               ASR Type: Internal
External ASR Manager IP :
               UserName: john.smith@example.com
        ProxyServerName: www-proxy.example.com
              ProxyPort: 80
          ProxyUserName:
            SnmpVersion: V3
                  State: Configured
                Created: May 23, 2017 3:08:03 AM CST
                Updated: May 23, 2017 3:42:43 AM CST

Options :

--json, -j
  json output

  • To list CPU Cores execute the following command
[root@odanode1 ~]# odacli list-cpucores

Node  Cores  Modified                       Job Status

----- ------ ------------------------------ ---------------
0     10     May 23, 2017 10:58:52 AM CST   Configured

  Options:
    --json, -j

       json output

  • To list all the job configured and to check their status execute the following command
[root@odanode1 ~]# odacli list-jobs

ID                                       Description                                                                 Created                             Status

---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
65b60824-cb18-4fec-bdec-baf7e440efc9     Provisioning service creation                                               May 23, 2017 3:08:03 AM CST         Success
74d38c8e-98aa-4ff3-9b04-ef96bdfd35bd     Database service deletion with db name: demodb1 with id : c0cdc82d-02e5-4980-9952-36b6d4adf28a May 23, 2017 4:01:02 PM CST         Success
26de75bb-e525-4356-9828-6056d55b5f56     Database Home OraDB12102_home1 Deletion with id 8f5944b1-e953-4c78-89f4-ba4daa8110ca May 23, 2017 4:04:59 PM CST         Success

  Options:

    --json, -j

       json output
         
  • To list the patches for all the ODA components execute the following command
[root@odanode1 ~]# odacli describe-latestpatch

componentType   availableVersion

--------------- --------------------
gi              12.1.0.2.170117
db              11.2.0.4.161018
db              12.1.0.2.170117
oak             12.1.2.10.0
ilom            3.2.8.24.r114611
os              6.8
bios            38070000

Options :
    --json, -j
       json output

  • To list all the network details execute the following command
[root@odanode1 ~]# odacli list-networks

ID                                       Name                 NIC        IP Address         Subnet Mask        Gateway

---------------------------------------- -------------------- ---------- ------------------ ------------------ ------------------
49976a55-4e1a-440a-94c3-289b69d9afcc     Private-network      priv0      192.168.16.24      255.255.255.240
219953e6-3473-46f9-b21b-53e89bc8cf49     Public-network       btbond1.198 10.10.10.18      255.255.255.0      10.1.1.2

  • To list all the network interfaces execute the following command
[root@odanode1 ~]# odacli list-networkinterfaces

ID                                       Name                 NIC           Type

---------------------------------------- -------------------- ------------- ----------
724e42a6-c9f7-xxxx-9e34-7b0952f8e3e1     btbond1              btbond1       Bond
543aba2a-0cb0-xxxx-b23a-3f035aa401c0     btbond1.198          btbond1.198   Bond
18933aa5-b02d-xxxx-a31b-5ad988d6396b     em1                  em1           Physical
ce059f61-7529-xxxx-9cd4-ef94fdd3ec54     em2                  em2           Physical
2622ea10-508a-xxxx-86a8-351fe0a58e6f     p3p1                 p3p1          Physical
8ddd6b36-ff32-xxxx-9d1f-a90c14216bf7     p3p2                 p3p2          Physical
f03a424e-8c7e-xxxx-901f-3b81f9642cfa     sfpbond1             sfpbond1      Bond



ODAADMCLI Commands

  • To display list of commands and options that can be used with odaadmcli execute the following command
[root@odanode1 ~]# odaadmcli -h
Usage:  odaadmcli <command> <object> [<options>]
        commands: show|manage|stordiag|power|expand
        objects : disk|diskgroup|controller|server|processor|memory|iraid|power|cooling|network|storage|fs|raidsyncstatus|env_hw

Usage:  odaadmcli show       - Shows disk, diskgroup, controller, server, processor, memory, iraid, power, cooling, network, storage, fs, raidsyncstatus, env_hw

        odaadmcli manage     - Manages the OAK repository, diagcollect etc.,
        odaadmcli stordiag   - Run storage diagnostic tool on this Node
        odaadmcli power      - Power on|off|status disk
        odaadmcli expand     - Expand storage

  • To display list of commands and options that can be used with odaadmcli show execute the following command
[root@odanode1 ~]# odaadmcli show -h
Usage:
odaadmcli show {disk|diskgroup|fs|raidsyncstatus|controller|storage|env_hw|server|processor|memory|iraid|power|cooling|network} [<options>]
where:
        disk                     - About the disk
        diskgroup                - ASM disk group
        fs                       - Filesystem
        controller               - Controller
        storage                  - All storage components
        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
        raidsyncstatus           - RAID sync status information
For detailed help on each command and object and its options use:
odaadmcli <command> <object> -h

  • To list local disk on compute node execute the following command
[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

  • To list all shared disk execute the following command
[root@odanode1 ~]# odaadmcli show disk -shared
        NAME            PATH            TYPE            STATE           STATE_DETAILS

        pd_00           /dev/nvme0n1    NVD             ONLINE          Good

        pd_01           /dev/nvme1n1    NVD             ONLINE          Good

  • To list ASM Disk Groups execute the following command 
[root@odanode1 ~]# odaadmcli show diskgroup
DiskGroups
----------
DATA
RECO

  • To list details of an ASM Disk Group execute the following command
[root@odanode1 ~]# odaadmcli show diskgroup DATA
        ASM_DISK        PATH                                            DISK            STATE           STATE_DETAILS

        data_00         /dev/NVD_S00_S2LHNA0HC05601p1                   pd_00           ONLINE          Good

        data_01         /dev/NVD_S01_S2LHNA0HC05809p1                   pd_01           ONLINE          Good


[root@odanode1 ~]# odaadmcli show diskgroup RECO

        ASM_DISK        PATH                                            DISK            STATE           STATE_DETAILS

        reco_00         /dev/NVD_S00_S2LHNA0HC05601p2                   pd_00           ONLINE          Good

        reco_01         /dev/NVD_S01_S2LHNA0HC05809p2                   pd_01           ONLINE          Good

  • To list file system details execute the following command
[root@odanode1 ~]# odaadmcli show fs
      Type     Total Space      Free Space  Total DG Space   Free DG Space  Diskgroup Mount Point
      ext3          30109M          13215M               -               -            /
      ext3            476M            405M               -               -            /boot
      ext3          60347M          43274M               -               -            /opt
      ext3         302252M         235296M               -               -            /u01
      acfs           5120M           5071M        4894016M          70220M       DATA /opt/oracle/dcs/commonstore
      acfs        2406400M        1699624M        4894016M          70220M       DATA /u02/app/oracle/oradata/datastore
      acfs         306176M         292685M        1231176M          14372M       RECO /u01/app/oracle/fast_recovery_area/datastore
      acfs         302080M         294707M        1231176M          14372M       RECO /u01/app/oracle/oradata/datastore

  • To list storage details execute the following command
[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 =========

  • To ODA hardware details execute the following command
[root@odanode1 ~]# odaadmcli show env_hw
BM ODA X6-2 Small

  • To list ODA server details execute the following command
[root@odanode1 ~]# odaadmcli show server

        Power State              : On

        Open Problems            : 0
        Model                    : ODA X6-2S
        Type                     : Rack Mount
        Part Number              : ODA X6-2S
        Serial Number            : xxxxxxxxx
        Primary OS               : Not Available
        ILOM Address             : 10.10.10.11
        ILOM MAC Address         : 00:10:E0:BF:1C:38
        Description              : Oracle Database Appliance X6-2 Small xxxxxxx
        Locator Light            : Off
        Actual Power Consumption : 135 watts
        Ambient Temperature      : 27.000 degree C
        Open Problems Report     : System is healthy

  • To check processor status the following command
[root@odanode1 ~]# odaadmcli 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

       
  • To check Memory status execute the following command
[root@odanode1 ~]# odaadmcli show memory

        NAME    HEALTH HEALTH_DETAILS PART_NO.         SERIAL_NO.         LOCATION MANUFACTURER MEMORY_SIZE CURR_CLK_SPEED ECC_Errors


        DIMM_0  OK     -              3A4K40BB1-CRC    00CE02164433E98884 P0/D0    Samsung      32 GB       2400 MHz       0

        DIMM_11 OK     -              3A4K40BB1-CRC    00CE02164433E986FB P0/D1    Samsung      32 GB       2400 MHz       0
        DIMM_3  OK     -              3A4K40BB1-CRC    00CE02164433E9863B P0/D3    Samsung      32 GB       2400 MHz       0
        DIMM_8  OK     -              3A4K40BB1-CRC    00CE02164433E98689 P0/D8    Samsung      32 GB       2400 MHz       0

  • To check raid status execute the following command
[root@odanode1 ~]# odaadmcli 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     SV62214495    6.17.04.2_4.16.08.00_0x06060A 4.230.40-3739  RAID1        Optl         MS4SC2JH2ORA480G    252:0    Onln        446.102 GB

CVPM02   Optimal  27C
        IR_0_0_1 0     LSI MegaRAID 9361-8i     SV62214495    6.17.04.2_4.16.08.00_0x06060A 4.230.40-3739  RAID1        Optl         MS4SC2JH2ORA480G    252:1    Onln        446.102 GB
CVPM02   Optimal  27C
       
  • To check power status execute the following command
[root@odanode1 ~]# odaadmcli 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+1644CE006L PS0      Present     60 watts     27.000 degree C 33.812 degree C

        Power_Supply_1  OK     -              7079395  476856Z+1644CE000A PS1      Present     56 watts     27.000 degree C 32.938 degree C

  • To check network status execute the following command
[root@odanode1 ~]# odaadmcli 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:BF:1C:34  yes (em1)     61.250 degree C

        Ethernet_NIC_1 OK     -              NET1     X540    INTEL        00:10:E0:BF:1C:35  yes (em2)     61.250 degree C
        Ethernet_NIC_2 -      -              NET2     X540    INTEL        90:E2:BA:D9:7D:B9  no (p3p2)     -
        Ethernet_NIC_3 -      -              NET3     X540    INTEL        90:E2:BA:D9:7D:B8  no (p3p1)     -



Conclusion


In this article we have learned about Oracle Database Appliance X6-2 and X7-2 model family. Also we have learned how to use the odacli and odaadmcli command line utilities to manage and administer an Oracle Database Appliance.  odacli is used for Hardware and administrative tasks on the Oracle Database Appliance, Example: Hardware monitoring and Storage Configuration whereas odaadmcli is used for everyday task on the Oracle Database Appliance, Example: Database Creation, Patches and upgrades, Job creation and manage and so on.

2 comments:

  1. Very useful docs Thanks
    Rafi

    ReplyDelete
    Replies
    1. You are welcome! Please continue to follow our blog for more such articles.

      Delete

Comparing Oracle Database Appliance X8-2 Model Family

September 2019 Oracle announced Oracle Database Appliance X8-2 (Small, Medium and HA). ODA X8-2 comes with more computing resources com...