Netsoftmate

Category: Oracle Database Appliance – ODA

All you need to know about ODA – Oracle Database Appliance

  • Comparing Oracle Database Appliance X8-2 Model Family

    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 compared with X7-2 Models.

    Let’s take a quick look at few benefits of ODA followed by the technical specification on ODA X8-2 Small/Medium and HA.

    Oracle Database Appliance is an Engineered System. Software, server, storage, and networking, all co-engineered and optimized to run Oracle Database and applications.

    Benefits of Oracle Database Appliance (ODA):

    1. Software, server, storage, and networking engineered and optimized to run Oracle Database and applications.
    2. Supports Oracle Database Standard Edition, Standard Edition One, Standard Edition 2, and Enterprise Edition. Optimized for Cloud.
    3. Capacity on Demand Licensing – Reduced Cost.
    4. Ease of deployment, patching, management, and support.
    5. Increased performance and reliability with NVMe flash storage.
    6. Reliable hardware architecture with redundant power, cooling, networking, and storage.
    7. Browser User Interface (BUI)

    In this article we will compare the technical specifications of ODA X8-2 model family (Small, Medium and HA). This comparison table comes handy when you want to quickly take a look at the resources available for a given model.

     

    For more information on the technical specification loot at the ODA X8-2 HA and Small/Medium Data Sheet at:

    https://www.oracle.com/technetwork/database/database-appliance/oda-x8-2-ha-datasheet-5730739.pdf

    https://www.oracle.com/technetwork/database/database-appliance/oda-x8-2sm-datasheet-5730738.pdf

    Component

    ODA X8-2 Small

    ODA X8-2 Medium

    ODA X8-2 HA

    Database Server

    1

    1

    2

    Storage Shelf

    NA

    NA

    1 4U DE3-24C Storage Shelf per System

    Optional Second Storage Shelf for Expansion

    Rack Size

    1 2RU Server

    1 2RU Server

    2 2RU Servers & 1 4U Storage Shelf

    Processor

    One 16-core Intel Xeon Gold 5218

    Two 16-core Intel Xeon Gold 5218

    Two 16-core Intel Xeon Gold 5218 Per Server

    Physical Memory

    192 GB

    Expandable to 384 GB

    384 GB

    Expandable to 768 GB

    384 GB

    Expandable to 768 GB per server

    Storage

    Two 6.4 TB NVMe SSDs

    12.8 TB (raw)

    Base: Two 6.4 TB NVMe SSDs

    12.8 TB (raw)

    Base: Six 7.68 TB SSDs

    46 TB (raw)

    Storage Expansion

    Not expandable

    Expandable up to 76.8 TB (raw)

    Expandable up to 369 TB SSD or up to 92 TB SSD / 504 TB HDD (Raw)

    Network

    4 x 10GBase-T ports (RJ45) expandable up to 12 x 10GBase-T ports or

    2 x 10/25 GbE ports (SFP28) expandable up to 6 x 10/25 GbE ports

    4 x 10GBase-T ports (RJ45) expandable up to 12 x 10GBase-T ports or

    2 x 10/25 GbE ports (SFP28) expandable up to 6 x 10/25 GbE ports

    4 x 10GBase-T ports (RJ45) expandable up to 12 x 10GBase-T ports or

    2 x 10/25 GbE ports (SFP28) expandable up to 6 x 10/25 GbE ports

    Oracle Database

    Oracle Database 18c/19c EE & SE 2

    Oracle Database 12c R1/R2 EE & SE 2

    Oracle Database 11g R2 EE, SE & SE 1

    Oracle Database 18c/19c EE & SE 2

    Oracle Database 12c R1/R2 EE & SE 2

    Oracle Database 11g R2 EE, SE & SE 1

    Oracle Database 18c/19c EE & SE 2

    Oracle Database 12c R1/R2 EE & SE 2

    Oracle Database 11g R2 EE, SE & SE 1

    Database Deployment

    Single Instance

    Single Instance

    Single Instance, RAC & RAC One node

    Virtualization

    Oracle Linux KVM

    Oracle Linux KVM

    Oracle VM & Oracle Linux KVM

    Operating System

    Oracle Linux

    Oracle Linux

    Oracle Linux

    Are you and your team considering setting up Oracle Database Appliance? Let Netsoftmate help you choose the right product keeping under consideration your budget, requirement and usage forecasting. Click on the image below to sign-up NOW!

  • Exclusive First Look into Oracle Database Appliance X8 Model Family

    Exclusive First Look into Oracle Database Appliance X8 Model Family

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

    Let’s take a quick look at few benefits of ODA followed by the technical specification on ODA X8-2 Small/Medium and HA.

    Oracle Database Appliance is an Engineered System. Software, server, storage, and networking, all co-engineered and optimized to run Oracle Database and applications.

    Benefits of Oracle Database Appliance (ODA):

    1. Software, server, storage, and networking engineered and optimized to run Oracle Database and applications.
    2. Supports Oracle Database Standard Edition, Standard Edition One, Standard Edition 2, and Enterprise Edition.
    3. Optimized for Cloud
    4. Capacity on Demand Licensing – Reduced Cost
    5. Ease of deployment, patching, management, and support
    6. Increased performance and reliability with NVMe flash storage
    7. Reliable hardware architecture with redundant power, cooling, networking, and storage
    8. Browser User Interface (BUI)

    Oracle Database Appliance X8-2 HA Benefits & Technical specification

    1. Support mission-critical applications and consolidation of many databases
    2. Built for high availability
    3. Choice of high-performance flash or high-capacity drives
    4. 32 cores per server (64 cores in total for 2 servers)
    5. 384 GB physical memory per server expandable upto 768 (1.5 TB memory in total for 2 servers)
    6. Storage Shelf
    7. High Capacity: 46 TB SSD and 252 TB SDD raw capacity per shelf
    8. High Performance: 184 TB SSD raw capacity per shelf
    9. Choice of 10GBase-T or 10/25 GbE SFP28 public networking
    10. 25GbE interconnect for cluster communication

    For more information on the technical specification loot at the ODA X8-2 HA Data Sheet at:
    https://www.oracle.com/technetwork/database/database-appliance/oda-x8-2-ha-datasheet-5730739.pdf

     
     
     

    • Oracle Database Appliance X8-2 Small Technical specification

    1. One server
    2. 1 Intel Xeon processor, 16 Cores
    3. 192GB Physical memory expandable upto 384GB
    4. Choice of 10GBase-T or 10/25 GbE SFP28 public networking
    5. 12.8TB NVMe raw storage

    Oracle Database Appliance X8-2 Medium Technical specification

    1. One server
    2. 2 Intel Xeon processor, 32 Cores
    3. 384 GB Physical memory expandable upto 768GB
    4. Choice of 10GBase-T or 10/25 GbE SFP28 public networking
    5. 12.8 TB NVMe raw storage capacity with optional expansion to 76.8 TB NVMe raw storage

    For more information on the technical specification loot at the ODA X8-2 S/M Data Sheet at:
    https://www.oracle.com/technetwork/database/database-appliance/oda-x8-2sm-datasheet-5730738.pdf

    Conclusion

    In this article we seen the benefits and the technical specification of latest Oracle Database Appliance X8 model family. ODA is the right choice for all type of Businesses as an on-premises solution and cloud ready option.

    Are you and your team considering setting up Oracle Database Appliance? Let Netsoftmate help you choose the right product keeping under consideration your budget, requirement and usage forecasting. Click on the image below to sign-up NOW!

  • Oracle Database Appliance (ODA) OAKCLI vs. ODACLI

    Oracle Database Appliance (ODA) OAKCLI vs. ODACLI

    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 12.2.1.4 or older use the tools as shown in the following table
    •  
    •  
    Oakcli
    odacli/odaadmcli
    ODA V1
    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 X6-2 HA
     
    ODA X7-2 HA (VM Only)
     
     
    • For Oracle Database Appliance software version 18.3.0.0 and later user the tools as shown in the following table
    •  
    oakcli
    odacli/odaadmcli
    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: 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
     
     
    [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
    DiskGroups
    ———-
    DATA
    RECO
     
     
    [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
    BM ODA X5-2
    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
     
     
     
    Conclusion

    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