Autonomous Database: Creating an Autonomous Data Warehouse Instance

In my previous post I have shown how quick and easy it is to create an Oracle Autonomous Transaction Processing instance. In this post I want to show that the same applies for an Oracle Autonomous Data Warehouse, short ADW, instance. As a matter of fact, both services are running on the very same Oracle Autonomous Database infrastructure so you will see that the steps are the very same as with Autonomous Transaction Processing.

Just like with ATP, you can try ADW yourself today via the Oracle Free Cloud Trial.

tl;dr

To create an instance you just have to follow these three simple steps:

  1. Log into the Oracle Cloud Console and choose “Autonomous Data Warehouse” from the menu.
  2. Click “Create Autonomous Data Warehouse
  3. Specify the name, the amount of CPU and storage, the administrator password and hit “Create Autonomous Data Warehouse

Continue reading “Autonomous Database: Creating an Autonomous Data Warehouse Instance”

Autonomous Database: Creating an Autonomous Transaction Processing Instance

In this post I’m going to demonstrate how quick and easy one can create an Autonomous Transaction Processing, short ATP, instance of Oracle’s Autonomous Database Cloud Services. Oracle’s ATP launched on the 7th of August 2018 and is the general purpose flavor of the Oracle Autonomous Database. My colleague SQLMaria (also known as Maria Colgan 😉 ) has already done a great job explaining the difference between the Autonomous Transaction Processing and the Autonomous Data Warehouse services. She has also written another post on what one can expect from Oracle Autonomous Transaction Processing. I highly recommend reading both her articles first for a better understanding of the offerings.

Last but not least, you can try ATP yourself today via the Oracle Free Cloud Trial.

Now let’s get started. Provisioning an ATP service is, as said above, quick and easy.

tl;dr

To create an instance you just have to follow these three simple steps:

  1. Log into the Oracle Cloud Console and choose “Autonomous Transaction Processing” from the menu.
  2. Click “Create Autonomous Transaction Processing
  3. Specify the name, the amount of CPU and storage, the administrator password and hit “Create Autonomous Transaction Processing

Continue reading “Autonomous Database: Creating an Autonomous Transaction Processing Instance”

Autonomous Database Blog series

Oracle has just released the Oracle Autonomous Transaction Processing Cloud Service. This is the second service of the Oracle Autonomous Database Cloud Services, after Oracle Autonomous Data Warehouse Cloud Service which launched earlier this year. I have been asked to produce some collateral for the new offerings which will surface here as well as on other sites. I hope they will be interesting for you and give you some insights into the technologies, how they work, and how you can get the most out of them.

To follow along with the code samples that you will see, I have created a new GitHub repo: https://github.com/gvenzl/Oracle-AutonomousDatabase
If you are on GitHub, feel free to give it a star and fork away. In the case that you are not, you will still be able to browse and download all code samples.

All blog posts will be marked with the tag Oracle Autonomous Database to make it easier for you to filter them.

If you are interested and want to read and hear even more on Oracle Autonomous Database you should also follow SQLMaria‘s blog: https://sqlmaria.com/category/autonomous-database/