My Oracle Support Banner

PostgreSql Extract - OGG-25359 Could not connect to server with database 'xx', host 'xxx', port 'xx' (Doc ID 2764911.1)

Last updated on MARCH 07, 2022

Applies to:

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

Symptoms

Newly configured Postgresql extract failed with

2021-01-19 19:45:34 ERROR OGG-25359 Could not connect to server with
database '<Dbname>', host '<IP Address>', port '1234' and user name
'<username>'. Error Message: could not connect to server: Connection refused
Is the server running on host "<IP Address>" and accepting
TCP/IP connections on port 1234?.

2021-01-19 19:45:34 ERROR OGG-00145 Call to VAMInitialize returned with
error status 16002.

 

The port number should be 12345, but the error showing port number '1234'

postgres=# select inet_server_addr( ), inet_server_port( );
-[ RECORD 1 ]----+-
inet_server_addr |
inet_server_port |

postgres=# show port;
port
-------
12345
(1 row)

The odbc.ini file was also having the port number as 12345

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.