PostgreSql Extract - OGG-25359 Could not connect to server with database 'xx', host 'xxx', port 'xx'
(Doc ID 2764911.1)
Last updated on JULY 18, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.0 and laterInformation 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 |