Provision Autonomous Data Warehouse

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

  • 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.


      After you create an Autonomous Database you cannot change the display name.
    • Database name Specify the database name; it must consist of letters and numbers only. The maximum length is 14 characters. The same database name cannot be used for multiple Autonomous 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

    • JSON Database

  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.
    • Choose database version Select the database version. The available database version is 19c.

    • OCPU 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 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. If you do not want to use auto scaling then deselect this option to disable auto scaling.

      See Use Auto Scaling for more information.

  7. Create administrator credentials. Set the password for the Autonomous Data Warehouse Admin user.
    • Username This is a read only field.

    • Password Set the password for the Autonomous Data Warehouse Admin user.

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

    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 on Autonomous Database.

  8. Choose network access


    After you provision your Autonomous Database you can change the network access option you select for the instance.
    • Allow secure access from everywhere

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

      See Configure Access Control Lists for an Existing Autonomous Database Instance for more information.

    • Virtual cloud network

      This option assigns a private endpoint, private IP and hostname, to your database. Specifying this option allows traffic only from the VCN you specify; access to the database from all public IPs or VCNs is blocked. This allows you to define security rules, ingress/egress, at the Network Security Group (NSG) level and to control traffic to your Autonomous Data Warehouse database.

      See Configure Private Endpoints When You Provision or Clone an Instance for more information.

  9. 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.

    See Tagging Overview for more information.

  10. Click Create Autonomous Database.

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