Is it possible to tunnel oracle connection?

There are:
1. client in LAN without fixed IP address, behind firewall, with only http
connection to Internet (no others ports enabled)
2. server in other LAN with the same resctrictions as client.

Can client connect to server via some king of tunneling?
Please help. I know there are some standard tools (ie. stunnel), but I
cannot reconfigure Oracle Server (I have no access).

Please, help.
Kasztelann

Look at Oracle Connection Manager (CMAN)
It does exactly that
Good to connect thru firewalls

--
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"monisiatko" <monisiatko (AT) neostrada (DOT) pl> a écrit dans le message de
news:cd4431$3pr$1 (AT) nemesis (DOT) news.tpi.pl...

I read something about CMAN, and all look good except one thing:
as schema in Oracle Help shows, CMAN (installed on separate server) is
connecting to Oracle Server directly -
it is not possible in my case, because Oracle Server is also in LAN, and has
no access to WWW.
Only PCs in LAN have access to it. What you think ?

Hi,

you can use an ssh tunnel. There is a link to two papers about this on
my site http://www.petefinnigan.com/orasec.htm. Search on the oage with
CTRL-F for "ssh" and you will find a paper by Roger Schrag about
securing Oracle networking, he talks about using ssh and there is also a
short paper showing how to tunnel SQL*Plus using ssh.

hth

kind regards

Pete
--
Pete Finnigan
emailete (AT) petefinnigan (DOT) com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.