Note:

Provision Oracle Exadata Database Service in Oracle Database@AWS

Introduction

Oracle Database@AWS is a strategic partnership between Oracle and Amazon Web Services (AWS) that enables applications running in AWS Regions to use Oracle Exadata Database Service on Dedicated Infrastructure and Oracle Autonomous Database on Dedicated Exadata Infrastructure running on Oracle Cloud Infrastructure (OCI) in AWS. AWS applications and services such as Amazon Kinesis and Amazon QuickSight can now have low-latency, native access to Oracle databases running on Oracle Exadata Cloud Infrastructure and take advantage of Oracle Database 23ai features like AI Vector Search

Like other AWS resources, the Oracle Database@AWS architecture requires an Amazon Virtual Private Cloud (VPC) to provide networking for application resources within an AWS Region. In addition, Oracle Database@AWS operating in an OCI child site colocated in the same AWS Region has an OCI virtual cloud network (VCN) that extends to the parent OCI region to enable access to other resources in OCI. OCI manages the network between the OCI child site and the parent OCI region. AWS manages the network connection between the Operational Database (ODB) network and the application VPC.

Note: Oracle Database@AWS is currently available as a Limited Preview.

Image showing network diagram of Exadata Infrastructure in Oracle Database@AWS

Leveraging AWS and OCI automation, it is easy to start running Oracle Exadata Database Service in Oracle Database@AWS. Provisioning Oracle Exadata Database Service requires the following four simple steps:

  1. Create the ODB network.
  2. Create the Exadata Infrastructure.
  3. Create an Exadata VM cluster in the Exadata Infrastructure.
  4. Create an Oracle Database in an Exadata VM cluster.

Objectives

Task 1: Create the ODB Network

An ODB network is a private isolated network that hosts OCI infrastructure in an AWS availability zone (AZ). The ODB network consists of a CIDR range of IP addresses. The ODB network maps directly to the network that exists within the OCI child site, thus serving as the means of communication between AWS and OCI.

Note: You will require an AWS account and request a private offer for Oracle Database@AWS from AWS Marketplace.

  1. Log in to the AWS Management Console and open the Oracle Database@AWS Console using https://console.aws.amazon.com/odb/.

  2. Click ODB networks and Create ODB network or directly click Create ODB network under Step 1.

    Image showing Oracle Database@AWS console in AWS Management Console

  3. In the Create ODB network page, enter ODB network name, Availability Zone, Client subnet CIDR, Backup subnet CIDR and Domain name prefix.

    Image showing how to create ODB network

  4. Click Create ODB network.

Task 2: Create the Exadata Infrastructure

Oracle Exadata Database Service colocated in AWS supports dedicated Exadata Infrastructure with a minimum configuration of 2 and maximum of 32 database servers and 3 storage servers up to 64, that are internally connected by a high-speed, low-latency internal Remote direct memory access (RDMA) network fabric that requires no configuration. Exadata Infrastructure within an AWS data center integrates the hardware with the networking resources needed to securely connect to other services in the cloud. With Oracle Exadata Database Service, Oracle performs monthly security and quarterly infrastructure updates. You can specify the quarterly infrastructure maintenance schedule that meets your business requirements.

  1. To create the Exadata Infrastructure, select Exadata Infrastructures and click Create Exadata Infrastructure.

    Note: Assume that your OCI tenancy has been linked through the private offer.

    Image showing AWS Management Console navigation

  2. In Step 1 - Configure general settings, enter Exadata infrastructure name, select Availability Zone where the Exadata Infrastructure will be provisioned in, and click Next.

    Image showing Configure general settings

  3. In Step 2 - Configure Exadata Infrastructure, indicate the Exadata Infrastructure shape. The minimum configuration is already filled in for you with two Database servers and three Storage servers. You can have up to 32 database servers and 64 storage servers on a single Exadata Infrastructure, and then click Next.

    Note: Make sure the limits for the number of database and storage servers has been set within your OCI linked tenancy.

    Image showing Configure Exadata Infrastructure

  4. In Step 3 - Configure maintenance and tags, all fields are optional. You can enter up to 10 email addresses that will be notified of upcoming maintenance updates. Optionally, you can add Tags to be used to search and filter your AWS resources or track AWS costs, and then click Next.

    Note: Infrastructure maintenance scheduling can be updated from the OCI Console.

    Image showing Configure maintenance and tags

  5. In Step 4 - Review and create, review the Exadata Infrastructure configuration.

    You can click Cancel to cancel the creation of the Exadata Infrastructure, Previous to go back and update values, Create Exadata Infrastructure to proceed with the creation.

    Image showing Review and create

  6. After the Exadata Infrastructure is successfully created, you can see the following information.

    • Summary: View the configuration of the Exadata Infrastructure.

      • Database servers: View database servers and resources.
      • Exadata VM clusters: View Exadata VM clusters that have been created in this Exadata Infrastructure.
      • OCI maintenance: Link to OCI Console to update the Exadata Infrastructure maintenance schedule.
      • Tags: View tags that have been associated with this Exadata Infrastructure.
    • OCI resources: Find a link to access the OCI Console directly for this Exadata Infrastructure

    Image showing Exadata Infrastructure Summary

Task 3: Create an Exadata VM Cluster in the Exadata Infrastructure

Each Exadata Infrastructure database server contains one or more virtual machine (VM) guests. With support for multiple virtual machine clusters (MultiVM), you can support up to eight VMs per database server and host a total of eight VM clusters per Exadata database system. When you provision the VM cluster, you specify system resources allocated to the VM clusters that will support your Oracle database workloads.

  1. To create an Exadata VM cluster, select Exadata VM clusters and Create VM Cluster.

    Image showing Create Exadata VM Cluster

  2. In Step 1 - Configure general settings, enter VM cluster name, confirm Time zone, License options and click Next.

    Image showing Configure general settings

  3. In Step 2 - Configure infrastructure settings, enter the following information and click Next.

    • Exadata infrastructure name: Select the Exadata Infrastructure the VM cluster will be created on.

    • Grid Infrastructure version: Select the Oracle Grid Infrastructure version of the release (19c and 23ai) you want to install on the VM cluster.

      Note: The Oracle Grid Infrastructure release determines the Oracle Database releases that can be supported on the VM cluster. For example, you cannot run an Oracle Database release that is newer than the Oracle Grid Infrastructure software release.

    • Exadata image version: Select the Exadata system software version. This determines Operating System (OS) version and features available in the guest VM image.

    • Database servers: Select the DB server(s) the VM image will be created on.

    • Configuration Allows you to allocate resources to your VM. Enter the following information.

      • CPU core count: Enter OCPU count per VM to allocate that number of OCPUs to each of the VM clusters’ virtual machine compute nodes. Minimum is two OCPUs per VM.

      • Memory: Enter the memory per VM to allocate to each VM. The minimum per VM is 30 GB.

      • Local Storage: Enter the local storage per VM to allocate local storage to each VM. The minimum per VM is 60 GB.

        Note: Each time you create a new VM cluster, the space remaining out of the database server local space is utilized for the new VM cluster.

      • Enter Per cluster Exadata storage in multiples of 1 TB. The minimum is 2 TB.

      • Storage allocation:

        • Enable storage allocation for local backups: Select if you intend to perform database backups to the local Exadata storage within your Oracle Exadata Cloud Infrastructure instance. The storage configuration option for local backups cannot be changed after VM cluster creation.

        • Enable storage allocation for Exadata sparse snapshots: Select if you intend to use snapshot functionality within your VM cluster. The storage configuration option for sparse snapshots cannot be changed after VM cluster creation.

    Image showing Configure infrastructure settings

  4. In Step 3 - Configure connectivity, select ODB network created in Task 1, enter a Host name prefix, SSH key pairs used to access the VM cluster.

    You can click Cancel to cancel the creation of the VM cluster, Skip to Review and Create to skip the step, Previous to go back and update values, or Next to proceed with the VM cluster configuration.

    Image showing Configure connectivity

  5. In Step 4 - Configure diagnostics and tags, this step is optional. By enabling OCI diagnostic collection, Oracle Cloud operations and you will be able to identify, investigate, track, and resolve guest VM issues quickly and effectively. Subscribe to events to get notified about resource state changes.

    Note: You can opt out of this feature at any time.

    You can add Tags to be used to search and filter your AWS resources or track AWS costs and click Next.

    Image showing Configure diagnostics and tags

  6. In Step 5 - Review and create, review the VM cluster information and click Create VM Cluster.

    Image showing Review and create

  7. After the VM cluster is successfully created, you can see the following information.

    • Summary: View the configuration of the VM cluster.

      • Virtual machines: View guest VMs that are associated to the VM cluster.
      • Configuration: View VM cluster configuration.
      • Connectivity: View the network configuration and SSH key pairs.
      • Tags: View tags that have been associated to this Exadata Infrastructure.
      • Monitoring: View the VM cluster metrics such as CPU utilization, load average, memory utilization, and more.
    • OCI resources: Find a link to jump to the OCI Console directly to this VM cluster and the Exadata Infrastructure.

    Image showing VM Cluster Summary

Task 4: Create Oracle Database

  1. Oracle Database creation is managed from the OCI Console. With the tight integration between OCI and AWS, a direct link is available from the AWS Management Console. Click VM cluster name or Manage in OCI.

    Image showing Create Oracle database link from AWS Management Console

  2. Oracle Database is a VM cluster resource. In the Exadata VM Cluster Detail page, under Resources, click Databases and Create database.

    Image showing VM cluster details page

    Image showing Create Oracle database from OCI Console

  3. In the Basic information for the database section, enter the following information.

    • Provide the database name: Enter the database name.

      Note: You need to meet the following requirements.

      • Maximum of eight characters.
      • Contain only alphanumeric characters.
      • Begin with an alphabetic character.
      • Cannot be part of the first eight characters of a DB_UNIQUE_NAME on the VM cluster.
    • Provide a unique name for the database (Optional): If not specified, the system automatically generates a unique name value, as <db_name>\_<3_chars_unique_string>\_\<region-name\>.

      Note: If you enter a unique name, you need to meet the following requirements.

      • Maximum of 30 characters.
      • Contain only alphanumeric or underscore (_) characters.
      • Begin with an alphabetic character.
      • Unique across the VM cluster. Recommended to be unique across the tenancy.
    • Select a Database version: Select a database version.

    • Provide a PDB name (Optional):. If not specified, the system automatically generates a name value.

      Note: You need to meet the following requirements.

      • Maximum of eight characters.
      • Contain only alphanumeric or underscore (_) characters.
      • Begin with an alphabetic character.
      • To avoid potential service name collisions when using Oracle Net Services to connect to the PDB, ensure that the PDB name is unique across the entire VM cluster.

      Image showing Create Oracle database Basic Information

  4. In the Specify a database home section, enter the following information.

    • Database Home source: Select database home source.
      • Select an existing Database Home.
      • Create a new Database Home and enter Database Home display name.
    • Enable database Unified Auditing
    • Database Image (Optional): Database image to use a desired Oracle-published image or a custom database software image that you have created in advance.

    Image showing Create Oracle database specify a database home

  5. In the Create administrator credentials section, create administrator credentials for sys password.

    • Password: Enter password.

      Note: You need to meet the following requirements.

      • Must be 9 to 30 characters.
      • Contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be (_), (#), or (-).
      • The password must not contain the username (SYS, SYSTEM, and so on) or the word Oracle either in forward or reversed order and regardless of casing.
    • Confirm password: Confirm the sys password you specified.

    • (Optional) Select Use the administrator password for the TDE wallet.

    Image showing Create Oracle database Create administrator credentials

  6. In the Configure database backups section, configure database backups by specifying the settings for backing up the database to OCI Object Storage.

    Image showing Create Oracle database configure database backups

  7. Click Show advanced options.

    1. In the Management section, enter the following information.

      • Oracle SID prefix (Optional): Oracle SID prefix is the Oracle Database instance number and is automatically added to the SID prefix to create the INSTANCE_NAME database parameter. The INSTANCE_NAME parameter is also known as the SID. The SID is unique across the cloud VM cluster. If not specified, SID prefix defaults to the db_name.

        Note: You need to meet the following requirements.

        • Maximum of 12 characters.
        • Contain only alphanumeric or underscore (_) characters.
        • Begin with an alphabetic character.
        • Unique in the VM cluster.
      • Character set: Character set for the database. The default is AL32UTF8.

      • National character set (Optional): National character set is the national character set for the database. The default is AL16UTF16.

      Image showing Create Oracle database Advanced Options - Management

    2. In the Encryption section, to manage your database keys select Use Oracle-managed keys or Use customer-managed keys. For more information about the options to manage your database keys, see Security Guide for Oracle Exadata Database Service on Dedicated Infrastructure.

      Image showing Create Oracle database Advanced Options - Encryption

    3. In the Tags section, select Tag namespace. Tagging allows you to define Tag key(s) and Tag value(s) and associate them with resources. You can then use the tags to help you organize and list resources based on your business needs. For more information about tags, see Tagging Oracle Exadata Database Service on Dedicated Infrastructure Resources.

      Image showing Create Oracle database Advanced Options - Tags

  8. Click Create Database to proceed with the Oracle Database provisioning.

    Image showing Create Database button

Next Steps

You are now ready to migrate your data to your new Oracle Database. Take a look at Oracle Zero Downtime Migration (ZDM) to help you with your migration needs.

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.