Since September 2025, Oracle Base Database Service offers a new edition: Developer – or better: Enterprise Edition Developer. For those who need OS-level access to the database system for file transfers, SYSDBA or other administrative permissions, local database exports, or more than one tablespace (unlike Autonomous Database Shared) – the Base Database Service covers it all. No PDB count limitation of 3, Enterprise Features included. And the best part: License included! You only pay for the underlying resources like storage. Technical documentation: https://docs.oracle.com/en/cloud/paas/base-database/about/index.html#GUID-1DF6ECD3-A865-47B4-9C18-0D307113A507 Important note: This edition is not recommended for production. It fit’s best for development and testing. But why? There are some technical Limitations Supported Oracle Versions Provisioning The path to provisioning a Base Database Service is straightforward:…
Read MoreCategory: Oracle Tools
Getting started with Oracle Autonomous Database@Azure – Pay-As-You-Go | Part 3: Connect via Bastion
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 MoreDOAG 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 More