Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
This is second part of 26ai migration blog. We will upgrade here one node Clusterware with ASM in 19c. We will use newest 23.26.1 GoldImages from oracle support. This tutorial showing main steps how to perform upgrade, its not procedure to upgrade your production environment, please checkout official documentation from oracle do proper planning and prechecks before you do it.…
In this blog post, I will guide you on how to query the restapi.log file of your GoldenGate deployments more efficiently. These logs are a valuable source of information for GoldenGate administrators but are unfortunately not easy to analyze. In fact, their format is not really suited for a complex analysis. With what I present here, you could improve the…
I recently had an issue with the GoldenGate credential store at a customer when patching a GoldenGate 19c setup with the latest 19.30 patch. Since it is not the first time that I have encountered this problem, I figured it would be worth doing some scripting around it. So what is the problem exactly ? When patching a GoldenGate installation…
Introduction Throughout my RAG series, I’ve explored how to build retrieval-augmented generation systems with PostgreSQL and pgvector — from Naive RAG through Hybrid Search, Adaptive RAG, Agentic RAG, and Embedding Versioning (not yet released) . The focus has always been on retrieval quality: precision, recall, nDCG, confidence. But I want to take a step back. In conversations with colleagues, clients,…
In this blog, I will present the new features introduced with the latest release (2.4.0) of the MongoDB DMK. The DMK is a set of standardized tools that aims at easing the work of DBAs by having dbi’s best practices embedded in common scripts across all the database servers of an organization. dbi services provides the DMK (Database Management Kit) to its…
This tutorial showing simple database upgrade to 26ai using traditional method and autoupgrade tool, For operational databases please properly test and plan your upgrade. https://docs.oracle.com/en/database/oracle/oracle-database/26/fppad/upgrading-oracle-database-software.html This is one from 3 Articles related to 26.1 upgrade: Step 1. Downloading software and preparing Linux Download Base Gold image from Oracle support software from latest Oracle AI Database 26ai (23.26.1) for Linux x86-64…
In the last post we’ve looked at how you you get EDB Postgres Extended server installed on your system. In contrast to the version provided by Fujitsu, TDE needs to be enabled when you initialize a new cluster, so lets do this and see how we can proceed from there on. When we’ve initialized a new cluster in the last…
Encryption-in-transit is part of the essential security baseline for SQL Server.Without TLS, TDS packets travel in clear text across the network, making them vulnerable to interception or modification by an attacker attempting to gain access to the system.This is why TLS has become a standard in modern SQL Server architectures. In this article, we will look at how to standardize…
When playing around with the GoldenGate REST API, you might have encountered the OGG-08116 error. It happens when using the Create Connection REST API call, with the following endpoint given in the GoldenGate documentation. The OGG-08116 error is defined as such in the documentation: So what is the problem exactly ? When navigating through the GoldenGate deployment’s web UI, you…
We’ve already briefly looked at Fujitsu Enterprise Postgres (here and here) when it comes to TDE (Transparent Data Encryption) in PostgreSQL. In this and the next post we’ll look at EDB’s distribution of PostgreSQL and how TDE can be configured and used in his commercial flavor of PostgreSQL. For getting EDB Postgres Extended Server installed you need to create an…
A crucial step after installing a Veridata server is to set up Veridata agents. And, as mentioned in a previous blog post about GoldenGate Veridata installation, Oracle didn’t bother to indicate when an agent is failing. For instance, the following agent named vdt_agent1 starts successfully: And this agent named vdt_agent2 fails to start: Zero difference in the agent.sh output, yet…
In the last post we did the setup of Fujitsu Enterprise Postgres so we’re now ready to look at how TDE is implemented in this distribution of PostgreSQL. The unit of encryption in this version of PostgreSQL is a tablespace but before we can encrypt anything we need to create a master encryption key. The location where the keystore gets…
