Goldengate – Integrated Capture fails with OGG-02912

By Ravi Karamsetty | September 4, 2016 |

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 required on your Oracle mining database … Continue reading “Goldengate – Integrated Capture fails with OGG-02912”

Read More

Goldengate Integrated Extract – Identifying and resolving extract process hang issue

By Ravi Karamsetty | January 2, 2016 |

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: col CAPTURE_NAME for a20; col QUEUE_NAME … Continue reading “Goldengate Integrated Extract – Identifying and resolving extract process hang issue”

Read More