Hey All,
We are attempting to get the oracle_fdw foreign table system from a google cloud database, all seems to have gone well with getting the extension in place, but we are hitting weird connection problems when we try and access the foreign table.
CREATE SERVER ora_sv_mex_dev FOREIGN DATA WRAPPER oracle_fdw
OPTIONS (dbserver '<ipaddress>:1521/<service name>');
CREATE USER MAPPING FOR ev_test SERVER ora_sv_mex_dev3
OPTIONS ( USER 'SYSTEM', PASSWORD '<password>');
CREATE FOREIGN TABLE test_roj2(dummy varchar(1))
SERVER ora_sv_mex_dev OPTIONS (SCHEMA 'SYSTEM' , TABLE 'TEST_ROJ');
ev_test=> select * from test_roj7;
ERROR: connection for foreign table "test_roj7" cannot be established
DETAIL: ORA-12541: TNS:no listener
We have successfully set up access to this database from the migration services, and have opened up our firewall on our side to allow connections, We did similar for the IP address we connect to the postgres db
One question is what IP would internal connection from our postgres db be coming in from? The same as the IP we connect to?
What could account for this issue? No Listener implies that it is making a connection to the server but not finding the listener
LinkedIn
Twitter
