Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Goldengate Running but not replicating

Richard OwusuNov 19 2024

We are using GoldenGate version 19.1.0.0.4 for replicating data from a Oracle 19C source DB to Oracle 19C target DB trying for bidirectional replication.

All the processes(EXTRACT, PUMP and REPLICAT) are running as usual, but the updates i make in the source table are not replicating in target tables.

When i run the stats Extract PUMPFE1 process i get No Active Extraction maps. The same on Target db.

I did not see any error in the ggserr.log

See below for your information.

Source DB

GGSCI (pr-emv-appdb-02) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTBO 00:00:00 00:00:06
EXTRACT RUNNING PUMPFE1 00:00:00 00:00:02
REPLICAT RUNNING REPA1FE1 00:00:00 00:00:03
REPLICAT RUNNING REPD1FE1 00:00:00 00:00:05
REPLICAT RUNNING REPD2FE1 00:00:00 00:00:07
REPLICAT RUNNING REPR1FE1 00:00:00 00:00:06
REPLICAT RUNNING REPT1FE1 00:00:00 00:00:04

GGSCI (pr-emv-appdb-02) 8> stats EXTRACT PUMPFE1

Sending STATS request to EXTRACT PUMPFE1 ...

No active extraction maps.

GGSCI (pr-emv-appdb-02) 9>

Target DB

GGSCI (pr-emv-switchdb-01) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTFE1 00:00:04 00:00:09
EXTRACT RUNNING PUMPBO 00:00:00 00:00:00
REPLICAT RUNNING REPA1BO 00:00:00 00:00:08
REPLICAT RUNNING REPD1BO 00:00:00 00:00:09
REPLICAT RUNNING REPD2BO 00:00:00 00:00:01
REPLICAT RUNNING REPR1BO 00:00:00 00:00:02

GGSCI (pr-emv-switchdb-01) 2> stats EXTRACT PUMPBO

Sending STATS request to EXTRACT PUMPBO ...

No active extraction maps.

GGSCI (pr-emv-switchdb-01) 3>

Kindly assist me to resolve this issue as i am pretty new to GG.
Thanks.

Comments
Post Details
Added on Nov 19 2024
1 comment
26 views