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 APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.2 and laterInformation 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 |