Note:

Provision Oracle Exadata Database Service on Exascale Infrastructure

Introduction

Oracle Exadata Database Service on Exascale Infrastructure is a new cloud database service that uses Exadata Exascale in Oracle Cloud Infrastructure (OCI). Exascale is a multitenant, hyper-elastic intelligent data architecture that delivers all the advantages of Exadata with all the benefits of modern clouds. Exascale pools shared database-optimized compute and storage resources to enable you to provision and scale just the database storage and VM resources you need. You can start with a small VM cluster and small amount of storage and easily scale as needs grow. With the introduction of Exascale infrastructure, the benefits of Exadata Database Service are now available for workloads at any scale.

Objectives

Prerequisites

Task 1: Create a VM Cluster

  1. Log in to the OCI Console, navigate to Oracle Database and Oracle Exadata Database Service on Exascale Infrastructure.

    Image showing OCI Console Navigation

  2. Select the Region and Compartment for which you want to create your VM cluster.

  3. Click Create Exadata VM Cluster to provision a new Exadata Database Service on Exascale Infrastructure VM cluster.

    Image showing option to create Exadata VM Cluster

  4. Provide the basic information and select Availability Domain in which your VM Cluster will reside.

    • Compartment Select a compartment for the VM cluster resource.
    • Display name Enter a user-friendly display name for the VM cluster. The name doesn’t need to be unique. An Oracle Cloud Identifier (OCID) will uniquely identify the DB system.
    • Cluster name Select the name of the VM cluster.
    • Select an availability domain Select the availability domain from the displayed options available.

    Image showing the VM basic information to enter

  5. Configure the VM cluster. Provide the following information:

    • Number of VMs in the cluster Specify the number of the VMs that you want to configure for the cluster, between 2 and 10.

    • ECPUs enabled per VM Specify the number of ECPU cores that you want to enable for the VM cluster. The minimum is 8 ECPU. The value you select must be a multiple of 4.

      • Optional: Reserve additional ECPU
        • ECPUs additional reserved per VM (read only) Indicates the additional reserved ECPUs.
        • Total ECPUs per VM Provide a total number of ECPUs to allocate per VM. The total must be a number between 8 and 200.
        • Total ECPUs enabled across cluster per VM Provide a total number of ECPUs to allocate per VM. The total must be a number between 8 and 200.
      • Memory per VM (GB) (read-only) Displays the amount of memory allocated to each VM. Memory is calculated based on 2.75 GB per ECPU. The Total memory across VM Cluster (GB) field automatically updated to provide you with the total amount of memory allocated across the VM cluster.
      • VM file system storage capacity per VM (GB) Specify storage capacity per VM in gigabytes (GB).

      Note: Enter how much storage you want for the VM filesystem. The VM filesystem storage includes /u02 capacity, where your database homes will be created, along with all of the other VM file systems. Any extra capacity selected beyond system minimum will go into /u02.

    Image showing virtual machine configuration options

  6. In the Exascale Database Storage Vault page, select Create new vault or Select existing vault.

    Note: When you create a new vault, the provisioning status window opens to provide you with the status of vault creation, and the name of the vault that is being created in the format Vault-YYYYMMDDHHMM indicating the creation date, where YYYY is the year, MM is the month, DD is the day, HH is the hour, and MM is the minute.

    • For a new vault, enter the following information.

      • Vault: Enter a vault name.
      • Storage capacity for Databases (GB): The amount of usable disk storage capacity that will be available for storing databases that is desired between 300 to 100,000.
      • (optional) Add smart flash and memory cache: Enter the amount of smart flash cache. It is based on a percentage of storage capacity.

    Image showing Exascale database storage configuration options

  7. In the Configure Grid Infrastructure page, enter the following information.

    • Grid Infrastructure version: It displays the Oracle Grid Infrastructure versions available for deployment in the VM cluster.
    • Add SSH key: Add the public key portion of each key pair that you want to use for SSH access to the DB system.
      • Select Generate SSH key pair to generate an SSH key pair.
      • Select Upload SSH key files to browse or drag and drop .pub files.
      • Select Paste SSH keys to paste in individual public keys.

    Image showing Oracle Grid version options

  8. In the Configure the network settings page, enter the following information.

    • Virtual cloud network: Select the virtual cloud network (VCN) for the compartment in which you want to create the VM cluster.

    • Client subnet: Select the client subnet in the compartment.

    • Backup subnet: Select the subnet to use for the backup network, which is typically used to transport backup information to and from the backup destination, and for Oracle Data Guard replication.

      Note: Use network security groups to control traffic. Optionally, you can enter one or more network security groups (NSGs) for both the client and backup networks. NSGs function as virtual firewalls, allowing you to apply a set of ingress and egress security rules to your Oracle Exadata Database Service on Exascale Infrastructure VM cluster.

    • Hostname prefix: Enter a hostname for the Exadata DB system of your choice.

    • Host Domain Name (read only): Displays the host domain name for the VM cluster.

    • Host and domain URL (read only): Displays the combined host and domain names to display the fully qualified domain name (FQDN) for the database. The maximum length is 63 characters.

    Image showing network configuration options

  9. Select License type and Diagnostics collection.

    • Choose a license type:
      • License included: This means the cost of the cloud service includes a license for the Oracle Database service.
      • Bring Your Own License (BYOL): This means you are an Oracle Database customer with an Unlimited License Agreement or Non-Unlimited License Agreement, and you want to use your license with Oracle Cloud Infrastructure.
    • Diagnostic Collection: Enabling diagnostics collection and notifications allow you and Oracle Cloud Operations to identify, investigate, track, and resolve guest VM issues quickly and effectively.

    Image showing license type options

  10. Click Show advanced options and enter the following information.

    • Time zone: Under Management tab, default time zone for the DB system is UTC, but you can specify a different time zone.

      Image showing time zone options

    • SCAN Listener Port (TCP/IP): Under Network tab, assign a SCAN listener port (TCP/IP) in the range between 1024 and 8999. The default is 1521.

      Image showing SCAN listener port options

    • Tags: Apply free-form or defined tags to this resource.

      Image showing option to apply tags

  11. Click Create VM Cluster to create your new VM cluster on Exadata Database Service on Exascale Infrastructure.

    Image showing confirmation to create VM Cluster

Task 2: Provision a Container Database

  1. Go to the VM Cluster Details page, click Container databases and Create container database.

    Image showing the option to create a container database

  2. In the Create container database page, enter the following information.

    • Enter Basic information.

      • Database name: Enter a name for the database.
      • Unique name (Optional): Enter a unique name for the database.
      • Database version: Select the database version available.
      • PDB name (Optional): Enter the name of the first PDB to be created.

      Image showing the basic container database information to enter

    • Specify a Database Home.

      • Database Home source: Select to use an existing Database Home or Create a new Database Home.

      • Database Home display name: Use the default database home name or enter a database home name.

      • Change Database Image (Optional): Determines what Oracle Database version is used for the database. By default, the latest Oracle-published database software image is selected. Select to use an older Oracle-published image or a custom database software image that you have created in advance.

        Image showing Database Home selection

    • Enter administrator credentials.

      • Password: Enter password. Password must be 9 to 30 characters and contain at least 2 uppercase, 2 lowercase, 2 special, and 2 numeric characters. The special characters must be \, _, #, or -.

      • Confirm Password: Enter the same password.

        Image showing Administrator credentials to enter

  3. In the Configure Database backups page, if you accept the defaults setting, the database will be backed up using the Oracle Database Autonomous Recovery Service. You have the option to use OCI Object Storage by changing the Backup destination. The database will not be backed up if you deselect Enable automatic backups. Automatic backups can be enabled after the container database is created.

    Image showing database backup configuration options

  4. Click Show advanced options and enter the following information.

    • Oracle SID prefix and Character set (optional): Under Management tab, you can add Oracle SID prefix and select the Character set and National Character set.

      Image showing Oracle SID and Character set selection

    • Configure Key Management: Under Encryption tab, you have options to manage database keys. Select Use Oracle-managed keys to manage database keys using the wallet or select Use customer-managed keys to manage database keys using OCI Vaults.

      Image showing console connection copy SSH string options

    • Tags: Apply free-form or defined tags to this resource.

      Image showing the option to add container database tags

  5. Click Create container database.

    Image showing the option confirm creation of container database

Acknowledgments

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.