One of the features of Oracle Cloud is the ability to create hosted Oracle Databases. The Always Free Tier provides users with the ability to create up to 2 Autonomous Databases. There are two types of these available with Oracle Cloud depending upon your needs.
Autonomous Transaction Processing (ATP)
"Configures the database for a transactional workload, with a bias towards high volumes of random data access."
Autonomous Data Warehouse (ADW)
"Configures the database for a decision support or data warehouse workload, with a bias towards large data scanning operations."
In this post, I'm going to show how to create an ATP instance, although the procedure is almost identical for creating a ADW instance.
Creating an ATP Database
To get started log into Oracle Cloud upon which you will be presented with the Oracle Cloud Console.
From the console, select the
Create an ATP database option.
Create Autonomous Database screen will then be displayed. To start with, specify a
Display name and a
Next, we can define whether we wish to create an ATP or a ADW database. ATP is selected as the default. In addition to the database type, we can select whether to host on Shared or Dedicated infrastructure. For most cases, this will probably be
Configuring the database is the next step. This allows us to define how many OCPUs, how much storage are given to the database and whether the database auto scales. One nice feature here is the toggle to
Show only Free configuration options. When this is selected, 1 OCPU is selected along with 0.02 TB data that does not autoscale.
The next stage in the wizard is to specify security details for the database. This allows the database password (the user defaults to
ADMIN and cannot be changed) to be specified along with configuring any access control rules.
For this demonstration, enter a password, but do not add any access control rules. This will create the database instance so that it can be accessed from anywhere on the internet, but since this is just a demo that is ok. For a production database, you would need to specify which IP addresses would have access to the database.
Finally, we must choose whether to use our own software license or use the included license.
That's all the basic configuration that is needed. Selecting the
Create Autonomous Database button will now start the provisioning process.
On the next page, we see details of the database and the provisioning status.
The status icon on the left will initially be orange and indicate that the database is being provisioned. After a few seconds, the icon will turn green indicating that the instance is available.
Checking the database availability
Now that we've deployed a new database instance, we can easily test that it works by connecting via SQL Developer Web. This is the easiest way to connect to the instance to allow us to execute SQL statements.
Click on the
Tools tab, and then select the
Open SQL Developer Web button.
After a few seconds, the SQL Developer Web Login page will be displayed.
At this point, enter the username as
admin and the password that you specified when creating the instance to log into SQL Developer Web.
Executing a simple command such as
select * from v$version
will show that the database is up and running and ready for use.
In this article, we've seen how Oracle Cloud allows customers to provision databases ready for both Transaction Processing and Data Warehouse workloads. We briefly touched on security and how by default the database is open to access from all IP addresses, but this can be locked down by adding 1 or more Access Control Rules. Finally, we saw how to quickly, and easily, connect to the database using SQL Developer Web.