Windows Podman & Oracle Container Registry & VS Code – What a Match!

Introduction Podman utilizes a daemonless architecture to run Linux containers on Windows through the Windows Subsystem for Linux 2 (WSL2), providing full Linux kernel compatibility and high performance. Podman Desktop offers a graphical interface for managing containers and images, enhancing usability by integrating seamlessly with WSL2’s capabilities. This combination delivers a powerful container management solution for Windows users, leveraging the strength of Linux containers directly within a Windows environment. Together with the Oracle provided images on the container registry and the very popular Visual Studio Code, you get a powerful platform for Oracle SQL & PL/SQL Development.   Installation Install and Setup Podman Desktop for Windows & Podman For Windows, several install methods like Silent Windows installer, Chocolatey, Scoop and…

Read More

Oracle Cloud Infrastructure – A short Blog Post about a secure and small Development Setup

For an internal project I had the pleasure to setup a new Oracle Cloud Infrastructure environment for an APEX development team. Here is a short overview about the setup. Requirements VPN Access from everywhere – 2 people are working maximal at same time on the environment Oracle Standard Edition 2 – no license available in project Small monitoring to verify server stats Instances can be started and stopped from the developers to save costs for example over night, weekend, holiday etc. Architecture Diagram Resource Network Usage Remarks Open VPN Access Server Public Subnet VPN client access and traffic routing OCI Cloud Marketplace Image – OpenVPN Access Server (2 FREE VPN Connections) – OpenVPN Inc. – Oracle Cloud Marketplace Management Server…

Read More

Oracle Cloud Infrastructure Data Safe – How to burn down 201.44 Swiss Francs in 30 Seconds…

Is Data Safe really for free? In the last autumn, the new Oracle Cloud Infrastructure feature called Data Safe was released. For sure, new features has to be tested. I have tested the Data Safe feature too and added a cloud database to Data Safe. But in my enthusiasm about this cool feature – or maybe it was just too late in the evening –  I did a mistake by adding the database target. Four days later, I recognized that Data Safe is charged in my account. Mmm, but should it not be for free? First reaction: I raised an SR and described the case. The nice guy from My Oracle Support realized the situation quickly: Dear Mister Berger, you…

Read More

Oracle Cloud Infrastructure Classic Object Storage – Cleanup Day with FTM CLI

Yesterday I decided to cleanup old Oracle Cloud Infrastructure Classic objects. There were a lot of files lying around in the Object Storage of a project from 2018. Cleaning up these files in the OCI console was no option, they can only be deleted one by one. And with over 1500 files, a bad idea. During the search for an option for Object Storage mass deletion, I found this tool: ftmcli – Object Storage Classic File Transfer Manager. The MOS note contains the script and a short manual how to use. It’s a Java based script,  a perfect match for my Windows Subsytem for Linux (Ubuntu), which I often use for OCI actions. OAC-Classic : How To Delete A Storage…

Read More

Oracle Release Update 19.9 – Lab Update Time (Grid Infrastructure Standalone & RDBMS)

The Oracle Release update 19.9 for Linux is available since a few days. Time to upgrade my lab environment at home which consists of the following components: Oracle Grid Infrastructure Standalone 19.8.0 with ASM Normal Redundancy – +ASM Oracle 19.8.0 RDBMS as Repository for Oracle Enterprise Manager – EMREPO The running 19.8 Environment Output from Trivadis base environment tool TVD-Basenv(TM). oracle@mohnweg:/u01/app/19.0.0/grid/OPatch/ [em13cr4] u TYPE (Cluster|DG) : SID/PROCESS STATUS HOME [2020-10-25 19:47:47] ——————————————————————————— Dummy em13cr3 : em13cr4 n/a /u01/app/oracle/product/em13cr4 Dummy emagent : emagent n/a /u01/app/oracle/product/agent13c/agent_13.4.0.0.0 Dummy emagent : emagent_a n/a /u01/app/oracle/product/agent13c/agent_inst Dummy grinf : grinf19 n/a /u01/app/19.0.0/grid Dummy rdbms_ee : rdbms19 n/a /u01/app/oracle/product/19.0.0/dbhome_1 ASM-instance : +ASM up /u01/app/19.0.0/grid DB-instance (N|N) : EMREPO open /u01/app/oracle/product/19.0.0/dbhome_1 Listener : LISTENER up /u01/app/19.0.0/grid Ohs 12c…

Read More