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

On Wed, 13 Apr 2005 22:49:32 +0200, "Dario" <thebedroom71_at_hotmail.com> wrote:

> 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
>

You are aware 127.0.0.1 is the localhost addy (so it will NEVER EVER send anything from your system to any other system) You did check you actually have a listener running? Why do you believe the error message is wrong and you need more hacks to put yourself deeper in trouble?
Why are you running NT4. It was desupported ages ago!

--
Sybrand Bakker, Senior Oracle DBA