Testing connection from RDS

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,

トピック

移行と近代化分析データベースネットワークとコンテンツ配信

タグ

AWS Database Migration Service Amazon Relational Database Service (RDS)データベースネットワークとコンテンツ配信 Oracle

言語

English

sam15

質問済み 9ヶ月前573ビュー

2回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

承認された回答

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? If not, I'd recommend you take a look at the following Blog post which explains in detail how to troubleshoot (test in your case) network connectivity to RDS databases.

I hope this helps.

エキスパート

Jose Guay

回答済み 9ヶ月前

エキスパート

Gary Mclean

レビュー済み 9ヶ月前

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

エキスパート

AWS-User-alantam

回答済み 9ヶ月前

sam15
9ヶ月前
Unfortunately I can not create another EC2 in same subnet to test connectivity. It requires reuest, approvals, security and most likely they wont approve. Is not there a way to do via SQL command in Oracle SQL Developer?

Testing connection from RDS

関連するコンテンツ