Golden Gate Login Fails To Connect To Postgres Db Via ODBC (Doc ID 2295615.1)

Last updated on AUGUST 10, 2017

Applies to:

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

Goal

OGG postgres db connection issue with odbc. 

DBLOGIN SOURCEDB localhost, USERID "wp-opt-replicator", PASSWORD t


2017-08-04 00:52:32 WARNING OGG-00552 Database operation failed: Couldn't connect to localhost. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR: Database operation failed: Couldn't connect to localhost. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.Failed to open data source localhost for user wp-opt-replicator.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms