Oracle Autonomous Data Warehouse Cloud Service (ADW), Part 1: How to provision an ADW Database

Introduction

Juarez Junior
3 min readJan 31, 2019

by Juarez Junior

Introduction

This is the first post in a series, where I explain the summarized steps that show how to use the Oracle Autonomous databases.

The blog posts will explore different hands-on tasks that will allow you to use an Oracle ADW (Autonomous Data Warehouse) Database instance.

Autonomous — No Human Labor, No Human Error, No Manual Performance Tuning

Steps to provision an ADW Database Instance

This first blog post provides a quick step guide on how to provision an instance of ADW.

I assume you’ve heard about the Oracle Autonomous Data Warehouse, or simply ADW.

If not, here’s the quickest description of it: Oracle Autonomous Data Warehouse provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance, and requires no database administration.

Please follow the steps below in order to provision an instance of ADW.

Open the ADW Service console, then click the Create Autonomous Data Warehouse button.

Create ADW

Provide the required information:

COMPARTMENT: <YOUR_COMP_NAME>

DISPLAY NAME: Machine Learning for Sales

DATABASE NAME: MLSalesDB

CPU CORE COUNT: 1

STORAGE (TB): 1

ADW DB information

Provide the password for the security credentials:

USERNAME (READ-ONLY): ADMIN

PASSWORD: <YOUR_ADMIN_PASSWORD>

Password for ADMIN

You can also tag resources (group them) in case you want that approach:

Tagging

Click the Create Autonomous Data Warehouse button. The provisioning process will start. The database state is reported as Provisioning:

Provisioning

In less than 30 seconds, the state will change to Available:

Available

The database provisioning is completed!

It’s impressive to see how easy and fast it is to provision the ADW database, given its powerful features and enterprise, mission-critical grade characteristics, and autonomous mechanisms that use AI and Machine Learning for several database operations tasks.

In case you want to explore the features above, we have a good video:

After that, I’m sure you will want to know more about the technical details of the Autonomous Data Warehouse.

Wrapping up

The next blog post in this series will explain the different options you have to connect to an ADW database. However, I will summarize the steps so that you can be productive with it as fast as possible. Stay tuned!!!

Oracle Developers and Oracle OCI Free Tier

Join our Oracle Developers channel on Slack to discuss Microservices, Java, JDBC, Oracle Cloud Infrastructure, Oracle Database, and other topics!

Build, test, and deploy your applications on Oracle Cloud — for free! Get access to OCI Cloud Free Tier!

Oracle Cloud

--

--