Testing connection from RDS

Question

Hi

Do you know how to test connectivity from one RDS oracle database to another RDS oracle database under a different account?
Both accounts have a transient gateway between them.
There is no operating system access on both machines but only SQL access.
I am trying to test TCP network connection before creating a DB link between the two.

Thanks,

Accepted Answer

Hi Sam.

Is there a reason you can't just create the DB link and test it? You can always delete it if it doesn't work.

Also, have you tried using [VCP Reachability Analyzer](https://docs.aws.amazon.com/vpc/latest/reachability/what-is-reachability-analyzer.html)? If not, I'd recommend you take a look at the following [Blog post](https://aws.amazon.com/blogs/database/troubleshoot-network-connectivity-to-amazon-rds-databases-using-vpc-reachability-analyzer/) which explains in detail how to troubleshoot (test in your case) network connectivity to RDS databases.

I hope this helps.

Answer

You can create an EC2 instance from the source RDS subnet and perform testing on the instance using common Linux or Windows Tools, such as SQL Workbench/J.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html

Testing connection from RDS

Relevant content