ORACLE GOLDENGATE

Goldengate – Integrated Capture fails with OGG-02912

Here is one of my recent experiences running Oracle Goldegange 12.2.0.1 against Oracle 11.2.0.4 database. I was able to add Goldengate Extract Integrated process successfully without any issues. But when I tried starting the extract process, extract failed with the following error: 2016-09-04 23:49:30 ERROR OGG-02912 Patch 17030189 is...

Read More

GOLDENGATE MIGRATION

Goldengate Integrated Extract – Identifying and resolving extract process hang issue

Goldengate extract process can hang for various reasons. It is very important to have a process in place to monitor goldengate process and detect hanging issues. I recently encountered Goldengate Extract Hang issue. Below is how I resolved this issue: Copy the following SQL and save to file – dba_capture_info.sql:...

Read More