Tuesday, January 13, 2015

Using SQL Developer to connect database via SSH Tunnelling

1. Below is the database server: SID: orcl1, I have normal unix account “donghua” to access the server via ssh.

clip_image002

2. Create the connection string profile. The hostname is “localhost” because the connection is tunnelling via SSH to the server, rather than remotely.

clip_image003

3. Click “Advanced” in above screenshot, enter SSH details. It’s possible to use SSH private key to automate the login. (Not used in my testing)

clip_image004

4. When connect to the database, it will promote for SSH password. (Since I already saved database password, it will not ask DB password here).

clip_image005

5. Connected to database. You can work with the GUI interface rather than SQLPlus now.

clip_image007