Foreign data wrappers for Oracle from Postgresql in RDS environment

[Garry Chen <gc92@xxxxxxxxxxx>]

Hi All,

                I am testing a dblink connection from RDS postgresql database to a remote oracle instance but I am getting could not establish connection error.  Where did I do wrong and please help.

 

Thank you very much,

Garry

 

My setup as following:

 

1. Security groups inbound has an entry for the oracle port and remote IP
2. Psql statement as following

Create extension dblinnk;

                CREATE SERVER myOradb FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host ‘my remote host IP’, dbname ' myOradb ', port '1521');

               CREATE USER MAPPING FOR PGuser SERVER myOradb OPTIONS (user 'OraUser', password '’mypassword');

               SELECT dblink_connect('myOradb');

 

 

ERROR: could not establish connection

SQL state: 08001

Detail: server closed the connection unexpectedly

                This probably means the server terminated abnormally

                before or while processing the request.