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 MoreCategory: Autonomous Database
Getting 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 MoreThe Grafana Plugins for Oracle Cloud Infrastructure Monitoring are back!
In September 2019 I wrote a blog post how to monitor an Oracle Cloud Infrastructure Autonomous database with Grafana plugin oci-datasource. But some weeks after publication, the plugin was not available on the Grafana page anymore. And only Oracle and Grafana had a clue why. Now everything will be fine now. Since the 6th of October, there are two new Grafana plugins available for download. They both don’t require a Grafana enterprise account. Oracle Cloud Infrastructure Metrics Data Source Oracle Cloud Infrastructure Logging Data Source The first one is a successor of the former oci-datasource plugin, the second allows to get logs from OCI resources like Compute or Storage. As an infrastructure guy, let’s install the Oracle Cloud Infrastructure Metrics…
Read More