My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.