Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is possible to connect to RDS Oracle DB instance with SQL developer?

I'm trying to connect into my mac with the endpoint that AWS give me but i can't.

like image 905
Carlos Enrique Medina Figueroa Avatar asked Jun 26 '15 02:06

Carlos Enrique Medina Figueroa


People also ask

Can we connect to Oracle Database using SQL Developer?

To connect Oracle SQL Developer to your Oracle Database Exadata Express Cloud Service, you need to generate a secure wallet by enabling Oracle Net Services (SQL*Net) for your service, install Oracle SQL Developer, and create a cloud connection from Oracle SQL Developer to your service.

Can we connect to RDS instance?

To connect to a private RDS DB instance from a local machine using an EC2 instance as a jump server, follow these steps: Launch and configure your EC2 instance and configure the network setting of the instance. Configure the RDS DB instance's security groups. Connect to the RDS DB instance from your local machine.


2 Answers

Yes, You can.

These are the AmazonRDS settings.

AWS RDS settings

and this is the SQL Developer connection window

enter image description here

database host name should be the AWS endpoint & SID should be the AWS DB Name.

like image 112
Damith Ganegoda Avatar answered Sep 22 '22 06:09

Damith Ganegoda


You can connect to database instance in RDS by using the endpoint and the credentials associated with the rds instance

Refer the below link for guidance:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.Oracle.html

Also ensure that the security group associated with the RDS instance has appropriate port open for oracle connection.

like image 45
Domain Avatar answered Sep 23 '22 06:09

Domain