Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Changes are not replicated at Tatget database ( DB is running on ASM)

JhilJan 16 2024

Dear Experts,

I am an Oracle Goldengate novice and trying to implement uni directional.

All goldengate process are up and running fine but modified data is not replicated at Target machine.

I am not sure what is missing !! , Any help would be appreciated.

If DB is deployed on ASM, do we need any configuration changes ?

Grid version is 19c

DB Version is 12.2 with (ASM)

sqlplus -v

SQL*Plus: Release 12.2.0.1.0 Production

GGSCI (replica as gguser@hrmst) 17> sh ./ggsci -v

GoldenGate Version is 21.3

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

Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.

Source Database and Goldengate configuration details :

GGSCI (dgprim) 6> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     EDP1        00:00:00      00:00:00
EXTRACT     RUNNING     EXT1        00:00:00      00:00:08

>> Primary Extract configuration


GGSCI (dgprim) 8> sh cat ./dirprm/ext1.prm
Extract ext1
ExtTrail ./dirdat/ext1/et
UserIDAlias usergg1
tranlogoptions excludeuser gguser
--tranlogoptions dblogreader
tranlogoptions bufsize 4096000
Table repuser01.t1_tab;

>>

GGSCI (dgprim) 9> info er *
Extract    EDP1      Last Started 2024-01-16 16:57   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Process ID           10407
Log Read Checkpoint  File ./dirdat/ext1/et000000007
                    2024-01-16 23:31:36.344889  RBA 1521
Extract    EXT1      Last Started 2024-01-16 23:31   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:04 ago)
Process ID           12509
Log Read Checkpoint  Oracle Integrated Redo Logs
                    2024-01-16 23:40:33
                    SCN 0.4797448 (4797448)

>> Target database and Goldengate configuration details

GGSCI (replica) 6> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
REPLICAT    RUNNING     REP1        00:00:00      00:00:05


GGSCI (replica) 8> info er *
Replicat   REP1      Last Started 2024-01-16 23:32   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Process ID           18276
Log Read Checkpoint  File ./dirdat/rmt-ext1/rt000000003
                    2024-01-16 23:31:36.345102  RBA 1705

>> Replicat Process configuration

GGSCI (replica) 10> sh cat ./dirprm/rep1.prm
Replicat rep1
AssumeTargetDefs
UserIDAlias usergg2
--  # userid gguser password Oracle123
Map repuser01.*, Target repuser02.*;
-- # Map repuser01.t1_tab, Target repuser02.t1_tab;

Thanks

Comments
Post Details
Added on Jan 16 2024
10 comments
152 views