Oracle

GoldenGate distribution path profile in 23.26.4.0.0

In a previous post about updating the profiles of all extracts and replicats at once, I wrote that a profile does not apply to distribution paths. With GoldenGate 23.26.4.0.0, that is no longer true. When(…)

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(…)

Oracle Base Database Cloud@Customer

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

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(…)

tnsping with Oracle instant-client?

The instant client For an application server that connects to Oracle, you probably would not like to install gigabytes of a full Oracle client software? For that, Oracle offers the so-called “Instant Client” you can download for free at(…)

Oracle and btrfs snapshots

In my last blog post Snapshots with VirtualBox and btrfs we have seen some possibilities of btrfs snapshots. In this blog post we will see how we can use btrfs snapshots in combination with an(…)