Goldengate – Integrated Capture fails with OGG-02912
Here is one of my recent experiences running Oracle Goldegange 220.127.116.11 against Oracle 18.104.22.168 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:
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.