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 FEBRUARY 08, 2021
Applies to:Oracle GoldenGate - Version 126.96.36.199.6 and later
Information in this document applies to any platform.
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.
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