Managing Autonomous Datawarehouse using oci-curl

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..aaaaaaaaba3pv6wkcr4jqae5f15p2b2m2yt2j6rx32uzr4h25vqstifsfdsq";
  local authUserId= "ocid1.user.oc1..aaaaaaaat5nvwcna5j6aqzjcaty5eqbb6qt2jvpkanghtgdaqedqw3rynjq";
  local keyFingerprint="20:3b:97:13:55:1c:5b:0d:d3:37:d8: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

Into the Oracle Cloud in just some simple steps

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.

EM13.3 is here – get your copy today

Today Oracle announced the release of Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0).

Oracle Enterprise Manager 13.3 introduces many new features for database, cloud and middleware management, such as:

  • Support for monitoring and management of Oracle Database 18c
  • Onboarding non-cloud DB/PDB to DBaaS Cloud
  • Relocation of service instances across cloud pools
  • PDB upgrade using Fleet Maintenance
  • Modernization of UI stack for key database performance diagnostics capabilities like ASH Analytics and Real-time SQL Monitoring
  • Support for Oracle Identity Management 12.2.x Management
  • Support for Cloning of SOA or OSB-based Domains Versioned 12.2.1.3 and later
  • JVMD enhancements to support large scale deployments & ALL request monitoring
  • Uptake of JDK 7u171 and WLS April 2018 CPU for enhanced security

You can get your copy here OTN.

For new feature please check New Features In Oracle Enterprise Manager Cloud Control 13c.