This content has been marked as final. Show 2 replies
The Oracle database needs to talk to the Oracle Listener that spawns the gateway process.
You have configured the Oracle Gateway listener to listen on (HOST = VBoxCentOS)(PORT = 1521)), but in your tnsnames.ora you connect directly to the PostGres database:
pgsql = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vboxxp)(PORT = 5432)...
In addition some brackets are incorrectly placed.
So please correct the tnsnames.ora entry to:
pgsql = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = VBoxCentOS)(PORT = 1521)) (CONNECT_DATA = (SID = postgresql))(HS = OK))