Thursday, June 18, 2015

How create a secure connection (SQL Developer)

When you create a DBaaS instance, the only port open by default is 22 (SSH port).
So for SQL*Net access, you need to create a tunnel over SSH in SQL Developer.
  1. Download latest SQL Developer release from OTN
  2. Find the Public IP

  3. Get the Public key used on instance creation
  4. Start SQL Developer and add a SSH host (Public IP, username & key file)

  5. Create a new DB connection
    (choose SSH connection type and select the port forward created previously)
Now, you have a SQL Developer connection that uses SSH to tunnel into your DBaaS instance!