1 Getting Started with Autonomous Transaction Processing

Provides an overview of the service and describes how to get started with Autonomous Transaction Processing.

About Autonomous Transaction Processing

Autonomous Transaction Processing is designed to support all standard business applications and deliver scalable query performance.

Autonomous Transaction Processing provides all of the performance of the market-leading Oracle Database in an environment that is tuned and optimized for transaction processing workloads.

Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.

Autonomous Transaction Processing is built upon Oracle Database, so that all applications and tools that support Oracle Database also support Autonomous Transaction Processing. These tools and applications connect to Autonomous Transaction Processing using standard SQL*Net connections. The tools and applications can either be in your data center or in a public cloud. Other Oracle Cloud services are preconfigured for Autonomous Transaction Processing.

Autonomous Transaction Processing is a completely elastic service. When you get started with Autonomous Transaction Processing, simply specify the number of OCPUs and the storage capacity in terabytes (TBs) for the database. At any time, you can scale, increase or decrease, either the Oracle compute units (OCPUs) or the storage capacity. When you make resource changes for your dedicated Autonomous Transaction Processing deployment, the database resources automatically shrink or grow, without requiring any downtime or service interruptions.

To create and manage dedicated Autonomous Transaction Processing deployments, you use the Oracle Cloud Infrastructure console. To monitor the databases running in these deployments, Autonomous Transaction Processing includes Oracle SQL Developer Web built into each database.

Before You Begin with Autonomous Transaction Processing

Before you begin using Oracle Autonomous Transaction Processing, you should be familiar with Oracle Cloud.

See Getting Started with Oracle Cloud.

Before you create an Autonomous Transaction Processing instance:

  • On Oracle Cloud, purchase a subscription. You cannot create an Autonomous Transaction Processing deployment until you do so.

  • (Optional) if you want to leverage an object store for data loading you need your object store credentials to use with Oracle Autonomous Transaction Processing, including a username and a password. For details on the required credentials, depending on the object store you want to use, see the following:
    • Oracle Cloud Infrastructure Object Storage, the username is your Oracle Cloud Infrastructure user name. The password is your auth token. See Working with Auth Tokens.

    • Oracle Cloud Infrastructure Object Storage Classic, the username is your Oracle Cloud Infrastructure Classic user name and the password is your Oracle Cloud Infrastructure Classic password.

After you create an Autonomous Transaction Processing instance:

  • (Optional) Reset the administrator password:

    When you create an Autonomous Transaction Processing instance you are required to set the administrator password. If you want to change the administrator password or if you need to unlock the administrator account, see Manage the ADMIN Database User.

Key Features of Autonomous Transaction Processing

This section describes key features of Autonomous Transaction Processing, an affordable, feature-rich service in the cloud.

Key Features

  • Managed: Oracle simplifies end-to-end management of the database:

    • Provisioning new databases

    • Growing or shrinking storage and compute resources

    • Patching and upgrades

    • Backup and recovery

  • Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

    • Size the dedicated Autonomous Transaction Processing deployment to the exact compute and storage required

    • Scale the dedicated Autonomous Transaction Processing deployment on demand: Independently scale compute or storage

    • Shut off idle compute to save money

  • Autonomous Transaction Processing supports:

    • Existing applications, running in the cloud or on-premises

    • Connectivity via SQL*Net, JDBC, ODBC

    • Third-party data-integration tools

    • Oracle cloud services: Oracle Analytics Cloud, Oracle GoldenGate Cloud Service, Oracle Integration Cloud Service, and others

  • High-performance features from the latest version of Oracle Database: For more information, see Latest Autonomous Transaction Processing Database Features.

  • High-performance queries and concurrent workloads: Optimized query performance with preconfigured resource profiles for different types of users.

  • Oracle SQL: Autonomous Transaction Processing is compatible with existing applications that support Oracle Database.

  • Database migration utility: Easily migrate from MySQL, PostgreSQL, SQL Server, and other databases.

SQL Developer Autonomous Transaction Processing Support

Using Autonomous Transaction Processing with SQL Developer you can do the following:

  • Connect to a dedicated Autonomous Transaction Processing database

  • Create tables, indexes, and materialized views in a dedicated Autonomous Transaction Processing database

  • Load data into a dedicated Autonomous Transaction Processing database

  • Copy tables to a dedicated Autonomous Transaction Processing database

  • Transfer a schema to a dedicated Autonomous Transaction Processing database

Business Intelligence Tools Support

Autonomous Transaction Processing is compatible with a number of business intelligence and data visualization tools from Oracle and from trusted third parties.

  • Oracle Analytics Cloud

  • Third-party Business Intelligence tools

Typical Workflow for Using Autonomous Transaction Processing

Describes the steps to start using Autonomous Transaction Processing.

Task Description More Information

Create and log in to your cloud account

Provide your information and sign up for an Oracle Cloud Service.

Getting Started with Oracle Cloud

Provision Autonomous Transaction Processing

Create an Autonomous Transaction Processing instance.

Provision Autonomous Transaction Processing

Start the instance

Start and verify that an Autonomous Transaction Processing instance is up and running.

Start Autonomous Transaction Processing

Create database users and obtain security credentials

Create accounts for your users and assign them appropriate privileges. Assign the necessary Autonomous Transaction Processing roles.

Create Database Users

Connect to your database using SQL Developer

Download SQL Developer or another database client tool. Obtain security credentials and connect to your Autonomous Transaction Processing.

Connect to Autonomous Transaction Processing Using Oracle Database Tools

Connect to your database using a database client

Download a database client. Obtain security credentials and connect to your Autonomous Transaction Processing instance.

Connecting to Autonomous Transaction Processing

Scale the database

Use the Oracle Cloud Infrastructure Console to scale an instance to add or remove CPU or storage resources.

Add CPU or Storage Resources

Load data into the database

Use the available tools to load data into the database.

Loading Data into Autonomous Transaction Processing

Monitor the database

Check on the health and performance of the database.

Managing and Monitoring Performance

Manage the database

Check on the day-to-day operation of your service, monitor performance, and review important notifications.

All aspects of the database lifecycle are simplified by the service, including patching and upgrading the database. You can obtain service information including the service and database version from the service console.

Backing Up and Restoring Autonomous Transaction Processing

Security and Authentication in Autonomous Transaction Processing

Autonomous Transaction Processing stores all data in encrypted format in the Oracle Database. Only authenticated users and applications can access the data when they connect to the database.

Connections to Autonomous Transaction Processing are made via SQL*Net. TCP and TCP with Secure Sockets Layer (SSL) security protocols are supported. TCP with SSL uses certificate-based authentication and SSL security protocol. This ensures that there is no unauthorized access to Autonomous Transaction Processing and that communications between the client and server are fully encrypted and cannot be intercepted or altered.

Certificate based authentication uses an encrypted key stored in a wallet on both the client (where the application is running) and the server (where your database is running). The key on the client must match the key on the server to make a connection. A wallet contains a collection of files, including the key and other information needed to connect to your database. For more information on connections to Autonomous Transaction Processing see About Connecting to an Autonomous Transaction Processing Instance.

You do not need to do any manual configuration to encrypt your data and the connections to your database. These are implemented by Autonomous Transaction Processing.

Autonomous Transaction Processing uses strong password complexity rules for all users based on Oracle Cloud security standards. For more information on the password complexity rules see Create Database Users.

You can further restrict connections by specifying a network Access Control List (ACL). By specifying a network ACL a specific Autonomous Transaction Processing database only accepts connections from addresses on the ACL and rejects all other client connections. See Set Access Control List for Autonomous Transaction Processing for more information.

Provision Autonomous Transaction Processing

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

  1. Sign in to your Oracle Cloud Account at cloud.oracle.com.
  2. From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.
  3. Choose your region. See Switching Regions for information on switching regions and working in multiple regions.
  4. Click Autonomous Database.
  5. Choose your Compartment. See Compartments for information on using and managing compartments.
  6. Click Create Autonomous Database.
  7. Select or enter basic information for your Autonomous 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.


      The same database name cannot be used for multiple Oracle Autonomous Database databases in the same tenancy in the same region.
  8. For the workload type, select Transaction Processing.
  9. For the infrastructure type, select Dedicated Infrastructure to deploy your database on a dedicated Exadata infrastructure.
  10. Enter the following to configure your database:
    • CPU Core Count: Specify the number of CPU cores for your Autonomous Transaction Processing database.

    • Storage (TB): Specify the storage you wish to make available to your Autonomous Transaction Processing database, in terabytes.

  11. Choose a container database:
    • Select the compartment.
    • Select the High Availability database container.

      High Availability deploys a clustered database in a single Availability Domain and provides monthly uptime matching your SLA. See Oracle Cloud Infrastructure Service Level Agreement for more information on SLAs.

  12. Set the password for the Autonomous Transaction Processing Admin user. 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.
  13. 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.
  14. Click Create Autonomous Database.

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