How to Create an Oracle Database on Oracle Cloud

Introduction

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.

atp1.png

The Create Autonomous Database screen will then be displayed. To start with, specify a Display name and a Database name.

atp2.png

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 Shared Infrastructure.

atp3.png

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.

atp4.png

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.

ap5.png

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.

atp6.png

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.

atp7.png

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.

atp8.png

After a few seconds, the SQL Developer Web Login page will be displayed.

atp9.png

At this point, enter the username as admin and the password that you specified when creating the instance to log into SQL Developer Web.

atp10.png

Executing a simple command such as

select * from v$version

will show that the database is up and running and ready for use.

Conclusion

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.

Credits

Photo by Susan Yin on Unsplash

No Comments Yet