This post is about using VSCode Dev Container extension for a controlled and secure development of Java at the Oracle Internal JVM (Java running inside your Oracle RDBMS, AKA OJVM), also it works for regular client side Java <-> RDBMs applications.

Why?

The Visual Studio Code Remote — Containers extension lets you use a Docker container as a full-featured development environment. It allows you to open any folder inside (or mounted into) a container and take advantage of Visual Studio Code’s full feature set. A devcontainer.json file in your project tells VS Code how to access (or create) a development container with a well-defined tool and runtime stack. …

Oracle Cloud Infrastructure (OCI) is an IaaS that delivers on-premises, high-performance computing power to run cloud native and enterprise company’s IT workloads. OCI provides real-time elasticity for enterprise applications by combining Oracle’s autonomous services, integrated security, and serverless compute. Available for public cloud.

This article is a continuation of the following series of related post:

• Oracle Always Free Cloud instances in HA configuration
• My own dev/test cloud environment using Oracle Always Free instances
• My own IoT deployment at Oracle Cloud Free using Autonomous DB and ML
• Using Let’s Encrypt certs with Oracle Cloud Load Balancer — including auto renew feature
• Using Oracle Cloud Object Storage as Docker…

Oracle Cloud Object Storage provides unlimited, high performance, durable, and secure data storage. Data is uploaded as objects that are stored in buckets.

The Object Storage service can store an unlimited amount of unstructured data of any content type, including analytic data and rich content, like images and videos. Object Storage provides several connectivity options, including a native REST API, along with OpenStack Swift API compatibility, and an HDFS plug-in. Object Storage also offers a Java SDK and Python CLI access for management.

In addition to above We will provide a Docker plugin to use Object Storage as regular Docker Volumes. …

Oracle Cloud free tier includes a Load Balancer with up to 10 Mpbs bandwidth, enough for many projects, this article shows how to use SSL traffic encrypted with Let’s Encrypt free certs.

Continuing with my article My own dev/test cloud environment using Oracle Always Free instances I’ll extend it to use Let’s Encrypt certs with auto renew features because these certs are valid for 3 months and I want to renew them automatically. Following picture depicts the deployment diagram:

Two week ago during the Oracle Developer Live, Keynote: The Future is Data-Driven by Juan R. Loaiza| Executive Vice President, Mission-Critical Database Technologies, mention the benefits of memoptimize for write table options, here a video with explanations (24.09" position)

looking at definition I decided to test by myself and compare this method with other traditional options such as Direct-Load INSERT and JDBC batch insert.

A big picture of memoptimize for write architecture is depicted at following picture

Imagine that you have a 12c/18c Oracle RDBMS running on Docker and want to migrate them to 19c.

Using Oracle Docker official image scripts and a two simple bash script will be enough to do this in one shot.

Preparing an RMAN full backup

First you need an RMAN full backup from your 12c/18c database, for doing that We need only a simple bash script passed to the setup/startup hooks of Oracle Docker image.

Directory hooks included into Oracle Docker images are:

• $ORACLE_BASE/scripts/setup
• $ORACLE_BASE/scripts/startup

setup scripts are executed just after the RDBMS was created and startup scripts are executed right after every Oracle startup. Assuming that you have for example a 12c RDBMS up and running put zz-backup-full.sh at startup directory stop and start again, for the example below We test our procedure by using a 12c fresh instance so We will use setup directory, here zz-backup-full.sh: …

Recently I came with the scenery of estimating maximum throughput of micro-services based applications on K8s clusters.
These micro-services implement several modules which use an Oracle DB as backend, before starting with a real test I like to know which is the maximum bandwidth our Oracle DB can accept, which is the Docker network overhead and which is the cluster (node to node) overhead.
To get a similar workload across different deployments I am working with a great piece of software by Dominic Giles called SwingBench. It included a graphical interface:

as well a command line, named CharBench.

Building SwingBench Docker image

Before starting with a cluster workload test let’s start with a simple Swarm deployment, to do that first We will create Docker images including SwingBench distribution ready for running as Docker Swarm services. Here a…

Some years ago I wrote an article on how to run an Oracle NoSQL cluster on Docker Swarm.

We know that Oracle NoSQL is previous to modern clustering technologies such as Docker Swarm or Kubernetes, specially because it use RMI and requires some static naming conventions on node names and registration.

But with a little trick, using bash, We can easily have NoSQL cluster up and running in a few minutes.

First we start building a custom Oracle NoSQL image extending the official provides by Oracle, here a Dockerfile:

To build our custom image simple run from command line:

$ docker build -t "oracle-nosql/net" . …