Master the DBA

Please refer to the steps outlined in the blog: Step-by-Step Guide to Configure Oracle GoldenGate for deploying the GoldenGate plugin 13.5.2.0.0 in OMS and EM Agent(s). In this blog, we will guide you through the steps to enable monitoring for GoldenGate 23ai Microservices using Oracle Enterprise Manager 13cR5. The Environment Consists of: Host: dbsrv01.localdomain OMS Server 13cR5 Source Database (19c) named "master" Operating System: OEL 8.8 Host: dbsrv02.localdomain GoldenGate 23c AI Microservices configured as a simple " HUB ARCHITECTURE " between source and target databases Running EM Agent 13c Host: dbsrv03.localdomain Target Database (19c) named "masters" Operating System: OEL 8.8 1.Log in to the OEM 13cR5 console and discover the Oracle Goldengate Microservices targets.  Go to Setup   -> Add Target   -> Configure Auto Discovery   In...

In this blog, we will walk you through the steps to reposition the Extract, Data Pump and Replicat processes in the event of Extract trail file corruption.   The environment consists of: Host: dbsrv01.localdomain: Source Database (19c) named "master" running on OEL 8.8, Extracting HR.REGIONS table using GoldenGate 21.3. Host: dbsrv02.localdomain: Target Database (19c) named "orcl" running on OEL 8.8, Replicating HR.REGIONS table using GoldenGate 21.3. Source (master) Target (orcl) 1. We have an integrated Extract running on the source database.   [oracle@dbsrv01 ~]$ ggsci   Oracle GoldenGate Command Interpreter for Oracle Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23 Operating system character set identified as UTF-8.   Copyright (C) 1995, 2021, Oracle and/or its...