CODEWITHSUNDEEP
oracle-databaseamazon-ec2oracle-sqldeveloper
JRG
JRG

Reputation: 593

How to connect to an Oracle Database running on Amazon AWS EC2?

I have an Oracle Database instance running in Amazon AWS EC2 service. (it is not RDS Relational Database Services).

How can I configure my Oracle SQl Developer to to access this remote databse in AWS EC2?

By checking AWS documentation I found only references to connect to Oracle databse running in RDS services.

I apreciate your help.

Thanks

Upvotes: 1

Views: 6824

Answers (2)

John Shue
John Shue

Reputation: 1

If you want to add another layer of security. SSH or DMZ + Load Balancing is the way to go. If not Make sure the following are all open for the IP. firewall, VPC Network, AWS inbound outbound rules.

Upvotes: 0

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60292

  1. In AWS, edit the Security Group for your instance to add a rule (if one doesn't already exist).

    Inbound

    Type = SSH

    Protocol = TCP

    Port Range = 22

    Source = "My IP", or "Custom" (as you wish)

  2. In SQL Developer, open View -> SSH.

  3. Right-click "SSH Hosts", New SSH Host.

    Name = whatever you like

    Host = your server's IPv4 Public IP address

    Port = 22 (default)

    Username = root or ec2-user, whichever is appropriate for the linux AMI you used

    Use key file = tick this and select your key file for your instance

    Add a Local Port Forward = tick this and accept the defaults (localhost, port 1521)

  4. Edit the properties of your SQL Developer Database Connection

    Connection Type = SSH

    Port Forward = the name of the SSH Host you created earlier

    SID / Service name = whatever SID or Service name you need

Upvotes: 1

Related Questions