After months of speculation, it’s finally official: Oracle has released version 26ai of its Autonomous Database. The new release is already available in Oracle Cloud Infrastructure (OCI), so you can start exploring it right away. One notable change is in the OCI burger menu—Oracle has renamed the familiar “Oracle Database” section to “Oracle AI Database”, reflecting the AI-driven enhancements in this version. Let’s jump in and quickly create a brand-new Oracle 26ai instance to see what’s new! All new features are in the updated docs: https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/whats-new-adwc.html#GUID-F31A86F8-012B-4235-A0BE-4ABF75164853 Create Autonomous Database Do you see the blue announcement? It’s AI World time now! Choose Workload Type Data Warehouse, aka ADW, is now Lakehouse. Choose your Edition Free and Developer versions are available too.…
Read MoreCategory: Autonomous Database
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 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 More