Listing the content of an object storage bucket in OCI from an autonomous database with PL/SQL code


This post explains a specific use case, but it can be used for calling whatever existing OCI REST API fron the database. DBMS_CLOUD DBMS_CLOUD provides all you need to handle requests to OCI REST API's. What you need Create and grab a private and public keys and also grab your tenancy ocid, get help from … Continue reading Listing the content of an object storage bucket in OCI from an autonomous database with PL/SQL code

Building ELZ’s (Enterprise Landing Zones) in OCI


Landing Zone or Enterprise Landing Zone refers to the implementation of cloud building blocks ready to be operated in production workloads by following a set of methodologies and best practices that helps in the adoption of the constantly growing capabilities provided by cloud vendors. Cloud resources SaaS, PaaS and IaaS (XaaS), networking, data and storage: … Continue reading Building ELZ’s (Enterprise Landing Zones) in OCI

Invoking SaaS REST API from an Autonomous Database


Oracle SaaS applications provide, among others, a comprehensive set of REST APIs. Oracle Autonomous Database and the entire family of Oracle database product offerings provide rich and easy-to-invoke API mechanisms. Let's see an example: Creating a sales order With a simple PL/SQL block of code we are showing down here how easy is to create … Continue reading Invoking SaaS REST API from an Autonomous Database

What should you do rather than 100% mimicking legacy approaches when moving to the cloud


The cloud is petty much a motorway, don't drive like with a manual gear car. Photo by Pixabay on Pexels.comPhoto by Pixabay on Pexels.com Architectural simplicity Simply put: keep it simple... Photo by Soloman Soh on Pexels.com Automate things from the beginning Use cloud portals/dashboards for prototyping and implement an IaC with CICD and DevOps … Continue reading What should you do rather than 100% mimicking legacy approaches when moving to the cloud

Because one size doesn’t feet all: Fully versus shared responsibility managed cloud services


One may think that several offerings are wierd, but think in backward compatibility and other reasons that can explain the existence of offerings that brings a more flexible portfolio and covering a wider spectre of Client needs. Oracle managed In a fully managed PaaS, Oracle manages all the underlying infrastructure for you. In this scenario … Continue reading Because one size doesn’t feet all: Fully versus shared responsibility managed cloud services

Calling an Endpoint with Untrusted Certificate from Autonomous Database PL/SQL Program via API Gateway


Oracle Autonomous Database is a cloud Oracle service offered in two infrastructure modes (shared and dedicated) and two types of workloads (OLTP or DSS). Since the user does not have access to the underlying infrastructure, several features are restricted, for instance, you can't manage wallets to add remote endpoint untrusted certificates: the database comes with … Continue reading Calling an Endpoint with Untrusted Certificate from Autonomous Database PL/SQL Program via API Gateway

Sending Messages when DevCS Jobs Fail | OCI Notification Service


OCI Notifications are subscription topics for sending messages to channels like email, rest or pager when things happen. Example In the following example we are sending a notification when the start job of an autonomous database fails, for example if the database is already started. # oci db autonomous-database start --autonomous-database-id ocid1.autonomousdatabase.oc1.eu-frankfurt-1.abtheljr3....6kfsvmxnge2q || { # … Continue reading Sending Messages when DevCS Jobs Fail | OCI Notification Service

Moving a 15-year-old Java 1.4 Application from Oracle AS 10g to WebLogic 12g on Kubernetes in Record Timeframe not Dying in the Intent nor Losing any Line of Code


Not all monoliths should be killed because they are! This is the true story about migration and modernisation of a travel sector solution based on ADF, Java 1.4, Struts, Jac¡vaScript and PHP running on Oracle Application Server 10 and Oracle 10g database. Perhaps old people in town can remember things such as OAS, OC4J, jHeadStart, … Continue reading Moving a 15-year-old Java 1.4 Application from Oracle AS 10g to WebLogic 12g on Kubernetes in Record Timeframe not Dying in the Intent nor Losing any Line of Code

RTO=0 | Regional High Availability and Disaster Recovery WebSite with WebCenter Sites | Traffic Management Steering Policies and DNS Zones Capabilities


Oracle WebCenter Sites (WCS) is a Web Content Management Solution for building enterprise websites that has been out there for 15 yers or so. WCS is based in classic WWW+MW+Database layered architecture. Local high availability is provided by Oracle RAC and Oracle Dataguard in the data layer and WebLogic clusters in the MW layer. At … Continue reading RTO=0 | Regional High Availability and Disaster Recovery WebSite with WebCenter Sites | Traffic Management Steering Policies and DNS Zones Capabilities