Anniversary Gift: Versatile Cross Device File Manager (10GB free storage)
As part of our 20 year AMIS blog anniversary celebration, I would like to present the OCI File Manager – a free tool that allows users to easily, on …
Tag: Oracle
How to enable Oracle Database Azure AD authentication
As of Oracle database release update 19.18 a new authentication method was made available utilizing Azure AD (Entry ID as its named by Microsoft recently) Oauth tokens. Using this …
A first look at the Autonomous Database container image
September 29, 2023
Oracle Cloud, Cloud, Containers, Database, Databases, Platform Technology, Podman, Serverless, Technology
No Comments
Yesterday Oracle released their latest Autonomous database offering in a container image to try (most of) the Automous database technology without requiring access to the Oracle Cloud (OCI). This …
Oracle Database 23c as Graph Database–SQL Property Graph for network style querying
I bet you are used to relational data structures that you query using SQL. And so do I. And there is nothing in terms of data that a good …
Five part article series introducing Go on OCI
Go – sometimes Golang because internet searching for just “go” is quite impossible – is a popular programming language. It was initially launched in 2012 and as been gaining …
One click free browser based Oracle Database environment with Gitpod
This article describes how you can run your very own Oracle Database from your browser using Gitpod. With a free account (50 hours Gitpod use per month), you can …
Pseudo Change Timestamp–Finding recently changed table rows using Flashback Version Query to provide a surrogate last_changed column
My challenge: replicate changes from database A to database B, once per day. The tables involved are pretty big (100M records). I really would not want to process them …
Brief: What is Oracle Wallet?
An Oracle Wallet is an encrypted file that contains database credentials – username and password – for connecting to an Oracle Database. This avoids writing hard code user passwords …
Connecting Go application to Oracle Database–On Prem and Autonomous , with and without Oracle Client libraries
I have been struggling a bit with this one: how to connect from a Go application to an Oracle Database – both a locally running database as well as …
Cleaning Out a Compartment on Oracle Cloud using Terraform provider
The situation: a Compartment on OCI should be removed. Or at least all its resources should be purged. Or at least most of the resources should be removed. The …
Preparation for migrating data to Oracle Virtual Private Database
August 10, 2021
AMIS, Database, Databases, DBA Oracle, Oracle, Oracle 12, SQL, sqlplus, Technology
No Comments
preparation for migrating data to Oracle Virtual Private Database Introduction Recently I was part of a team involved in the preparation of migration data belonging to multiple business …
How to build [a CI/CD pipeline for] an Oracle Database application–kicking off a six part series
Build is an overloaded term in the world of software engineering. Building software used to be mainly a fancy way of saying “programming”. Now after the construction of the …
How to unit test a SQL query?
A simple challenge: I am working on a SQL query. Not a trivial query. I am trying various approaches. I believe I may have found a solution that works. …
What if companies say: “help me move away from Oracle”?
I hear this aspiration from a growing number of organizations. Sometimes as a quite literal question. This however is merely half of a wish. Apparently, organizations want to quite …
Another week of learning – some fairly personal notes
One of the best parts of my job is the opportunity to learn all the time. A day to loved is a day not lived, a day not laughed …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
Highlights from Oracle OpenWorld 2019 – Larry Ellison’s Key-Notes
This article gives some brief and key insights in Larry Ellison’s keynote presentation on Oracle Cloud Infrastructure at Oracle OpenWorld 2019. Note the new mission statement for Oracle: Our …
Monitoring Oracle Database using Prometheus
Prometheus is a very popular framework for gathering metrics from a plethora of runtime components, recording, analyzing, visualizing them and making them available for companion technologies such as Grafana. …
Newly released: Oracle Exadata X8-2 – bigger disks for saving money, expanding capacity
Earlier this month, Oracle announced the availability of the latest Exadata machine, the X8-2. As well as the option to swap in big 14 TB disks in older versions …
Extremely convenient way to run free Oracle Database 18c on your laptop – or anywhere else – using Vagrant & Virtual Box
Oracle Database 18c XE (eXpress Edition) is the free community edition of the enterprise edition of Oracle Database. Oracle Database XE has almost all features of Oracle Database; however, …
Invoke an Oracle Function on Oracle Cloud Infrastructure from a Node application
Oracle Functions is currently in limited preview and is expected to soon reach wider availability. Rolando Carrasco did this write up on Medium about his first experiences with Oracle …
First steps with Oracle Analytics Cloud – Gather, Explore, Wrangle, Visualize
Data analytics is what turns data into business value. Oracle has a long history in Data Analytics – from Oracle Discoverer and its predecessors such as Data Browser through …
Create OKE Kubernetes Cluster on Oracle Cloud Infrastructure – including Service Request to increase limit
Anyone with a trial account for Oracle Cloud can use Oracle Cloud Infrastructure (OCI) to get herself a three-node Kubernetes Cluster instance, running on Oracle’s managed Kubernetes Engine Cloud …
Get going quickly with Command Line Interface for Oracle Cloud Infrastructure using Docker container
Oracle Cloud Infrastructure is Oracle’s second generation infrastructure as a service offering – that support many components including compute nodes, networks, storage, Kubernetes clusters and Database as a Service. …
Another Taste of India– ODevCYatra 2018
July 2018 saw another edition of the Oracle Developers’ tour through India, called Yatra. In just over two weeks, seven cities participated in this tour – with each city …
Oracle’s extended support – when is it free of charge
It’s such a simple, basic and old question I got from a colleague: “Do you have to pay for extended support?”. And if so, how much I have to …
Running Istio on Oracle Kubernetes Engine–the managed Kubernetes Cloud Service
In a recent post, I introduced the managed Oracle Cloud Service for Kubernetes, the Oracle Kubernetes Engine (OKE): https://technology.amis.nl/2018/05/25/first-steps-with-oracle-kubernetes-engine-the-managed-kubernetes-cloud-service/. A logical next step when working with Kubernetes in somewhat …
First steps with Oracle Kubernetes Engine–the managed Kubernetes Cloud Service
Oracle recently (May 2018) launched its Managed Kubernetes Cloud Service (OKE – Oracle Kubernetes Engine) – see for example this announcement: https://blogs.oracle.com/developers/kubecon-europe-2018-oracle-open-serverless-standards-fn-project-and-kubernetes. Yesterday I got my self a new …
How to fix Dataguard FAL server issues
One of my clients had an issue with their Dataguard setup, after having to move tables and rebuild indexes the transport to their standby databases failed. The standby databases …
Introducing Elastic Search NoSQL to Oracle SQL developers – comparing dozens of ElasticSearch and SQL operations (a bit like Rosetta)
Even for organizations with strong roots in relational databases such as Oracle RDBMS, there may be valuable opportunities for leveraging additional data sources, for example to support special (search) …
Oracle, Azure Cloud and licensing with hyperthreading enabled.
Until recently, there was one rule when deploying Oracle software in the Azure cloud: count one Azure CPU Core as equivalent to one Oracle Processor license. But there was …
Oracle Managed Kubernetes Cloud– First Steps with Automated Deployment using Wercker Pipelines
Oracle announced a managed Kubernetes Cloud service during Oracle OpenWorld 2017. This week, I had an opportunity to work with this new container native cloud offering. It is quite …
Run Oracle Database in Docker using prebaked image from Oracle Container Registry–a two minute guide
This article will show how to run an Oracle Database on a Docker host using the prebaked images on Oracle Continer Registry. It is my expectation that it takes …
Quick introduction to Oracle Container Registry–running one of Oracle’s prebaked images
Oracle has been active with Docker for quite some time now. From the first hesitant steps from some enthusiastic employees with Docker build files that helped people to get …