Category: Oracle Cloud

Managing Autonomous Datawarehouse using oci-curl

Leave a comment

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 oci-curl.sh, 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

Leave a comment

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

Leave a comment

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 →

Into the Oracle Cloud in just some simple steps

1 Comment

Many people I speak on the subject “Cloud” will instantly shout: “AWS, Azure, Google” and only just a few of them will mention “Oracle”. Knowing that many of the companies I visit use the Oracle Database and Middleware, it may be the case that “Unknown makes unloved”….

I just want to spend a few articles on how easy you can get into the Oracle Cloud and get you a bit more familiar with the Cloud Services that you will find there.

Let’s start with signing up to the Oracle Cloud…

Navigate to https://cloud.oracle.com/trial and sign up for a free account.

When your request is processed, you will be provisioned a tenancy in Oracle Cloud Infrastructure. Oracle will send you a Welcome email with instructions for signing in to the Console for the first time. There is no charge unless you choose to Upgrade to Paid from My Services.

Signup to the Oracle Cloud

Disclaimer
Please notice that all statements made by me and information provided on this blog are mine and not necessarily those of Oracle Corporation.