My Oracle Support Banner

Coordinated Replicat Abended With Error " ORA-03171: Recovery Was Terminated During Query Execution" (Doc ID 2487394.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.3.0.1.3 version, 1 - Oracle DB backend

Coordinated replicat abended three times with ORA-03171:

2018-11-19 22:12:37 ERROR OGG-00665 OCI Error writing LOB for column <col_name>, stmt INSERT INTO "<table_name> (status = 3171-ORA-03171: Recovery was terminated during query execution), SQLVALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,:a15,:a16,:a17,:a18,:a19,:a20,:a21,:a22,:a23,:a24,:a25,:a26,:a27,:a29,:
...
a90,:a91,:a92,:a93) RETURNING "<col_name>" INTO :dl0>.

2018-11-19 22:34:43 ERROR OGG-00664 OCI Error writing LOB for column <col_name>, stmt INSERT INTO "<table_name> (status = 3171-ORA-03171: Recovery was terminated during query execution).




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.