GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

goldengate dblogin to postgresql fails

edited Jul 27, 2020 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered

i am able to connect to database using odbc on redhat linux but fails with dblogin

lrdtmgr1@he3ilxvduti327:/usr/bin> ./isql -version factdb1

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

DBLOGIN SOURCEDB factdb1,userid v-ldap-f40-sqlddl-Cn1zT2rAJLaXJIvSQsAx-1592489103,password xxxxxxxxxxxxxxxxx

2020-07-09 13:19:10  WARNING OGG-00552  Database operation failed: Couldn't connect to factdb1. ODBC error: SQLSTATE 587 native database error 0. 523 586.

ERROR: Database operation failed: Couldn't connect to factdb1. ODBC error: SQLSTATE 587 native database error 0. 523 586Failed to open data source factdb1 for user v-ldap-f40-sqlddl-Cn1zT2rAJLaXJIvSQsAx-1592489103.

ODBC info

[factdb1]

Description=ODBC for PostgreSQL

Driver=/usr/lib64/psqlodbcw.so

Setup=/usr/libi64/psqlodbc.so

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center