My Oracle Support Banner

WARNING OGG-00552 Database Operation Failed: Couldn't Connect To Postgres Database when Customer is using two PostgreSQL Aurora instances on AWS. (Doc ID 2782625.1)

Last updated on FEBRUARY 09, 2022

Applies to:

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

Goal

whey dblogin failed when SSL enabled in Postgresql

error as:
GGSCI () 2> dblogin sourcedb ng_orchestration userid <username> password <password>


2021-04-13 13:49:28 WARNING OGG-00552 Database operation failed: Couldn't connect to ng_orchestration. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR: Database operation failed: Couldn't connect to ng_orchestration. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed. Failed to open data source ng_orchestration for user ggs_owner.

GGSCI () 3>
 

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!


In this Document
Goal
Solution
References


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