If an Autonomous Database (ADB) is deployed in a private subnet and requires access for analysis or troubleshooting, Azure Bastion provides a secure solution. This guide demonstrates how to connect to an Oracle Autonomous Database@Azure via Bastion while using a locally running VS Code as a SQL editor. In this setup, Azure Bastion is already configured, and both the provisioned Autonomous Database and the vNet jump host do not have public IP addresses. All commands are executed on a Windows machine using PowerShell, with the Azure CLI set up according to the official documentation: How to install the Azure CLI | Microsoft Learn. This is part three of the Oracle Autonomous Database@Azure blog post series: Part 1: Subscription: https://www.martinberger.com/2024/10/getting-started-with-oracle-databaseazure-pay-as-you-go-part-1-subscription/ Part…
Read MoreCategory: Oracle Tools
DOAG Konferenz 2024: Ein Rückblick auf vier intensive Tage in Nürnberg
Vom 19. bis zum 22. November 2024 war Nürnberg einmal mehr der Treffpunkt für Oracle-Experten, Anwender und Partner. Aber nicht nur Oracle war Thema, auch PostgreSQL, Soft Skills und vieles mehr stand auf der Agenda. Die DOAG Konferenz bot auch in diesem Jahr eine Plattform, um Wissen auszutauschen, neue Entwicklungen zu präsentieren und Kontakte zu knüpfen. Ich hatte die Ehre, selbst mit vier Vorträgen vertreten zu sein und meine Erfahrungen rund um Themen wie Oracle Cloud Infrastructure Security, Automation mit Oracle Linux Automation Manager, sowie Red Hat Ansible Automation zu teilen. Meine Vorträge und Highlights Es ist immer ein besonderes Erlebnis, vor einem grossen Publikum zu sprechen, und die Sessions in den gut gefüllten Räumen haben gezeigt, dass das Interesse…
Read MoreWindows 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 MoreOracle 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 MoreOracle 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