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!

Extract, Pump and Replicat are running, but data is not replicated

3203172Dec 14 2016 — edited Dec 20 2016

Hi,

We are using GoldenGate version 12.2.0.1.1 for replicating data from a Oracle 12C source DB to Oracle 12C target DB trying for unidirectional 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. The same code worked well before. The only change i did was i renamed the EXTTRAIL and RMTTRAIL prefixes.

When i start the EXTRACT, PUMP, REPLICAT processes, GG is able to write trail files in the DIRDAT folder for the first time in both source and target instances, but as i update a table which is mapped between the source and target this update is ot seen in target table. Even the EXTTRAIL and RMTTRAIL files are also not updated after the change(Earlier these files used to get updated when any change is made). Hence data is not replicating but the status of the processes if RUNNING and there is no information in ggserr.log file.

Please point the mistake i made and suggest solutions.

Thanks,

Sunil Methuku

This post has been answered by K.Gan on Dec 19 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2017
Added on Dec 14 2016
12 comments
6,753 views