0

I would like to connect a 12.1 Oracle RDS AWS instance to a Postgres database (also running at AWS but hosted on an EC2 instance).

There are a number of examples of how you could do this (eg https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database or https://oracle-base.com/articles/misc/heterogeneous-services-generic-connectivity )

which involve

  • using Oracle Heterogeneous Services to create (i think) a pseudo database connection connection
  • connecting the server listener to this HS connection
  • creating a DB link via the TNS names on the DB server to the ODBC destination.

As you cannot create .ora files or edit the listener on AWS I believe this approach is completely ruled out.

Is there another way that I can connect to this ODBC instance (perhaps some form of EZCONNECT string?) or is this just not possible at AWS?

  • You can create a database link without a tnsnames.ora record: create database link test connect to remote_user identified by remote_pw using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))'. I' sorry but I can't help you with the postgresql stuff. But maybe this still helps. – ora-600 Sep 16 at 15:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.