asked on using ssh tunnel to connect to Oracle
I have several remote systems setup with oracle server. I have the client side (because they are dynamic IPs) open an SSH tunnel to the main office and setup a reverse port so I can login to the remote site Oracle from the main office. This setup works great if the remote server is Linux, if it's Windows I can tnsping the remote server, but when I try to login to SQLPLus I get a No Listener error.
Oracle DatabaseSSH / Telnet Software
Last Comment
revo1059
Your sqlplus client needs to know certain TCP/IP information such as the target host and the database service name. What do your client files look like?
ASKER
It's setup properly. If I connect to a linux server, it works like a charm, try and connect to a Windows system and it won't connect (same client)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Yes sqlplus from that system or any of the clients on that network login fine.