Creating an Autonomous Database

This topic describes how to provision a new Autonomous Database using the Oracle Cloud Infrastructure Console or the API. Autonomous Databases can be provisioned on dedicated Exadata infrastructure or shared Exadata infrastructure. Your database can by optimized for either transaction processing or data warehouse workloads.

If you want to provision an Always Free Autonomous Database, see the To create an Always Free Autonomous Database task instructions in this topic. For more information on the Free Tier, see Oracle Cloud Infrastructure Free Tier.

For Oracle By Example tutorials on provisioning Autonomous Databases, see Provisioning Autonomous Transaction Processing and Provisioning Autonomous Data Warehouse Cloud.

Prerequisites

  • To create an Autonomous Database, you must be given the required type of access in a policy  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 compartment  you should work in. See Authentication and Authorization for more information on user authorizations for the Oracle Cloud Infrastructure Database service.

    Tip

    See Let database and fleet administrators manage Autonomous Databases for sample Autonomous Database policies. See Details for the Database Service for detailed information on policy syntax.

  • For information on additional prerequisites for provisioning an Autonomous Transaction Processing database, see What Do You Need? Likewise, for information on additional prerequisites for provisioning an Autonomous Data Warehouse, see What Do You Need?
  • To create an Autonomous Transaction Processing database on dedicated Exadata infrastructure, you must first provision the infrastructure and at least one Autonomous Container Database. For more information, see Creating an Autonomous Exadata Infrastructure Resource and Creating an Autonomous Container Database.

Using the Oracle Cloud Infrastructure Console to Create an Autonomous Database

To create an Autonomous Database on shared Exadata infrastructure
To create an Autonomous Database database on dedicated Exadata infrastructure
To create an Always Free Autonomous Database

Using the API

Use the CreateAutonomousDatabase API operation to create Autonomous Databases of either the transaction processing or warehouse workload types.

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.

For More Information

Autonomous Transaction Processing

Autonomous Data Warehouse

Hidden x-ref linking content. Do not remove! This topic has moved. Please update your bookmarks.

Hidden x-ref linking content. Do not remove! This topic has moved. Please update your bookmarks.