How can I access the Oracle database web interface from an external network?
Because our Oracle server is protected by a firewall, you will have to create an SSH tunnel to access Oracle. To create a tunnel using the ssh command in the command line, simply run “ssh -fNL 1158:oracle.lcsee.wvu.edu:1158 USERNAME@oracle.lcsee.wvu.edu”. After authenticating, you should now be able to browse to https://localhost:1158/em to access the Oracle Enterprise Manager. To create the tunnel with PuTTY, you will have to define a tunnel in the configuration. To do so, first select the Tunnels tab on the left. Add a new local tunnel with 1158 as the Source port, and oracle.lcsee.wvu.edu:1158 as the Destination. On the Session tab, make sure you are SSH’ing to oracle.lcsee.wvu.edu instead of shell. Open the connction, and you should be able to browse to https://localhost:1158/em to access the Oracle Enterprise Manager.