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 required on your Oracle mining database for trail format RELEASE 12.2 or later.


I was expecting this Patch 17030189 to be available for Oracle Exadata Database Server. I was recommended to use the following work-around solution by Oracle which has resolved the above issue and I was able to successfully start the Extract Process.

Execute the plsql script – prvtlmpg.plb which is available under Oracle Goldengate Install Directory/Home as sysdba:


SQL>@prvtlmpg.plb


Enter the capture user account that you are using for extract process when it prompts.

You should be able to start the extract process, with this work-around.

Good Luck.