Managing Autonomous Datawarehouse using oci-curl


oci-curl is a bash function provided in the documentation that makes it easy to get started with the REST APIs. You will need to complete a few setup operations before you can start calling it.

Start by copying the function code from the documentation into a shell script on your machine. I saved it into a file named, for example.

You will see the following section at the top of the file. You need to replace these four values with your own.

TODO: update these values to your own
  local tenancyId= "ocid1.tenancy.oc1..aaaaaaaaba3pv6wjqae5f15p2b2m2yt2j6rx32uzr4h25vqstifsfdsq";
  local authUserId= "ocid1.user.oc1..aaaaaaaatvwc5j6aqzjcaty5eqbb6qt2jvpkanghtgdaqedqw3rynjq";
  local keyFingerprint="20:3b:97:13:1c:5b:0d:d3:50:4e:c5:3a:34";
  local privateKeyPath="/Users/someuser/.oci/oci_api_key.pem";

Continue reading


Setup a SQL*Developer connection to an Autonomous Database

In this article I will show you how easy it is to connect to an Autonomous Transaction Processing Database using SQL*Developer

Note that for this I downloaded the latest version of SQL*Developer (18.3) from Oracle Technology Network.

While connected to the Oracle Cloud Infrastructure console, from the navigation menu select Autonomous Transaction Processing

From the overview page select the database you want to connect


Continue reading

Create your first Autonomous Transaction Processing Database

In this article I will show you how easy it is to create an Autonomous Transaction Processing Database.

Create your first Autonomous Database

Oracle Cloud Infrastructure’s Autonomous Transaction Processing Cloud Service is a fully managed, preconfigured database environment. You do not need to configure or manage any hardware, or install any software. After provisioning, you can scale the number of CPU cores or the storage capacity of the database at any time without impacting availability or performance. Autonomous Transaction Processing handles creating the database, as well as the following maintenance tasks:

  • Backing up the database
  • Patching the database
  • Upgrading the database
  • Tuning the database

I assume you have signed up for an account in the Oracle Cloud, if not see Into the Oracle Cloud in just some simple steps

Continue reading