OGG-02060 The Oracle Mining Database is not Configured Properly to Support Integrated Capture.

Question: When creating the GoldenGate Integrated Extract I get the “OGG-02060 The Oracle Mining Database” error.

    GGSCI (gg01) 3> REGISTER EXTRACT xgg01 DATABASE

    ERROR OGG-02060 The Oracle mining database is not configured properly to support integrated capture. The following configuration error must be fixed: Operation not supported because ENABLE_GOLDENGATE_REPLICATION is not set to true.

How do I fix the OGG-02060 Error?

Answer: The parameter ENABLE_GOLDENGATE_REPLICATION needs to be set for the mining server to be available.

Action: Set the ENABLE_GOLDENGATE_REPLICATION database parameter to true. Also ensure that the database patch 14551959 is installed. More information is available in MOS note 1411356.1.

    SQL> alter system set ENABLE_GOLDENGATE_REPLICATION=true;

    System altered.

    GGSCI (gg01) 4> REGISTER EXTRACT xgg01 DATABASE

    INFO OGG-02003 Extract XGG01 successfully registered with database at SCN 912858.

Extract registered successfully!

Related Posts
GoldenGate 12c: Silent Install – Starting with GoldenGate 12c, Oracle has moved the installation mechanism into the familiar Oracle Universal Installer, GUI framework. It’s a good move not only in terms of ease of use but also for the uniformity of the install process across all Oracle products.

Deinstalling GoldenGate 12c
In GoldenGate 12c, the installation and the de-installation process has been standardized to use the Oracle Universal Installer (OUI) interface. In this article we will look at how can we deinstall Oracle GoldenGate.


Note: This Oracle documentation was created for reference for use by Vitalsofttech DBA’s. If you have any questions please post by clicking on the ASK A QUESTION link above.

Leave a Reply

Your email address will not be published.