Since we provide support for several clients in OCI, we regularly need to login into different OCI-tenancies. How nice would it be to have Single Sign-On (SSO) functionality between these different customer environments. Just 1 credential for all environments, granting and revoking access a lot easier. Also no need to […]
Oracle Cloud
Oracle Analytics Cloud, Oracle Big Data Service, Oracle Big Data SQL Cloud Service, Oracle Cloud Infrastructure, Data Catalog, API Gateway, Blockchain Platform, Container Engine for Kubernetes, Container Registry, Functions,
Oracle MySQL Database Service, Oracle NoSQL Database Cloud Service,
Oracle Visual Builder, Autonomous Data Warehouse, Autonomous JSON Database, Autonomous Transaction Processing
Create OCI Function running a Playwright scenario
TL;DR – How to create a Function on Oracle Cloud Infrastructure that uses the Playwright library for running headless browser scenarios, for example for Web UI Health Check and Performance Monitoring, for tactical integration and simple RPA and for web based reporting. The article shows a custom Docker container image […]
First code and cli free steps with Oracle Database 21c in Oracle Cloud
Oracle Database 21c has been released – for now only in the cloud. Starting to explore – that is what we call playing with it – it easy and free of any charge in the OCI Always Free Tier that includes two Oracle Database instances that now can be 21c […]
OpenAPI Support in Oracle API Gateway
Today I read the announcement of OpenAPI (fka Swagger) support in API Gateway on OCI. I was wondering what that entailed and I decided to try it out. In short, this support means that an API definition can be uploaded to API Gateway, is validated for correctness and can be […]
Run SonarQube on OCI– 10 minutes to get going using Docker Container on always free VM
In this article I want to describe how I run a SonarQube instance (that I intend to use from my automated CI/CD pipeline) on OCI, using a simple VM and a simple Docker container image. The VM gets a public IP address and I need to SSH into it in […]
Oracle Functions–Mental Picture vs. Physical Reality
Oracle Functions are the Functions as a Service (or FaaS) offering on Oracle Cloud Infrastructure. Functions are the serverless, stateless execution engines that play such an important role in cloud native applications. Functions handle requests and events, contributing to live application behavior, streaming activities and integrations. Functions are also used […]
Demystifying Blockchain for Enterprise – Realizing its potential?
The goal of this series of blogs – Demystifying Blockchain for Enterprise – is to take away the cloudiness and complexity around blockchain. In this second part I will explain where in my opinion the potential of the technology is within certain industries and explore what kind of problems blockchain in the enterprise space can solve.
Demystifying Blockchain for Enterprise – What’s the buzz?
The goal of this series of blogs – Demystifying Blockchain for Enterprise – is to take away the cloudiness and complexity around blockchain. In this first part I will explain the technology behind enterprise blockchain, using of smart contracts as decentralized application, and how it compares to a traditional database.
Oracle Cloud Infrastructure – Vault Service to generate, manage and encrypt & decrypt using Keys
The Vault service lets you create vaults in your tenancy as containers for encryption keys and secrets. Vaults are logical entities where the Vault service creates and durably stores keys and secrets. The type of vault you have determines features and functionality such as degrees of storage isolation, access to […]
Example of OCI Function as Resource Principal [enabled] to invoke OCI services
![Example of OCI Function as Resource Principal [enabled] to invoke OCI services](https://technology.amis.nl/wp-content/uploads/2020/06/image-18-768x285.png)
Resource Principal is an OCI resource that through its membership of a Dynamic Group and permissions granted through policies to the Dynamic Group is given access to OCI resources and services. Examples of Resource Principals are Function and API Gateway. A Function that is resource principal enabled can for example […]
Reading Query Parameters in GET requests to Project Fn Functions (and Oracle Functions as a Service)
TLDR: query parameters can be retrieved from the Fn-Http-Request-Url header in the ctx parameter passed by Fn to the Node function handling the request; using url.parse() on that header retrieves the url query parameters Project Fn is an open source container native serverless framework. Project Fn provides a runtime […]
A Quick how-to RMAN backup to OCI Object Storage
This is a quick how-to article on setting up RMAN to backup to Object Storage on OCI. This is applicable when you build your on Oracle database on an OCI instance, or when you have a database on-premise you wish to backup to the (OCI) cloud.
Migrating an old (10.2.0.4) database to Oracle Cloud with minimal downtime
Unlike most of our posts this post will contain almost no code or examples. But it hopefully will help somebody who ends up to be in the same situation we landed on: migrating data from very old versions to a new environment. Recently we were tasked with the migration of […]
Mapping Azure and Oracle Cloud Infrastructure core concepts – Part One
All major public clouds are organized in similar ways. However, terms used for certain similar constructs can be (quite) different, or the same terms are used for quite different constructs. This article attempts to outline some of the most relevant concepts for both Azure and Oracle Cloud Infrastructure and to […]
(Many ways) How to upload files into Oracle Cloud Infrastructure – Cloud Shell
Oracle Cloud Infrastructure Cloud Shell is VM that runs inside OCI -to be used for manipulating OCI resources using various means, including OCI CLI, Terraform and Ansible. We may want to be able to get files into Cloud Shell – scripts, source code, Infrastructure as Code and more. There are […]
Install SQLcl on Oracle Cloud Infrastructure Cloud Shell and make it work against an Autonomous Database
Cloud Shell on Oracle Cloud Infrastructure is a versatile management and development environment to access and manage Oracle Cloud Infrastructure resources. Cloud Shell comes with many tools and runtime out of the box (or rather inside the box) including OCI CLI, Java and SQL*Plus. However, the Oracle SQL Developer Command […]
Connecting SQL*Plus in Cloud Shell to an Autonomous Database
Objective of this article: connect SQL*Plus in Cloud Shell to an Autonomous Database instance (in a free tier – in the same or a different cloud tenancy) The starting situation: I have an autonomous database instance running somewhere in Oracle Cloud Infrastructure. I have Cloud Shell as a versatile management […]
Access OCI OKE Kubernetes Dashboard locally through Cloud Shell Proxy and ngrok
This article tells you how to access the Kubernetes Dashboard on top of an Oracle Cloud Infrastructure OKE Cluster Instance from a browser – without locally installing kubectl. This trick uses OCI Cloud Shell to run kubectl to proxy to the dashboard application running inside the K8S Cluster and it […]
Oracle Cloud Infrastructure Cloud Shell – integrated OCI CLI, kubectl, terraform, SQL Plus, Docker and Maven
Cloud Shell in Oracle Cloud Infrastructure is a free browser based command line tool for various types of interactions within your OCI Tenancy. When you start Cloud Shell, a command line is opened in your browser. You are in a Linux environment (Oracle Linux 7.7) that runs within the OCI […]
Getting started with NoSQL Database Service on Oracle Cloud Infrastructure
This morning I discovered a new entry in the menu on my Oracle Cloud Infrastructure Tenancy (on Ashburn, USA): the NoSQL Database service had been added overnight. The service offers a key-(schema-less) document store. It also supports ACID transactions, SQL on JSON documents, joins across tables, structured tables and if […]
Very first steps in Oracle Cloud Infrastructure as Code with Terraform
Resources in Oracle Cloud Infrastructure can be managed through the console – the browser based UI. That works great but requires manual steps – no automation – that take time and easily go wrong (and become extremely boring over time). Additionally, it is a rather individualistic way of working that […]
Secure browsing using a local SOCKS proxy server (on desktop or mobile) and an always free OCI compute instance as SSH server
Oracle provides several services as ‘always free’. In contrast to Azure and Amazon, these include compute instances which remain ‘forever’ free to use. Although there are some limitations on CPU, disk, network resources, these instances are ideal to use as a remote SSH server and with a little effort a […]
Use OCI Monitoring, Alarms and Notifications for Your Own Custom and Functional Metrics
In earlier articles, I have discussed features in Oracle Cloud Infrastructure for monitoring metrics published by virtually all OCI services. These metrics get published when functions are invoked, files are written, the API Gateway handles a request, events are published, a user is created and a network transfers a packet. […]
Run Always Free Docker Container on Oracle Cloud Infrastructure
In this article, I want to show how you can very quickly run a Docker container for free on Oracle Cloud Infrastructure – using a VM in the Always Free Tier of OCI. As an example, I will run an NGINX container image and access that from a client over […]
Oracle Cloud Infrastructure Resource Monitoring – Alarm triggers Notification when Metrics satisfy Condition
Oracle Cloud Infrastructure gathers metrics from all OCI resources. These metrics can be visualized and analyzed with the Metrics Explorer. And Alarms can be defined with rules evaluating the metrics that publish to a Notification Topic to signal a situation of interest. Subscriptions can be defined on these Notification Topics, […]
Somewhat Stateful Serverless Functions on Oracle Cloud Infrastructure – Implementing a DIY Cache
We call them serverless and we consider them stateless. Functions on Oracle Cloud Infrastructure (and on other cloud platforms). Of course they are neither. They run on servers. And they can carry some state, though largely opportunistic and not reliably. Functions on OCI run inside a container. The container is […]
Asynchronous Function Calls through API Gateway on Oracle Cloud Infrastructure
In a recent article, I described how serverless Functions on Oracle Cloud Infrastructure can invoke each other: synchronously and asynchronously. Although asynchronous calls are the desired state, such calls currently are possible only with quite a bit of hassle – using a Stream for queuing asynchronous requests and a Listener […]
OCI Serverless Functions invoking other Functions – synchronous and asynchronously through API Gateway and Streaming
OCI allows for cloud native application development, using facilities such as serverless functions, a light weight API gateway, a streaming service for asynchronous communication based on event messaging and built-in monitoring. In previous articles, I have gone over several aspects of serverless functions and API Gateways to create and expose […]
Using OCI Monitoring Healthchecks to Schedule execution of Serverless Functions on Oracle Cloud Infrastructure
Execution of scheduled jobs based on a time schedule is a frequent requirement. Jobs on Oracle Cloud Infrastructure are often implemented using cloud native, serverless Functions – that can be exposed through (public) HTTP endpoints on an API Gateway. I recently published an article describing how execution of functions can […]
Oracle Cloud Streaming Service – Scalable, Reliable, Kafka-like Event service on OCI
Oracle Cloud Infrastructure offers the Streaming service. This service is easily described as a Kafka-like fully managed event platform for high volume streams of data that can be processed in real or delayed time in a durable, reliable way. And from the documentation: “Streaming can be used for messaging, ingesting […]
Deprecated: (!First Steps) with Oracle Cloud’s Pub/Sub Service: Oracle Messaging Cloud Service
Fire and forget messaging is a powerful concept. Asynchronous, decoupled communication is key to scalability and independence of services. Oracle Cloud provides a pub/sub solution called Oracle Messaging Cloud Service. This is an HTTP based publish and subscribe mechanism for asynchronous communication – based on persistent messages and durable subscriptions. […]
Publish Oracle Function for Reading and Writing Object Storage Files through OCI API Gateway
The objective for this article is to show you how to get to the point where two routes are available on an API Gateway on Oracle Cloud Infrastructure that allow easy writing to a file on Object Storage and easy retrieval of such as file. Writing files is obviously useful […]
Oracle Cloud Infrastructure – Leveraging API Gateway as Read Only Cache from serverless Function
This article demonstrates a set up that is probably mainly of theoretical interest or maybe useful in demonstrations. I describe how we can invoke an OCI serverless Function through the API Gateway and ask the serverless function for values that are read from a [read only] cache. This cache is […]
Oracle Cloud API Gateway – Using an Authorizer Function for Client Secret Authorization on API Access
The objective in this article: create a simple Authorizer Function that checks the Client Secret passed in API calls and allows and denies requests based on whether the correct Client Secret is included. The Authorizer Function does a little more than simply accept or deny: in case of accept it […]
Oracle Cloud Serverless Functions unleashed: exposing OCI Functions through API Gateway
Oracle Cloud Infrastructure API Gateway makes it possible to expose OCI Functions on public endpoints that do not require complex signed HTTP requests. Any function that should be easily publicly accessible can be given such easy access. By creating an API Deployment on an API Gateway and associating a route […]
Scheduling Oracle Cloud Function execution
Functions on Oracle Cloud are an important element in any cloud native application architectures. Functions are typically small, well contained and fairly independent pieces of logic to carry out specific tasks. These tasks can be executed upon reception and handling of HTTP requests – a very common use case – […]
My Quick Start with Oracle Functions in Fresh OCI Tenancy
This article is fairly rough log of the steps I went through to get going on Oracle Cloud Serverless Functions. It is mainly intended to provide a note to myself, for future reference. However, my description could prove useful to you – the reader. My steps to get going are […]
My first steps with Oracle Cloud API Gateway – the stock response
The API Gateway service on Oracle Cloud Infrastructure went live very recently – read my overview article of what API Gateway entails. In brief: API Gateway is a reverse proxy that exposes HTTP endpoints on which external (or internal) clients can make requests. API Gateway can handle these requests: authorize, […]
Introducing Oracle Cloud API Gateway – the light weight public or private router to public and private OCI endpoints
Two days ago, the API Gateway service on Oracle Cloud Infrastructure went live – read the announcement. This is a crucial component for many applications and in many solution designs. This new API Gateway is a prime candidate for example for inclusion in our reference architecture for OCI based solution […]
Oracle Integration Cloud pricing explained – OCI vs Classic
Last week at AMIS we had the task of estimating costs of a proposed iPaaS solution for one of our customers that runs on a fully managed cloud. As AMIS is mainly an Oracle partner we looked at how competitive we could make the pricing of the solution using Oracle […]