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.
Oracle Application Express (APEX) is now generally available on Oracle Autonomous Database Cloud. The enormous benefits of a fully-managed and autonomous database cloud service, combined with an industry-leading low code platform to quickly develop and deploy applications, offers customers unparalleled capabilities.
Read more on this announcement on Joel Kallman’s blog
Read the next step in database development and Oracle Autonomous Database. Now both the Autonomous Data Warehouse and the Autonomous Transaction Processing options include SQL Developer Web and REST Data Services for RESTful Services and SODA.
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
“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.”
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
In this post I show you how easy it is to install a 3rd party application like Swingbench (credits to Dominic Giles) on a Compute Instance within the Oracle Cloud and connect to an Autonomous Transaction Processing Database.
From the Cloud Infrastructure Console menu select Compute > Instances
Press [Create Instance]
The Oracle Public Cloud allows users to create an Autonomous Database to store application-data.
When connected to the Oracle Cloud Infrastructure Console you have an insight view on the database details, the ability to scale up/down, stop and start the database and to activate the Service Console.
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";
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