WARNING OGG-00552 Database operation failed: Couldn't c

Posted by kiran kakaraparthy on 23-Sep-2016 07:45

Hey Guys,

I am new to postgresql Database administration.

I am trying to connect to postgresql database through golden gate , but encountered with below error.

GGSCI (illin1282) 3> dblogin sourcedb GG_Postgres userid postgres
Password:

2016-09-23 14:32:07 WARNING OGG-00552 Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR: Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.Failed to open data source GG_Postgres for user postgres.

I used below odbc.ini file:

[ODBC Data Sources]
GG_Postgres=DataDirect 9.5.4 PostgreSQL Wire Protocol
[ODBC]
IANAAppCodePage=106
InstallDir=/u01/postgres/ggs
[GG_Postgres]
Driver=/u01/postgres/ggs/lib/GGpsql25.so
Description=DataDirect 9.5.4 PostgreSQL Wire Protocol
Database=ashwin
HostName=10.232.230.35
PortNumber=5434
LogonID=postgres
Password=postgres

Any help is appreciated.

Regards,

KiranBapuji.

OracleDBA.

All Replies

Posted by kiran kakaraparthy on 26-Sep-2016 10:40

Thanks.

I resolved by adding below under pg_hba.conf and bounced the postgresql instance.

local   all             all                                     trust

host all all 0.0.0.0/0 trust

This thread is closed