All articles

Copy big dumpfiles between firewall zones

If you have to transfer a big Oracle DataPump export (dumpfiles) from one firewall zone to another, it is often not possible to transfer it directly from the source- to the destination-host. Instead, you have to transfer it to(…)

applyOps and manual oplog replay for MongoDB PITR

mongorestore --oplogReplay gives you point-in-time recovery for a whole instance, replayed from the captured oplog of a single backup. It has no equivalent for a single database or a single collection. Say you need “restore just this one collection(…)

Governing AI agents in ECM: Who is really in control?

In my previous article, M-Files AI: From Intelligent Metadata to AI Agents, I explored how AI in Enterprise Content Management has evolved. We have progressed from automatically classifying documents and suggesting metadata, to AI(…)

Oracle Base Database Cloud@Customer

Base Database Cloud@Customer: is it an ODA Cloud@Customer?(…)

The real OPEX cost of the wrong open source choice

Free to download, expensive to run Open source is not free! The licence is, but the hours your team spends making it work are not. At dbi services we love open source. We run PostgreSQL, Kafka and Kubernetes(…)

GoldenGate captures TRUNCATE on a global temporary table and the replicat abends

In an extract report, I noticed that the CREATE and DROP of a global temporary table were excluded (OGG-10473), while the TRUNCATE of the same table was included (OGG-00487).

AI meets OEM, use native OEM MCP server

I have recently been configuring and testing Oracle AI Database Assistant integrated with Oracle Enterprise Manager 24ai Release 1 Update 10, to interact with the Oracle Management Repository (OMR) using natural language prompts. It is time now to test the(…)

Oracle AI Database Assistant showing “No metrics data were found”

I have already blogged on how to setup Oracle AI Database Assistant available since Enterprise Manager 24ai Release 1 Update 10, and also blogged doing some tests. For some prompts I was getting the error "No metrics data were found".

Manual local controller firmware update during ODA Patching

I was recently patching several Oracle Database Appliance (ODA) X11-2-HA at customer from 19.26 to 19.30 and then finally to 19.32. During one patching hop I faced an issue where /root became full. One of the consequences was that I(…)

Name resolution of Oracle

This blog post is a follow-up of TNS_ADMIN – which *.ora files Oracle will use. There, the main focus was to find out if a running database instance will use a TNS_ADMIN environment or the binary(…)