Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Accessing Oracle server from client which is behind firewall/proxy on intranet

Re: Accessing Oracle server from client which is behind firewall/proxy on intranet

From: Bilal Muddassir <bilalmuddassir_at_hotmail.com>
Date: Mon, 14 Oct 2002 05:34:04 +0500
Message-ID: <aod3n2$l7oef$1@ID-115987.news.dfncis.de>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:7cnjqu413gbto1vfltptmg4f281s1asmn6_at_4ax.com...
> On Sun, 13 Oct 2002 11:47:39 +0500, "Bilal Muddassir"
> <bilalmuddassir_at_hotmail.com> wrote:
>
> >Hello
> >
> >If my client host is on an intranet and there is a proxy server or
firewall
> >between the client and the rest of the Internet, how can I use Oracle
client
> >applications like SQLPLUS etc on the client host and connect to an Oracle
> >server connected to the Internet outside the intranet?
> >
> >Do I need to ask the proxy/firewall administrator to open the tcp/1521
port?
> >
> >-Bilal
> >
>
> Insufficient info from your side. Oracle will by default use 2 ports,
> the default 1521 port and a random one, different per session.
> This can be resolved by setting use_shared_sockets, but as you neither
> provide a platform nor a version I can't provide an exact command.
> You could also setup connection manager (in 8i and higher) to deal
> with it, or MTS.
> But then again, there are firewall vendor who have so-called sqlnet
> proxies to resolve it for you.
> So really can't tell whatever will most suit you.
> To reply remove -verwijderdit from my e-mail address

I am sorry let me picturize more clearly.

There are two Oracle servers. One Oracle server 7 (O1) is directly linked to the Internet through its own ISP. It runs on Intel based Windows 2000 Server platform. Second Oracle server 8 (O2) is linked to the Internet through a gateway/firewall/proxy through a second ISP. It runs on Bull based AIX platform. We were trying to run Oracle clients on O2. Eventually both O1 and O2 would have to talk to each other on their own, via triggers, for purposes like replication etc.

As you mentioned I could use shared socket but only on Windows platforms. I don't think there is any firewall support but I would try to confirm. For the time being lets rule it out. Connection Manager: can it be installed on the version 7? If all triggers are to be installed on the O2 (version 8) I think we can do it with only one Connection Manager near O2.

Please review. Received on Sun Oct 13 2002 - 19:34:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US