Re: port forwarding and oracle
From: David Roman Esteban (droman_at_plcendesa.com)
Date: 10/26/04
- Previous message: Jesse Waters: "Re: port forwarding and oracle"
- In reply to: Chris Cheshire: "port forwarding and oracle"
- Next in thread: Chris Cheshire: "Re: port forwarding and oracle"
- Reply: Chris Cheshire: "Re: port forwarding and oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 26 Oct 2004 09:32:33 +0200 To: Chris Cheshire <ccheshire@bigredwire.com>
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
- Previous message: Jesse Waters: "Re: port forwarding and oracle"
- In reply to: Chris Cheshire: "port forwarding and oracle"
- Next in thread: Chris Cheshire: "Re: port forwarding and oracle"
- Reply: Chris Cheshire: "Re: port forwarding and oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
