Re: Oracle 9i - Putty - tnsping works - connection does not!

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 08 May 2006 01:50:08 GMT
Message-Id: <pan.2006.05.08.01.50.07.953698@sbcglobal.net>

On Sun, 07 May 2006 10:39:39 -0700, Vladimir M. Zakharychev wrote:

>>On Sat, 06 May 2006 20:09:35 -0700, davidhbigelow wrote:
>>> The remote machine is setup as follows:
>>> Listener IS RUNNING:
>>> Port 1521
>>
>>> Local Machine:
>>> hosts file --> 127.0.0.1 <remotemachinename>

127.0.0.1 is local host, so called "loopback adapter" (lo0). There are no conceivable circumstances in which lo0 adapter could be on a remote machine.

>>
>>
>>Now this is sneaky! I would never have thought of this. I was under the
>>impression that 127.0.0.1 is always local host, never "remote machine"

>
> Well, under certain circumstances it can be "remote machine",
> SSH tunneling OP tries to use is one bold example.

Very bold. So bold that it doesn't work. Mission of such configuration is to boldly go where no DBA has gone before.

>

>>> Putty Configuration:
>>> Listen: 1500

>

>> What is "Putty" listetning to?

>
> To your connections on local TCP port 1500, so that you
> make a connection to localhost:1500 and PuTTY tunnels
> it to configured remote host and port, encrypting and
> compressing it on the way, and tunnels back remote's
> responses.
>

>>> Pass to: <remotemachineIPaddress>:1521
>>
>>
>>What is that? Get yourself a DBA who knows basic networking and have him
>>configure your PC. your configuration is so mixed up that it cannot
>>possibly work.

>
> It's not really messed up and it can work just fine - I routinely use
> SSH tunneling in similar way to communicate to remote applications
> and databases securely, however there is probably something wrong
> on remote side in OPs' case.

Really?

> Without knowing more about remote
> host config

That's where the whole thing is done: on the firewall side. You must have something like
LocalForward 1500 dbhost:1521 on the remote side. You also must have gateway ports enabled.

-- 
http://www.mgogala.com

Received on Sun May 07 2006 - 20:50:08 CDT