Re: port forwarding and oracle

I've done this successfully without problems between a winnt and oracle 
8.1.7 this is my config:
listener.ora in the Solaris server:
lst_estad =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST=whatever)(PORT = 1528))
     )
   )
 )

SID_LIST_lst_estad =
 (SID_LIST =
   (SID_DESC =
     (GLOBAL_DBNAME = ESTAD)
     (ORACLE_HOME = /opt/oracle/product/8.1.7)
     (SID_NAME = ESTAD)
   )
 )

STARTUP_WAIT_TIME_lst_estad = 0
CONNECT_TIMEOUT_lst_estad = 10

The tnsnames.ora on the localmachine is:
ESTAD_TUNNEL =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1702))
   )
   (CONNECT_DATA =
     (SID = ESTAD)
   )

Making a tunnel with cygwin with this line, i think this is your problem:
ssh -L 1702:localhost:1528 root@whatever

you can do this:
C:\oracle\ora81\network\ADMIN>tnsping estad_tunnel
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 
26-OCT-2004 09:25:55
(c) Copyright 1997 Oracle Corporation.  All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1702))
Realizado correctamente (440 mseg)


Best regards
David Roman Esteban


Chris Cheshire wrote:

> Has anyone got port forwarding to work with an oracle database?
>
> I have OpenSSH 3.9p1 on my database server (Oracle 8i running Solaris 
> 2.6) and my client is a PowerBook (running OSX 10.3.5) with OpenSSH 
> 3.6p1 (I wish apple would update this) and when I try to set up the 
> port forward the connection (using java thin client drivers) through 
> it times out. Running the following from the client :
>
> ssh -v -L 2521:dbserver:1521 user@dbserver
>
> connects successfully and starts up a shell and then when I connect 
> using the java thin client () I get :
>
> debug1: Connection to port 2521 forwarding to dbserver port 1521 
> requested.
> debug1: channel 3: new [direct-tcpip]
> debug1: channel 3: open confirm rwindow 131072 rmax 32768
> debug1: channel 3: read<=0 rfd 9 len 0
> debug1: channel 3: read failed
> debug1: channel 3: close_read
> debug1: channel 3: input open -> drain
> debug1: channel 3: rcvd eof
> debug1: channel 3: output open -> drain
> debug1: channel 3: obuf empty
> debug1: channel 3: close_write
> debug1: channel 3: output drain -> closed
> debug1: channel 3: ibuf empty
> debug1: channel 3: send eof
> debug1: channel 3: input drain -> closed
> debug1: channel 3: send close
> debug1: channel 3: rcvd close
> debug1: channel 3: is dead
> debug1: channel 3: garbage collecting
> debug1: channel_free: channel 3: direct-tcpip: listening port 2521 for 
> dbserver port 1521, connect from 127.0.0.1 port 49818, nchannels 4
>
>
> All this happens almost immediately, and the connection takes a 
> further minute or so to time out.
>
> Any suggestions?
>
> Thanks
>
> Chris

--
Un saludo
David Román Esteban
droman@plcendesa.com
(+34)669229194