Create an Autonomous Transaction Processing Dedicated Database

Tip:

For a "try it out" alternative that demonstrates these instructions, see the Provisioning an Autonomous Transaction Processing Database Instance hands-on lab.
Follow these steps to create a new Autonomous Transaction Processing dedicated database using the Oracle Cloud Infrastructure console.
  1. Sign in to your Oracle Cloud Account at cloud.oracle.com.
  2. Click the Menu icon menu icon in the top corner to display the navigation menu, and then choose an item under Oracle Database based on whether you are creating a dedicated database on Oracle Cloud or Oracle Exadata Cloud@Customer:
    • On Oracle Cloud: click Autonomous Transaction Processing.

      The Autonomous Databases page opens, showing the list of databases in your current region and compartment.

    • On Oracle Exadata Cloud@Customer: click Exadata Cloud@Customer.

      The VM Clusters page opens. On this page's side menu, click Autonomous Databases.

  3. If needed, switch to the region where you want to create the dedicated database.

    See Switching Regions for information on switching regions and working in multiple regions.

  4. Click Create Autonomous Database.
  5. Select or enter basic information for your new dedicated database:
    • Compartment:  Select a compartment from the list of available 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 Databases in the same tenancy in the same region.
  6. For the workload type, choose Transaction Processing.
  7. For the infrastructure type, select Dedicated Infrastructure to deploy your database on a dedicated Exadata infrastructure.
    AvailabilityChoosing an infrastructure type is not applicable for Exadata Cloud@Customer.
  8. Choose the autonomous container database in which place your database:
    1. Start by choosing whether you want a standard autonomous container database or an autonomous container database configured to use Autonomous Data Guard.

      If you choose an autonomous container database configured to use Autonomous Data Guard, two databases of the OCPU count and storage you specify are created: one in a primary container database, and one (a synchronized copy) in a standby container database. For more information, see Managing Primary and Standby Databases in an Autonomous Data Guard Configuration.

    2. Select the autonomous container database, changing compartments if necessary.
  9. Enter the following to configure your database:
    • OCPU Count: Specify the number of OCPUs for your dedicated database.

    • Storage (TB): Specify the storage to allocate to your dedicated database, in terabytes.

    • Auto Scaling: Enable or disable auto scaling, which permits Autonomous Transaction Processing to automatically use up to three times as many OCPUs as specified by OCPU Count as the workload on the database increases.

  10. Set the password for the Admin database user in your new dedicated database.

    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 Database Users.

  11. Optionally, select Enable database level access control to configure network access by creating an access control list (ACL). An ACL provides additional protection to your Autonomous Transaction Processing database by allowing only the client with specific IP addresses to connect to the database. See Restrict Access Using a Network Access Control List for details.
    AvailabilityChoosing a network access type and setting an ACL is not currently supported for Autonomous Transaction Processing dedicated databases on Oracle Cloud.
    1. Click + Access Control Rule to add an ACL.
    2. Depending on the types of addresses in your list, select one of the following options from the IP notation type drop-down selector:
      • IP Address: Specify individual IP addresses. You can use commas to separate multiple IP addresses.
      • CIDR Block: Specify ranges of public IP addresses using CIDR notation. You can use commas to separate multiple values.
  12. Click Show Advanced Options to select additional features.
    • 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.
  13. Click Create Autonomous Database.

Your display shows Provisioning until the new Autonomous Transaction Processing dedicated database is available.

Note:

When you create an Autonomous Transaction Processing dedicated database, CPU billing is initiated, billed by the second with a minimum usage period of one minute.