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.
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
STEP 1: Sign in to Oracle Cloud Infrastructure console
Step 2: Create an Autonomous Transaction Processing instance
Step 3: Download the secure connection wallet for your provisioned instance
Step 4: Connect to Autonomous Transaction Processing instance using SQL Developer
Enter the following in New database connection
Connection Name: Name for your connection
Password: The password that you created earlier
Connection Type: Cloud Wallet
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.
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
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