Showing posts with label Network Adapter. Show all posts
Showing posts with label Network Adapter. Show all posts

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.. :)