X

All Things Database: Education, Best Practices,
Use Cases & More

Provisioning and Connecting to Autonomous Transaction Processing

Sai Valluri
Product Marketing Manager

Introduction

Autonomous Transaction Processing is built on the self-driving, self-securing, and self-repairing Oracle Autonomous Database that uses machine learning to automate database specific features and deliver outstanding performance.  This environment is delivered as a fully managed cloud service running on optimized Oracle Exadata Infrastructure. 

This blog walks you through the steps to get started using the Oracle Autonomous Transaction Processing Database. You will learn how to sign in to Oracle Cloud, Provision a new Database and connect to the database using SQL Developer. All in a matter of minutes without any specialized skills.

Get Access to Autonomous Transaction Processing

After your trial is created you will receive a Welcome email with console details and temporary password to access your account.  You will have the option of choosing the REGION inside of the Cloud Console.

For this lab, if you are in North America, choose the Phoenix data center. For EMEA and APAC regions, please choose the data center in Frankfurt.

Download and Setup the Required Software

You will need SQL Developer installed on your computer. The minimum SQL Developer version that is required to connect to an Oracle Autonomous Transaction Processing database is SQL Developer 17.4.

Windows 64-bit

Install SQL Developer 18.1 using “Windows 64-bit with JDK 8 included” from this link, http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Other platforms

  1. Install JDK 8u161 from this link, http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Install SQL Developer 18.1 for your platform, from this link, http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

 

STEP 1: Sign in to Oracle Cloud Infrastructure console

  • Go to cloud.oracle.com, click Sign In to sign in with your Oracle Cloud account.

  • Enter your Cloud Account Name and click My Services.

  • Enter your Oracle Cloud username and password, and click Sign In.

  • Once you are logged in, you are taken to the cloud services dashboard where you can see all the services available to you.

Step 2: Create an Autonomous Transaction Processing instance

  • Click Autonomous Transaction Processing in the left side menu under services

  • Select Region at the top right corner and click on Create Autonomous Database

  • This will bring up Create Autonomous Database screen where you specify the configurations of the instance
    • Select Autonomous Transaction Processing
    • Choose a Display Name, Database Name, CPU, Core Count and Storage

 

  • Scroll down further to Administrator Credentials. Create Password and click on Create Autonomous Database

 

  • It will take a few minutes to provision the Autonomous Transaction Processing Database

 

  • You can view the Autonomous Transaction Processing Database that you created in your compartment along with your other databases.

 

 

Step 3: Download the secure connection wallet for your provisioned instance

  • Click on the Autonomous Transaction Processing database that you just created
  • Click on DB Connection

 

 

  • This opens up the Database Connection pop-up window. Click on Download to download the client credentials file

 

  • Choose a Password and download the client credentials file

  • The client credentials file will be a .zip file. The client credentials zip file contains the encryption wallet, Java keystore and other relevant files to make a secure TLS 1.2 connection to your database from client applications. Store this file in a secure location, for example your home directory on your machine.

Step 4: Connect to Autonomous Transaction Processing instance using SQL Developer

  • Launch SQL Developer and add Connection. This can be done by clicking on the little green cross at the top left corner. It will prompt you to a pop up where you create the database connection.

 

Enter the following in New database connection

Connection Name: Name for your connection

Username: admin

Password: The password that you created earlier

Connection Type: Cloud Wallet

Role: Default

Configuration File: Click on Browse and select the wallet file you downloaded

Service: 'databasename_high' Database name followed by suffix low, medium or high. These suffixes determine degree of parallelism used and are relevant for a DSS workload.

 

  • Test your connection and save. The Status bar at the bottom left will show Success if it is a successful connection.
  • Click on Connect.

Hooray!!! You now have a secure connection to your Oracle Autonomous Transaction Processing database.

In the last few minutes you signed into your Oracle Cloud trial account, Created your first Autonomous Transaction Processing Cloud instance, Downloaded a wallet and Securely connected to your Database.

For more detailed instructions on how to create a compartment you can visit the Oracle Learning Library page here

Note: Oracle Cloud Infrastructure allows logical isolation of users within a tenant through Compartments. This allows multiple users and business units to share a tenant account while being isolated from each other.

If you have chosen the compartment you do not have privileges on, you will not be able to see or provision instance in it.

More information about Compartments and Policies is provided in the OCI Identity and Access Management documentation here.

Written by Philip Li & Sai Valluri

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha