Hi folks,
I have:
host P: the PC from which I connect
host A: the host I have SSH access to, and that has access to host B
host B: the host where Oracle runs
GOAL: connect to Oracle running on B, from P
On the SSH connection to A, I have created a tunnel from localhost:1527 to B:1527. When I telnet to localhost:1527 I get a reply, so the tunneling works.
But when I use DBVisualizer to try to connect to localhost:1527, I get a ORA-12514 TNS:listener does not currently know of service requested in connect descriptor ...
So clearly I'm missing something. Please note that I have no Oracle software on P, just the free version of DBvisualizer along with the Oracle driver jar file.
Please advise.