My Oracle Support Banner

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 later
Information 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


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