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

chonewell Nov 12 2024

My Oracle Cloud tenant, cloud account, and secure email have no issues. Why haven't I received my password reset email for Oracle Cloud? This is very strange, and our attempts have not been able to solve the problem. May I ask who I should turn to for help?

L. Fernigrini Nov 12 2024

If your account is a paid one, open a Support ticket.

If it is a Free Tier then you will have to rely on help from the community. Most probable cause that you did not receive the password reset email is that your account has been stolen and the email has been changed.

chonewell Nov 13 2024

Thank you for your reply!
But when I chatted with the online customer service, they told me that my Oracle Cloud tenant, account, and email were all fine. So, there shouldn't be a problem of theft.
I have a free account, but who can I contact on the forum? I can only post, but no one on the forum can view my account permissions, right. I am currently trying to reset MFA, I don't know if it works.
It's quite ridiculous that I have a free account and can't enjoy any services, but how can I become a paid user if I can't log in to my account.

1 - 3

Post Details

Added on Nov 19 2024
1 comment
116 views