Oracle Cloud Infrastructure Documentation

Creating an Autonomous Data Warehouse

This topic describes how to provision a new Autonomous Data Warehouse using the Oracle Cloud Infrastructure Console or the API. For an Oracle By Example tutorial on provisioning a Autonomous Data Warehouse, see Provisioning Autonomous Data Warehouse Cloud.

Prerequisites

  • To create an Autonomous Data Warehouse, you must be given the required type of access in a An IAM document that specifies who has what type of access to your resources. It is used in different ways: to mean an individual statement written in the policy language; to mean a collection of statements in a single, named "policy" document (which has an Oracle Cloud ID (OCID) assigned to it); and to mean the overall body of policies your organization uses to control access to resources. written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which A collection of related resources that can be accessed only by certain groups that have been given permission by an administrator in your organization. you should work in. See Authentication and Authorization for more information on user authorizations for the Oracle Cloud Infrastructure Database service.
  • See What Do You Need? for information on additional prerequisites for provisioning an Autonomous Data Warehouse.

Using the Oracle Cloud Infrastructure Console

To create an Autonomous Data Warehouse

  1. Open the navigation menu. Under Database, click Autonomous Data Warehouse.
  2. Choose your Compartment.
  3. Click Create Autonomous Data Warehouse.
  4. In the Create Autonomous Data Warehouse dialog, enter the following:

    • Display Name: A user-friendly description or other information that helps you easily identify the resource. The display name does not have to be unique, and you can change it whenever you like. Avoid entering confidential information.
    • Database Name: The database name must consist of letters and numbers only. The maximum length is 14 characters. Avoid entering confidential information.

      Note

      A database name cannot be used concurrently for both an Autonomous Data Warehouse and an Autonomous Transaction Processing database.

    • CPU Core Count: You can enable up to 128 cores for your Autonomous Data Warehouse database. The actual number of available cores is subject to your tenancy's service limits.
    • Storage: Specify the storage you wish to make available to your Autonomous Data Warehouse database, in terabytes. You can make up to 128 TB available.
    • Administrator Credentials: Set the password for the Autonomous Data Warehouse Admin user by entering a password that meets the following criteria. You use this password when accessing the Autonomous Data Warehouse service console and when using an SQL client tool.

      • Between 12 and 30 characters long
      • Contains at least one lowercase letter
      • Contains at least one uppercase letter
      • Contains at least one number
      • Does not contain the double quotation mark (")
      • Does not contain the string "admin", regardless of casing
    • License Type: The type of license you want to use for the Autonomous Transaction Processing database. Your choice affects metering for billing. You have the following options:

      • My Organization Already Owns Oracle Database Software Licenses: This choice is used for the Bring Your Own License (BYOL) license type. If you choose this option, make sure you have proper entitlements to use for new service instances that you create.
      • Subscribe To New Database Software Licenses And The Database Cloud Service: This is used for the License Included license type. With this choice, the cost of the cloud service includes a license for the Database service.
    • Tags: Optionally, you can apply tags. If you have permissions to create a resource, you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see Resource Tags. If you are not sure if you should apply tags, skip this option (you can apply tags later) or ask your administrator. Avoid entering confidential information.
  5. Click Create Autonomous Data Warehouse.

Using the API

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Use the CreateAutonomousDataWarehouse API operation to create Autonomous Data Warehouse databases.

For More Information