Install and Configure Oracle GoldenGate 12.3 Microservices Architecture

The objective of this document is to demonstrate how to install and configure the new Oracle 12.3 GoldenGate Microservices Architecture.…

How to avoid resetting expired passwords in Oracle

Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very…

A quick emergency FRA clean up when archived logs are full.

I recently wanted to drop the indexes during a load and recreate after. There are several ways to do that,…

Today I ran into a scenario where I need to check if a table had an UNIQUE index. Instead of writing…

The Oracle Lifetime Support Policy brochure for tech products has…

When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis,…

‘ANONYMOUS’ — HTTP access to XDB ‘APPQOSSYS’ — QOS system user ‘AUDSYS’ — audit super user ‘BI’ — Business Intelligence…

Here is a simple script to check which tables are missing trandata and generate the GG (so call DDL) to…