My Oracle Support Banner

PostgreSQL Register extract- ODBC error: SQLSTATE S1000 native database error 8803729. [Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR (Doc ID 2720378.1)

Last updated on JULY 18, 2023

Applies to:

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

Symptoms

The connection could be established using dblogin but when trying to register the PostgreSQL, it fails with the following

2020-10-06 13:06:52 WARNING OGG-00552 Database operation failed: Executing statement to create replication slot. ODBC error: SQLSTATE S1000 native database error 8803729. [Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: VERROR; could not access file "test_decoding": No such file or directory(File dfmgr.c; Line 202; Routine internal_load_library;.


The Postgresql instance is on another compute machine in the same network.

Have provisioned GG for PostgreSQL on marketplace and have installed the client libraries and have set up the path to the lib files.

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.