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. Oracle Analytics Cloud and 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 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 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:

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: Provisioning Autonomous Transaction Processing

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.

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

To access Oracle Machine Learning User Management from Autonomous Transaction Processing Service console:
  1. From the Autonomous Transaction Processing instance details page, click Service Console.
  2. Click Administration.
  3. Click Manage Oracle ML Users.

    This shows the Oracle Machine Learning User Administration page.

    After you create user accounts, the users can access Oracle Machine Learning. See Create and Update User Accounts for Oracle Machine Learning for more detailed information on creating users.

  4. You access the Oracle Machine Learning application by clicking the Oracle Machine Learning Home icon on the User Administration page or from the account details mailed to a new user.

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

Shows you the 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. Choose your Compartment. See Compartments for information on using and managing compartments.
  3. Click Create Autonomous Database.
  4. In the Create Autonomous Database dialog, enter the following:
    • Workload Type: Select the workload type for your database:

      Select Autonomous Transaction Processing

    • 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 concurrently for both an Autonomous Data Warehouse and an Autonomous Transaction Processing 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.

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

    • License Type: The type of license you want to use for the Autonomous Database.

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

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

  5. 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.
  6. Click Create Autonomous Database.

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

Quickstart Tutorials

Provides links to the Autonomous Transaction Processing quickstart tutorials.

Quickstart Tutorial: Provisioning Autonomous Transaction Processing

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.