I’m pleased to share all my cloud posts on this page. As with all the other pages, posts are in chronological order.
Downloading AutoUpgrade in Ansible playbooks
Mike Dietrich just announced a new AutoUpgrade release. If you haven’t heard about AutoUpgrade yet, you hit the right spot: it’s a pretty cool addition to any DBA’s toolbox. I use it all the time in Ansible, mainly because it makes installing an Oracle Home on a new server much much easier compared to the…
Storing & retrieving sensitive data for your CI/CD pipelines securely
On-premises edition. See below for a great article by Jeff Smith covering the other scenario where your database resides in Oracle Cloud. Secret management is a crucial part of your IT security strategy. Careless handling of secrets can leak these, and create security risks that are entirely avoidable. Hard-coding secrets, even for lab environments, is…
Server-side JavaScript is available on oracleapex.com
Multilingual Engine (MLE) for JavaScript has been available to developers on oracleapex.com since the Oracle AI Database 26ai upgrade a few weeks ago. With the release of APEX 26.1, there is now an even better reason to explore a free APEX workspace and start experimenting with JavaScript directly in the database. In this short video,…
Oracle Cloud Infrastructure: establish a console connection to a Linux compute VM
I previously wrote a short article detailing how to connect to a Windows VM in Oracle Cloud Infrastructure (OCI) using the console. I should be more precise: the post details how to connect to a “server with desktop experience”. Windows Core is different, but that doesn’t matter right now. This post however describes how to…
Adding self-signed certificates to a wallet became a one-liner in SQLcl 26.1
Before Oracle AI Database 26ai, anyone wanting to make a REST call from the database to an external service needed the external service’s certificate chain to be present in a wallet. The same applied to any other network call. This situation has greatly improved: Oracle Database releases 19c and 26ai trust the operating system’s certificate…
Updated setup-oracle-sqlcl Action and why it matters for SQLcl projects
This is a short post announcing a small but important change in the way you install SQLcl in GitHub Actions. The latest release allows you to install a specific SQLcl release in addition to the latest one. The most straightforward approach to using SQLcl in GitHub Actions is via Gerald Venzl’s setup-oracle-sql GitHub Action. Since…
Quick tip concerning dbms_cloud’s create_credential() call
DBMS_CLOUD is one of the crucial packages in Oracle AI Autonomous Database (ADB from now on). It allows you to perform many operations, including the creation of credentials. These are almost universally required for developers and admins alike. DBMS_CLOUD.CREATE_CREDENTIAL is an overloaded procedure, its documentation can be found here. I recently experimented with Select AI,…
JavaScript showcase: a fun playground environment for MLE/JavaScript in Oracle AI Database 26ai
I’m a huge fan of Oracle’s SQL Developer Extension for VSCode. I use it on a daily basis, and it has been invaluable to me. I particularly like the great integration into Git, and it’s built on top of a solid foundation that is Visual Studio Code. Recently I found out about GitHub CodeSpaces. After…
Why does my query run in parallel on Autonomous Database-Serverless even though I do everything to prevent it from doing so?
While preparing for another blog post I desperately wanted to write I noticed something unexpected. The problem turned out to be between keyboard and chair, but I don’t want to get ahead of myself. Tell me what happened already! Using Oracle SQL Developer Extension for Visual Studio Code, connecting to an Autonomous Database-Serverless, a query…
Using Oracle Database Free in your devcontainer and GitHub Codespaces
Dev containers are pretty nifty when it comes to keeping your development environment isolated from the rest of your system. Quoting from the documentation: Development containers, or dev containers, are Docker containers that are specifically configured to provide a fully featured development environment. Whenever you work in a codespace, you are using a dev container…
Something went wrong. Please refresh the page and/or try again.
