In this article, I’ll demonstrate how to provision a free-tier autonomous database instance and the steps involved in it.

What is Autonomous Database

An autonomous database is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs. Unlike a conventional database, an autonomous database performs all these tasks and more without human intervention.

Prerequisites:

Below are pre-requisites to complete this article:

  1. Oracle Cloud Account. If you don’t have one please refer to this video for creating an Oracle Cloud Free Tier account.

Steps to create free tier Autonomous Database Instance:

  1. Login into the Oracle Cloud account.
  2. From the top left hamburger menu select Oracle Database and click on Autonomous Database
  1. Click on the Create Autonomous Database button as shown in the following screenshot:
  1. Enter the following fields
    • Compartment: Select the existing compartment in which you want to provision an ATP instance.
    • Display name: This is the name of the database.
    • Database name: This name will be used as the permanent ID for this database.
  1. Choose a workload type
    • If you are creating an ADW instance then select Data Warehouse.
    • If you are creating an ATP instance then select Transaction Processing.
  2. Choose a deployment type. For a free tier account, select Shared Infrastructure.
  1. Make sure the Always Free selector is turned on if you are creating a free ATP instance.
  2. Under Configure the database section, select the appropriate database version as 19c or 21c.
  1. Under Create administrator credentials section, create a strong password for ADMIN user.
  2. Under network access – choose the appropriate Access Type.
  1. Choose License Type as license required. Bring Your Own License option will not be enabled for free tier.
  2. Click the Create Autonomous Database button.

Your new ATP instance will be provisioned. The orange ATP box will turn green once it has been provisioned and is available to use.

Now once the instance is provisioned you can connect to it using the web-based UI or you can use SQL Developer to connect the ATP instance.

In order to connect using the SQL Developer application, you need to download the oracle credentials wallet file. For that click on Database actions from the ATP details page and under download, client credentials select the wallet type as Instance Wallet and click on Download Wallet.

Open the SQL Developer software and click on New Database Connection.

Enter the name of the Database and under user info input the user name and password that we had set in step 9 above.

Select the connection type as cloud wallet and under details browse and select the configuration file as the cloud wallet zip file.

Click on the Test button to test the connection. Once the connection is made it will show the status as Success. Then click on Connect.

Voila! Your new Always Free Oracle Autonomous Database is running. You can test by running a simple query like ‘SELECT SYSDATE FROM DUAL’ and can start building your application.

NOTE: ADMIN user is not recommended for normal operations. To create another user from the Autonomous Database click on Database Actions > Administration > database users. You can create a new user and give the required roles.

Request you to subscribe to my YouTube channel for regular updates.

Further readings:

What Is an Autonomous Database?

Oracle Autonomous Database

Creating Oracle Cloud Free Tier account

Oracle Autonomous Transaction Processing