Cookies on this site

We would like to use cookies to understand how the site is used and to measure our campaigns. Nothing is set until you choose, and you can change your mind at any time from “Cookie settings” at the foot of every page. Privacy policy

Contact UsContact Us

Resources / Blogs

Oracle & databases

Goldengate – Integrated Capture fails with OGG-02912

Resolving the issue related to Goldengate Integrated Capture failed with OGG-02912. Here is how I was able to add Goldengate Extract Integrated process successfully without any issues.

· · 1 min read

Goldengate

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.

← All articles

Case studies

Oracle Consulting in practice

Client names are withheld. We are happy to share details on a call.

All case studies
  • Delivered

    30 TB, zero downtime

    Financial services

    Oracle

    Zero-downtime move of a 30 TB Oracle database for a global retail bank

    The bank's transaction database served thousands of users around the clock. We built the new Oracle 12c RAC platform on IBM AIX alongside the old Solaris system, kept the two in sync with Oracle GoldenGate, tested everything and switched over with no downtime and no data loss.

    • 30 TB moved with zero downtime
    • Zero data loss at cut-over
  • Delivered

    Zero downtime

    Legal technology

    Oracle

    Sybase to Oracle with zero downtime for an e-discovery company

    Sybase was holding back a platform that processes large volumes of legal data. We converted the schema, kept both databases in sync with continuous replication, validated the data and switched over without interrupting the business.

    • Zero downtime at cut-over
    • No disruption to client workflows
  • Delivered

    No service disruption

    Local government

    Oracle

    A city's Oracle database moved off ageing Solaris hardware

    A major California city ran a mission-critical Oracle database on Solaris servers nearing end of life. We mapped the dependencies, confirmed the applications would work unchanged and re-platformed the database to Linux without disrupting public services.

    • No disruption to public services
    • Minimal application changes

Keep reading

All Oracle & databases articles

Planning an Oracle or database migration?

Request a migration plan consult with the DBAs who do this work, and leave with a fixed-scope plan.