This topic describes how to provision a new Autonomous Database using the Oracle Cloud Infrastructure Console or the API. For Oracle By Example tutorials on provisioning Autonomous Databases, see Provisioning Autonomous Transaction Processing and Provisioning Autonomous Data Warehouse Cloud.
To create an Autonomous Database, 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 Let database admins 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?
You can use the console to create either an Autonomous Database with either the Autonomous Transaction Processing or the Autonomous Data Warehouse workload type.
To Create an Autonomous Database
Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
In the Create Autonomous Database dialog, enter the following:
- Workload Type: Select the desired workload type. See About Autonomous Transaction Processing and About Autonomous Data Warehouse for information about each workload type.
- Compartment: Select the compartment of the Autonomous Database.
- 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.
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 Transaction Processing 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 Transaction Processing database, in terabytes. You can make up to 128 TB available.
Administrator Credentials: Set the password for the Autonomous Transaction Processing Admin user by entering a password that meets the following criteria. You use this password when accessing the Autonomous Transaction Processing 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.
Click Create Autonomous Database.
Using the API
Use the CreateAutonomousDatabase API operation to create Autonomous Transaction Processing 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
- Using Oracle Autonomous Transaction Processing (the Autonomous Transaction Processing user guide)
- Autonomous Transaction Processing: Tutorials (Oracle By Example tutorials)
- Autonomous Transaction Processing: Videos (video tutorials)