For this step you will need to create the account in the Oracle Cloud with this link, https://cloud.oracle.com/home . Before you provide the database you need to create a Compartment. If you have not yet created one click on “Identity” and later on “Compartments” under the “Governance and Administration” tab of the menu:
Then click “Create Compartment” if there is none existing : The root compartment is the first compartment created. From it, it is possible to create other compartments by using them as an option in the “Parent Compartment” tab.
Fill in the required fields as the Name of the compartment, any description in the Description field and click on the “Create Compartment” link.
In the above example the name “brunoreis” was chosen as the name of the compartment. In addition, because Oracle recommends creating databases in compartments other than root, a compartment called TECHDATABASKET was created and represented by the image below:
Now with the compartment created we will proceed with the creation of the Autonomous Transaction Processing (ATP) instance. On the Oracle Cloud menu, click Autonomous Transaction Processing:
On the Oracle Cloud menu, click Autonomous Transaction Processing:
Click the Create Autonomous Database button:
In the Create Autonomous Database tab fill in all requested information such as database name, CPU core, storage etc. An important note in this topic is that you can choose the type of workload as an AUTONOMOUS DATA WAREHOUSE or AUTONOMOUS TRANSACTION PROCESSING. However, in this article we are only using the AUTONOMOUS TRANSACTION PROCESSING option.
Make sure you have provided all the information correctly and click on “Create autonomous database”:
During the creation of the database the status will show “Provisioning”:
Once the provisioning is finalized, the status is changed to “Available”:
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)