My Oracle Support Banner

WARNING OGG-00552 Database operation failed: Couldn't connect to <sourcedb>. ODBC error: SQLSTATE 587 native database error 0 While Connecting As DBLOGIN (Doc ID 2707650.1)

Last updated on SEPTEMBER 30, 2020

Applies to:

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

Symptoms

Goldengate replication is from Oracle to PostgreSQL. While connecting as DBLOGIN facing the below error.

GGSCI> DBLOGIN SOURCEDB <sourcedb>, userid <userid>

WARNING OGG-00552 Database operation failed: Couldn't connect to <sourcedb>. ODBC error: SQLSTATE 587 native database error 0. 523 586.
ERROR: Database operation failed: Couldn't connect to <sourcedb>. ODBC error: SQLSTATE 587 native database error 0. 523 586Failed to open data source <sourcedb>for user<userid>.

Cause

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
Symptoms
Cause
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.