This lab walks you through the steps to get started using the Oracle Autonomous Transaction Processing Database on Oracle Cloud Infrastructure (OCI). You will provision a new database.
Go to the ATP menu:
Check you are in the root compartment that is fine for testing.
Compartments are a logical separation of resources to attach roles and permissions. It will make possible to create your team structure in compartments so you know who manage what resources. Not necessary at this stage.
And click in Create Autonomous Database button.
You can leave the compartment as it is. It would say something like <tenancy_name> (root). Write the Display name and Database name.
Make sure you select Transaction Processing and Shared Infrastructure.
You can select Always Free configuration to start enjoying your Free Autonomous Database.
CPU and Storage are good with default values, the same for the database version.
Auto scaling you can leave it off but it is a nice feature as the ATP database will scale if the workload is increasing and scale down automatically if the workload reduces. Zero downtime during the process. It's cool, isn't it?
Leave Allow Secure Access From Everywhere for the workshop and Bring your Own License (BYOL). You will upload your license later when needed.
Click Create Autonomous Database button.
After few seconds you will have your new Autonomous Database up and running.
Look around the details and get familiar with the buttons and tabs on this page.
Your database is the most important part of your system. A security issue here can be catastrophic.
There are a lot of tools to help you with security like Oracle Data Safe to assess your overall configuration.
Autonomous Databases provides a TLS 1.2 encrypted secure connectivity for applications. In fact, using a secure encryption wallet is the only way to connect to an ATP service instance, ensuring every connection to your database is secure, regardless how it gets routed.
Let's download that Wallet file and store it in your machine as we will use it later.
Click in DB Connection button.
Click Download Wallet button. Notice the TNS Name value at the bottom of this popup window as well.
Set a password for the zip file and click Download button.
The download will start and you can close the popup window.
Time to run some SQL code. Traditionally you would have to download the software and configure the connection. With Oracle Cloud and Autonomous Database you have another option.
SQL Developer is available on the web console. Click on Service Console button.
It will open another browser tab with all the service console tools. You will see some metrics. For the moment, click on Development menu on the left.
Click on SQL Developer Web tile
A new browser tab will open to log-in on SQL Developer Web. The Username is ADMIN and the Password is the one during creation time (not the one for the Wallet zip file).
Run the following SQL query SELECT banner FROM v$version.
You just created an Autonomous Database with the latest features of Oracle Databases.
You also downloaded the file needed to establish connections from your SQL Developer or programming language.
Finally, you run SQL Developer Web to run queries without installing or configuring anything.
Congratulations, you are ready for the next Lab!