Sunday 16 July 2017

Failure - Test failed: The Network Adapter could not establish the connection for AWS Oracle DB

I have experienced these issues while developing a service web application using back end as AWS Oracle DB and front end - HTML5, CSS3, C#.net framework 4.6.

Very few people would opt for RDS Oracle DB. Hence, we find very less resolutions for issues related to AWS oracle Database.

Here is one among them,
'Failure - Test failed: The Network Adapter could not establish the connection'

We get this issue due to improper Inbound/Outbound traffic configuration of Security groups for your RDS database in AWS console.


Here is the step by step resolution for this,


Goto RDS Dashboard in Amazon Web service (AWS) console and click on Instances.









Click on your available DB instance and select Details tab.  Please see the highlighted below,









click on your security group. 
Note: it's best if you customize your security group rather than using Default groups,











Then select Inbound Traffic configuration and click on EDIT.





Now, here you can customize as how you are going to connect to this Database.
You can determine if the connection is specific to a person or a group or a process.
In my case, only me needed the connection to this Database. 

so, in Source column, modify the drop down menu as per requirements. 
if the connection is for your self, 
choose 'MY IP' from the drop down. This automatically stores your IP address and allows you to connect to the Database.





Now try connecting from SQL Developer and starting creating your own DB Objects.

Hope this is Helpful!

Followup with learning additional errors-Fixes.. :)

5 comments:

  1. Spent a week looking for a solution to this problem before I found your post. Thank you very much!

    ReplyDelete
  2. Thank you for the help, appreciate it.

    ReplyDelete
  3. Nice work, your blog is concept-oriented, kindly share more blogs like this
    AWS Online Training Hyderabad

    ReplyDelete
  4. The Database should have Public Access and Security Group attached to VPC must have access to the Internet in Inbound. This is more explained in the video link at time 05:05 https://youtu.be/HfukksuHU6Q

    ReplyDelete