Category: GoldenGate

INSERTMISSINGUPDATES and NOINSERTMISSINGUPDATES

One of the member in the Oracle Community raised the below query. So I tested it and the solution is given below,

Suppose if i am deleting some records in Target Database like(one month data i deleted).Same data if i try to update in source database what will happen?
I tried this scenario in our environment,as i expected no change in target database(no error).If it has to update in Target database ,the data should be there.Now what my question is ,how should i replicate the deleted data in Target?is there any configuration available in OGG.I hope so ,i explained clearly.Please let me know if you need any details.Plesae help me for solution.

INSERTMISSINGUPDATES – NOINSERTMISSINGUPDATES

Continue reading…

OGG-02024 Oracle GoldenGate Capture for Oracle, An attempt to gather information about the logmining server configuration from the Oracle database failed

OGG-02024  Oracle GoldenGate Capture for Oracle,  An attempt to gather information about the logmining server configuration from the Oracle database failed

OGG-00662  Oracle GoldenGate Capture for Oracle, OCI Error retrieving bind info for query (status = 100).

I mistakenly deleted an Integrated Extract process UODSEXT without unregistering the Extract first. The actual procedure to delete an Integrated Extract is, first it should be Unregistered and then it should be deleted.
Continue reading…

OGG-00664 Oracle GoldenGate Delivery for Oracle, OCI Error Flushing database inbound server, (status = 26815-ORA-26815: Error from Apply Network Receiver for Apply and Capture “replicat”.

In this post I am sharing my experience on how I solved the below error.,

OGG-00664  Oracle GoldenGate Delivery for Oracle,  OCI Error Flushing database inbound server, (status = 26815-ORA-26815: Error from Apply Network Receiver for Apply and Capture “replicat”.

Suddenly one of my Integrated Replicat Porcess UODSREP got abended with the below error.,

2015-01-03 01:37:55  ERROR   OGG-00664  Oracle GoldenGate Delivery for Oracle, uodsrep.prm:  OCI Error Flushing database inbound server, ‘OGG$UODSREP’ (status = 26815-ORA-26815: Error from Apply Network Receiver for Apply “OGG$UODSREP” and Capture “replicat”.

Continue reading…

OGG-02077 Oracle GoldenGate Capture for Oracle, Extract encountered a read error in the asynchronous reader thread and is abending: Error code 4031

Extract encountered a read error in the asynchronous reader thread and is abending: Error code 447, error message: ORA-00447: fatal error in background process.

 

Recently I configured a report server. Used Oracle GoldenGate 12c Integrated Mode for the Real Time Replication from Production server. Nearly I configured the replication for more than 7 Schemas and size of each schema was more than 300 GB.
Continue reading…

OGG-02028 Failed to attach to logmining server Error code 1304

OGG-02028  Failed to attach to logmining server Error code 1304, error message: ORA-01304: subordinate process error

In this post, I would liketo share my experience of an error which I had faced recently.

For a project, I Configured Oracle GoldenGate 12c Integrated Mode for replicating between two Oracle Databases. I faced an issue and the Integrated Extract got ABENDED due to the below Error.
Continue reading…