Re: Ssh, Putty, Tunnel and Ora-12541 Error

"Dario" <thebedroom71_at_hotmail.com> wrote in message news:d3k0kq$ld$1_at_news.ngi.it...
> Installed OpenSsh on a Nt4 server with Oracle8i.
>
> Now i need to connect from a client outside using putty, so i added a
> tunnel with:
>
> Source port: 9902
> Destination: 127.0.0.1:1521
>
> on the client, i use Oracle9i Client ( sql plus, net manager , enterprise
> manager console) and i modified the client tnsnames.ora in this way:
>
> TESTDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 9902))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = TESTDB)
> )
> )
>
> well,
> if i test the connection with TNSPING.EXE TESTDB the result is successful
> (it return ok with time in msec)
>
> but if i try to open a connection using sqlPlus, or Net Manager, or the
> Enterprise Manager, i got the error ORA-12541: TNS: no listener
>
> Are there any other tcp ports ?
> why the ping works, while other apps not ?
>
>
> thank you in advance...
>
> bye,
> Dario
>
>

here is what we do here

Source Port 1521
Destination <IPAddress of remote server>:1521

Keep your tnsnames file as it is

in your hosts file, instead of 127.0.0.1 being localhost put the hostname of the remote server

add another hosts entry with the real ip address / server name

connect to server ensuring 1521 is forwarded

connect away.

Use it al the time here for other ports and 1521 Received on Wed Apr 13 2005 - 16:43:10 CDT