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.

As a service 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 the 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.

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 TB's for the database. At any time, you can scale, increase or decrease, either the OCPUs or the storage capacity. When you make resource changes for your Autonomous Transaction Processing, the database resources automatically shrink or grow, without requiring any downtime or service interruptions.

Autonomous Transaction Processing includes a cloud-based service console for managing the service (for tasks such as creating or scaling the service), and monitoring the service (for tasks such as viewing the recent levels of activity on the database).

Autonomous Transaction Processing also includes the following:

  • Oracle Application Express (APEX): a low-code development platform that enables you to build scalable, secure enterprise apps with world-class features.
  • Oracle REST Data Services (ORDS): a Java Enterprise Edition based data service that makes it easy to develop modern REST interfaces for relational data and JSON Document Store.
  • Oracle SQL Developer Web: a browser-based interface of Oracle SQL Developer.
  • Oracle Machine Learning: a cloud-based notebook application which provides simple querying, data-visualization, and collaboration capabilities. The notebook is designed to be used alongside other business intelligence applications.

The following figure shows the Autonomous Transaction Processing architecture.

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, sign up for a free trial subscription or 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.

    • Amazon S3, the username is your AWS access key ID and the password is your AWS secret access key. See AWS Identity and Access Management.

    • Azure Blob Storage, the username is your Azure storage account name and the password is an Azure storage account access key. See About Azure storage accounts.

  • (Optional) Create a bucket for cloud storage manual backups:

    If you want to manually back up Autonomous Transaction Processing to cloud storage you must associate an instance with a cloud storage backup location. For information on defining your Oracle Cloud Infrastructure Object Storage and creating the bucket for manual backups, see Configure Manual Backups on Autonomous Transaction Processing.

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 Administrator Account on Autonomous Transaction Processing.

  • (Optional) Add Oracle Machine Learning users. See: Create 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 Autonomous Transaction Processing to the exact compute and storage required

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

    • Shut off idle compute to save money

  • Auto scaling: Enable auto scaling to allow Autonomous Transaction Processing to use more CPU and IO resources automatically when the workload requires it:

    • Specify the number of OCPUs for Autonomous Transaction Processing workloads.

    • Enable auto scaling to allow the database to use up to three times more CPU and IO resources depending on workload requirements.

    • Enable auto scaling when you provision an Autonomous Transaction Processing instance or using Scale Up/Down on the Oracle Cloud Infrastructure Console.

  • 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 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.

  • Built-in web-based data analysis tool: Web-based notebook tool for designing and sharing SQL based data-driven, interactive documents.

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

Simple Cloud-based Data Loading

Autonomous Transaction Processing provides:
  • Fast, scalable data-loading from Oracle Object Store, Azure Blob Storage, AWS S3, or on-premises data sources.

SQL Developer Autonomous Transaction Processing Support

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

  • Connect to Autonomous Transaction Processing

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

  • Load data into Autonomous Transaction Processing

  • Copy tables to Autonomous Transaction Processing

  • Transfer a schema to Autonomous Transaction Processing

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

Quickstart Tutorial: Getting Started and Provisioning an Autonomous Database

Start the database

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 Users with Autonomous Transaction Processing

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.

Starting, Stopping, and Scaling Autonomous Transaction Processing

Load data into the database

Use the available tools to load data into the database.

Loading Data with Autonomous Transaction Processing

Monitor the database

Check on the health and performance of the database.

Managing and Monitoring Performance of Autonomous Transaction Processing

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

Clone the database

Use the Oracle Cloud Infrastructure console to clone a database. You can choose to clone either the full database or only the database metadata.

Cloning a Database with Autonomous Transaction Processing

Use Oracle Machine Learning with Autonomous Transaction Processing

Oracle Machine Learning provides a notebook style application designed for advanced SQL users and provides interactive data analysis that lets you develop, document, share, and automate reports based on sophisticated analytics and data models.

Key features of Oracle Machine Learning:

  • Allows collaboration among data scientists, developers, business users

  • Leverages the scalability and performance of Oracle Platform and its Cloud Services

To use Oracle Machine Learning with Autonomous Transaction Processing you need to add or create Oracle Machine Learning users and access Oracle Machine Learning:

  • OML User Management lets the Admin (user with administrative privileges) create and modify Oracle Machine Learning user accounts. See Create and Update User Accounts for Oracle Machine Learning for details on accessing OML User Management.

  • OML Application – application users access Oracle Machine Learning to create, view, and share notebooks for data analytics, data visualization, and other Oracle Machine Learning tasks. Users access Oracle Machine Learning by clicking the Oracle Machine Learning Home icon on the User Administration page or from the account details mailed to a new user. See Work with Oracle Machine Learning for Data Access, Analysis, and Discovery for details on using the OML application.

Build Reports and Dashboards with Analytics in Autonomous Transaction Processing

Working with Oracle Analytics Cloud

You can use Oracle Analytics Cloud with Autonomous Transaction Processing. Use Oracle Analytics Cloud to select interactive visualizations and automatically create advanced calculations to reveal the insights in your data.

For more information, see Using Oracle Analytics Cloud with 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.

All connections to Autonomous Transaction Processing use certificate-based authentication and Secure Sockets Layer (SSL). 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 Users with Autonomous Transaction Processing.

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 with 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.

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • Open the Oracle Cloud Infrastructure console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.

  1. Choose your region. See Switching Regions for information on switching regions and working in multiple regions.
  2. Click Create Autonomous Database.
  3. Provide basic information for the Autonomous Database.
    • Choose a compartment. See Compartments for information on using and managing 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 Oracle Autonomous Database databases in the same tenancy in the same region.
  4. Choose a workload type. Select the workload type for your database from the choices:
    • Data Warehouse

    • Transaction Processing

    To create an Autonomous Transaction Processing instance select Transaction Processing.

  5. Choose a deployment type.
    • Serverless

      Run Autonomous Database without provisioning infrastructure.

    • Dedicated Infrastructure

      Run Autonomous Database on dedicated Exadata infrastructure.

    Select Serverless for a Serverless deployment. See Provision Autonomous Transaction Processing for steps for provisioning on Dedicated Infrastructure.

  6. Configure the 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.

    • Auto Scaling Select to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand. See Use Auto Scaling for more information.

  7. Create administrator credentials. 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 Users with Autonomous Transaction Processing.
    • Username This is a read only field.

    • Password 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 Users with Autonomous Transaction Processing.

    • Confirm password Enter the same password again to confirm your new password.

  8. Choose a license type
    • Bring Your Own License

      My organization already owns Oracle database software licenses. Bring my existing database software licenses to the database cloud service (details).

    • License Included

      Subscribe to new database software licenses and the database cloud service.

    (Optional) Click Show Advanced Options to enter additional options.

    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.

  9. Click Create Autonomous Database.

On the Oracle Cloud Infrastructure console the State shows Provisioning... until the new Autonomous Transaction Processing database is available.

Quickstart Tutorials

Provides links to the Autonomous Transaction Processing quickstart tutorials.

Quickstart Tutorial: Getting Started and Provisioning an Autonomous Database

This tutorial shows you how to log in to the Autonomous Transaction Processing console, create an instance, and create a user.

Quickstart Tutorial: Connecting SQL Developer to Autonomous Transaction Processing

This tutorial shows you how to connect SQL Developer to a database in Autonomous Transaction Processing.

Quickstart Tutorial: Loading Your Data

This tutorial shows you how to load data from an Oracle Object Store into a database in Autonomous Transaction Processing.