Oracle Database (SqlPlus) Access Using Putty SSH Tunneling

You are welcome to use AppsHosting documentation in your businesses and websites, but we would really appreciate it if you maintain the links to AppsHosting!

To maintain a high level of security, AppsHosting does not allow direct SQL*Plus connections to the production database, if customers do not have a static IP address (which can be added to the AppsHosting firewall filters).  For customers that use dynamic IP addresses on their PCs, AppsHosting recommends using SSH tunneling to enable direct connection to the production Oracle database.
This document outlines the steps required to set up SSH tunneling to set up a connection to the Oracle database using the Putty SSH client.
If you do not have Putty installed on your PC, it can be downloaded from the following website: http://www.chiark.greenend.org.uk/~sgtatham/putty.

Start putty, then select Tunnels in the category tree.

1. Type in 1523 in the Source port, and ah1.appshosting.com:1523 in the Destination field
2. Press Add 
3. You should see L1523 ah1.appshosting.com:1523 appear in the list of Forwarded ports
4. Select Session to get back to the main configuration panel.

5. Next, enter ah1.appshosting.com in the Host Name field
6. Select the SSH radio button
7. Enter ahdb07 in the Saved Sessions field
8. Press Save to save this profile.

9. You should see ahdb07 as a stored session.
10. Select ahdb07, then pressing Load should reload the profile details. Check that the tunneling still exists correctly.

Include the following entry in your "tnsnames.ora" file:

ahdb07=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1523)))
(CONNECT_DATA=(SERVICE_NAME=ahdb07)))

12. Test the connection using SqlPlus or TNSPing.
13. Please contact support@appshosting.com with any questions/Problems.

Please contact AppsHosting with any questions, comments, or suggestions; as we constantly strive for improvement in these areas.