Home » Infrastructure » Cloud and Hosting » Oracle to Postgres DB Link in AWS/RDS (Oracle 11.2.0.4.0 enterprise (db.r5 instance), Postgres (db.t2 instance))
Oracle to Postgres DB Link in AWS/RDS [message #681376] Tue, 14 July 2020 06:41 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Hi

In our databases outside AWS/RDS, we create oracle to progress DB-link using ODBC drivers, involving many ssh operations that are prohibited on AWS/RDS.

Please inform is there any way we can achieve the same on AWS/RDS environment.

Or is there any alternative available on AWS/DRS that can serve the same purpose? it will be highly appreciated if you share the relevant documentation as well.

Thanks
Re: Oracle to Postgres DB Link in AWS/RDS [message #681377 is a reply to message #681376] Tue, 14 July 2020 11:18 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I did something like this just the other day:

Spin up an EC2 instance, a t3a.small (or even a t3a.micro) will do.
Install the Oracle Gateways on it, you don't need a licence if you are using only ODBC.
Configure the HS listener and all the rest there.
In your RDS instance, create the DB link pointing to the HS listener.

Easy Smile
Re: Oracle to Postgres DB Link in AWS/RDS [message #681378 is a reply to message #681377] Tue, 14 July 2020 12:12 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Thanks for your reply John

You want me to use EC2 instance for Postgres?
Can't it be possible with both Oracle and Postgres on RDS?

Re: Oracle to Postgres DB Link in AWS/RDS [message #681379 is a reply to message #681378] Tue, 14 July 2020 12:18 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I had thought that my post was crystal clear. Apparently not. You install the Gateway on an ec2. Nothing else. Is that clear enough?
Previous Topic: Using AWS EBS volume snapshots for open backup
Next Topic: hosting support oracle?
Goto Forum:
  


Current Time: Thu Mar 28 12:35:48 CDT 2024