Ssh, Putty, Tunnel and Ora-12541 Error

 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 Received on Wed Apr 13 2005 - 15:49:32 CDT