cannot connect from web application to oracle rds from ISP

0

Hello, I am new to AWS and have setup an oracle (rds) instance which is working fine for my web application when I test with my local development machine. When I test from my ISP, the connection to oracle fails with a connection timeout. I asked the ISP to ping my oracle server and they said it was failing and I might need to whitelist outbound IPs on AWS. Can someone here please advise on how I can do this? Or, is there something else I need to do?
My connection is done through a web.config file as…
<add name="ConnectionOracle" providerName="Oracle.ManagedDataAccess.Client" connectionString="Data Source=orcl.crkjumjl6ubz.us-east-2.rds.amazonaws.com:1521/ORCL;User Id=SchemaTrack_master;Password=mypassword;persist security info=false;Connection Timeout=120;" />
The timeout error I get is…
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 3.18.122.118:1521

Thanks very much.

Edited by: gunderj on Mar 27, 2019 9:01 AM

2개 답변
0
수락된 답변

From the information you provided, I can see that although your instance has a publicly available endpoint (orcl.crkjumjl6ubz.us-east-2.rds.amazonaws.com:1521)
This port is not open from the internet.

So, you would need to add ingress rules to your security group to allow ingress from your ISP to the RDS instance and port.

-Phil

AWS
중재자
philaws
답변함 5년 전
0

Thanks

gunderj
답변함 5년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠