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 184.108.40.206.3 and later
Information in this document applies to any platform.
On : 220.127.116.11.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).
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