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: Autonomous Database
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 MoreGetting started with Oracle Autonomous Database@Azure – Pay-As-You-Go | Part 2: Provisioning
In blog post Part 1, I described how to subscribe to the PAYG service to use the Oracle Autonomous Database in Azure. Now it’s time to provision a new ADB. As prerequisites, a resource group, a virtual network and several subnets are created. When provisioning an Autonomous Database on Oracle Database@Azure, it is essential to use a delegated subnet. A delegated subnet is a subnet within a virtual network that is specifically designated for use by a particular service. Using a delegated subnet ensures enhanced security, better network control, simplified management, compliance, and optimized performance, making it an ideal choice for modern database provisioning. Overview This is the entry point, click on Create Autonomous Database. Basics When deploying an Autonomous Database…
Read MoreOracle Cloud Infrastructure – Configuring Network Access with Access Control Rules (ACLs)
When running Autonomous Databases (ADB) in Oracle Cloud Infrastructure (OCI), it’s crucial to prioritize security, even for development and test environments. Allowing unrestricted public access (0.0.0.0/0) is not a secure solution and should be avoided. To ensure that only trusted sources can access your databases, you can restrict access to specific IP addresses and Virtual Cloud Networks (VCNs). To enhance security, I configured my ADB to allow access only from specified IP addresses and VCNs. This approach ensures that only authorized users can connect to the database. My next step was to add the public IP address of my workstation to the ADB’s access control rules, so I can securely manage the database from my current location. While the OCI…
Read MoreNever stop Learning – why I love Oracle LiveLabs
Since over one and a half year, this week I was back in an onsite training, live people, live teaching. With a motivated junior DBA class, we started with all about Oracle architecture based on our Trivadis training O-AI – Oracle Architecture and Internals. The training is a mix between slides, demos and labs. Therefore during the course we run the training environments in Oracle Cloud Infrastructure, build by Terraform (Credits to Stefan Oehrli from oradba.ch which has ramped up the whole stuff). After the course at the end of the month, the environments will be cleaned up. And what’s next? Training Environments There are a lot of possibilities to get a deeper knowledge of all this Oracle stuff like…
Read More