Provision Autonomous Data Warehouse

Follow these steps to provision a new Autonomous Data Warehouse instance using the Oracle Cloud Infrastructure Console.

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • Open the Oracle Cloud Infrastructure console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.

  1. Choose your region. See Switching Regions for information on switching regions and working in multiple regions.
  2. Click Create Autonomous Database.
  3. Provide basic information for the Autonomous Database.
    • Choose a compartment. See Compartments for information on using and managing compartments.

    • Display name Specify a user-friendly description or other information that helps you easily identify the resource. The display name does not have to be unique.

    • Database name Specify the database name; it must consist of letters and numbers only. The maximum length is 14 characters.

      Note:

      The same database name cannot be used for multiple Autonomous Database databases in the same tenancy in the same region.
  4. Choose a workload type. Select the workload type for your database from the choices:
    • Data Warehouse

    • Transaction Processing

  5. Choose a deployment type.
    • Shared Infrastructure

      Run Autonomous Database on shared Exadata infrastructure.

    • Dedicated Infrastructure

      Run Autonomous Database on dedicated Exadata infrastructure.

    Select Shared Infrastructure to create your instance on shared Exadata infrastructure.

    See Create an Autonomous Data Warehouse Database on Dedicated Exadata Infrastructure for steps to create your instance on dedicated Exadata infrastructure.

  6. Configure the database.
    • CPU core count Specify the number of CPU cores for your Autonomous Data Warehouse database.

    • Storage (TB) Specify the storage you wish to make available to your Autonomous Data Warehouse database, in terabytes.

    • Auto Scaling Deselect to disable auto scaling. By default auto scaling is enabled to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand. See Use Auto Scaling for more information.

  7. When a preview version is available, if you want to use the preview version, select Enable Preview Mode.

    If you want to use the preview version, also accept the preview termination period notice. See Preview Versions for Autonomous Database for more information.

    Note:

    A preview version is only available when there is an upcoming major version to release. At times no preview version will be available.
  8. Create administrator credentials. Set the password for the Autonomous Data Warehouse Admin user. The password must meet the strong password complexity criteria based on Oracle Cloud security standards. For more information on the password complexity rules see Create Users with Autonomous Data Warehouse.
    • Username This is a read only field.

    • Password Set the password for the Autonomous Data Warehouse Admin user. The password must meet the strong password complexity criteria based on Oracle Cloud security standards. For more information on the password complexity rules see Create Users with Autonomous Data Warehouse.

    • Confirm password Enter the same password again to confirm your new password.

  9. Choose network access

    By default all secure connections are allowed from everywhere. Configure the access control list (ACL) to restrict access. To set an ACL for the Autonomous Database, select Configure access control rules.

    See Use an Access Control List with Autonomous Database for more information.

  10. Choose a license type
    • Bring Your Own License

      My organization already owns Oracle database software licenses. Bring my existing database software licenses to the database cloud service (details).

    • License Included

      Subscribe to new database software licenses and the database cloud service.

    (Optional) Click Show Advanced Options to enter additional options.

    If you want to use Tags, enter the TAG KEY and VALUE. Tagging is a metadata system that allows you to organize and track resources within your tenancy. Tags are composed of keys and values which can be attached to resources.

  11. Click Create Autonomous Database.

On the Oracle Cloud Infrastructure console the State shows Provisioning... until the new Autonomous Data Warehouse database is available.