Goldengate CDC Extract Abends With OGG-05345 OGG-00551
(Doc ID 2926430.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 21.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
CDC Extract abends with below errors:
2023-01-25 08:08:42 ERROR OGG-05345 An Oracle GoldenGate query to the database has timed out. Use the TRANLOGOPTIONS QUERYTIMEOUT parameter in Extract's
parameter file to increase the timeout value. The current timeout value is 400 seconds.2023-01-25 08:08:42 ERROR OGG-00551 Database operation failed: Execute
handle failed while retrieving CDC records from procedure 'OracleCDCExtract'.
ODBC error: SQLSTATE 08S01 native database error 104. [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure.
2023-01-25 08:08:42 ERROR OGG-00551 Database operation failed: Execute handle failed while retrieving CDC records from procedure 'OracleCDCExtract'.
ODBC error: SQLSTATE 08S01 native database error 104. [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x68.
We added TRANLOGOPTIONS QUERYTIMEOUT 500 in extract parameter file but it does not help in this case.
Changes
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 |
Changes |
Cause |
Solution |