Hi all,
Is it actually possible to connect to a remote db via a SSH tunnel from SQL Developer running on Vista? I have only the SQL Developer package, not a full Oracle client install.
I've found several discussions, both here and elsewhere on the net, that indicate you can create an SSH tunnel to a remote db server, configure a tnsnames.ora file properly on the localhost, and successfully do this. But I consistently receive a "connection reset" error when attempting to do this.
I've downloaded putty and crank up a SSH connection with a tunnel from my laptop to our db server from the command line:
plink -ssh -l <userid> -pw <password> -L 1521:remotehost.tld:1521 remotehost.tld
The tunnel itself seems fine and I have used this approach to successfully tunnel to an http server (meaning I tunneled as above, then was able to point a browser to http://localhost:port and see the web page that is served up from http://remotehost:remoteport).
I have a simple tnsnames.ora file(but no other config files local on my laptop, ie no sqlnet.ora, etc):
ID1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = id1)
)
)
This matches exactly the entry on the remote server tnsnames.ora file (with the obvious exception that instead of "localhost", I have "remotehost.tld" in that file.
But every single time, I get either the "connection reset" message in my SQL Developer client (with is at the 1.5.4 version). I've tried both a basic connection and the TNS connection option from with SQL Developer on the localhost machine, result is the same. I don't have any problem running sqlplus on the remote db server and connecting to the db.
Any suggestion for where to dig into this further? Thanks for any pointers or suggestions, I'm working around a firewall on the remote db server with ssh tunnels and I would have guessed that this would have been much simpler. I'm probably missing something simple.