Oracle Enterprise and Cloud Manageability Support for Multi-Cloud Environments

As customers roll out multi-cloud application environments, they will need to monitor and manage those applications across those multiple clouds.  Oracle customers who use Oracle Enterprise Manager (EM) and/or Oracle Management Cloud (OMC) can take advantage of the appropriate capabilities offered by these solutions to work across their entire estate, regardless of which deployment model they leverage.

Checkout this Blog post by Dan Koloski, on monitoring Autonomous Database but also Amazon Web Services and Microsoft Azure.

Low Code Meets Autonomous

Today, Oracle is also announcing availability of a rich set of built-in Autonomous Database developer capabilities, including Oracle Application Express (APEX), Oracle SQL Developer Web, and Oracle REST Data Services so developers can quickly develop and deploy new data-driven applications.

Oracle’s industry-leading low-code application development platform, Oracle APEX, enables developers to quickly build scalable and secure enterprise apps with world-class features. Oracle APEX can be used to import spreadsheets and develop a single source of truth web application in minutes, create compelling reports and data visualizations, or build mission-critical data management applications. With Oracle APEX preinstalled and preconfigured in Oracle Autonomous Database, developers can start building applications within minutes.

Oracle also announced availability of Oracle SQL Developer Web, a web interface for working with the Oracle Autonomous Database, enabling developers to easily run queries, create tables, and generate schema diagrams. With native Oracle REST Data Services support, developers can now develop and deploy RESTful services for Oracle Autonomous Database, making it easy to develop modern REST interfaces for relational data.

Read the complete Press Release

New Oracle Autonomous Database Dedicated Deployment Eliminates Roadblocks to Moving Enterprise Databases to the Autonomous Cloud

Press Release New Oracle Autonomous Database Dedicated Deployment Eliminates Roadblocks to Moving Enterprise Databases to the Autonomous Cloud

“Autonomous Database Dedicated enables customers to easily transform from manually-managed independent databases on premises, to a fully-autonomous and isolated private database cloud within the Oracle Public Cloud,” said Juan Loaiza, executive vice president, Mission-Critical Database Technologies, Oracle. “Our Autonomous Database Dedicated service eliminates the concerns enterprise customers previously had about security, isolation, and operational policies when moving to cloud.”

The Dashboard for the Modern Database Fleet

Please checkout this Blog post on Enterprise Manager 13.3 updated Plugins 

“With this new update of Oracle Enterprise Manager, we have introduced support for Oracle Autonomous Database in Oracle Cloud and other capabilities to enable our customers to monitor and manage their hybrid environments using the same tool they’ve been familiar with for years.”  — Wim Coekaerts, Senior Vice President, Engineering, Oracle

Schermafbeelding 2019-05-17 om 10.44.54

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