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

Home -> Community -> Usenet -> c.d.o.server -> Re: connecting over internet

Re: connecting over internet

From: Dante <dnotari_at_my-dejanews.com>
Date: Thu, 13 May 1999 18:41:00 GMT
Message-ID: <7hf6bs$mbi$1@nnrp1.deja.com>


Pablo,
  SQL*Net8 on multithreated OS use 1521 to connect and   redirect then the connection to another port.

  After the listener completes the handshake a dedicated   server process is spawned. Server and Client agree the   new port when "handshaking".

  You will need a firewall which supports SQL*Net.   Please contact your local support, they can advice    you if your firewall can be configured or any other    further actions.

Good luck
Dante

In article <7h61ke$og2$1_at_talia.mad.ttd.net>,   "Pablo Marquez" <pmarquez_at_gtt.es> wrote:
> Hi all:
>
> I want to allow access to my Oracle 8 server installed on an AIX
System
> (via SQL Plus or
> TOAD trough RDBMS) via internet.
> The problem is that there is a firewall installed in order to limit
the
> access to the server. So i allow access for an exact IP address and
for port
> 1521
> In the Oracle Net 8 Easy Config says that the client connects to the
port
> 1521.
> When i work in LAN that's correct, but when I try to connect
from 'outside'
> oracle tries to open other ports dinamically (i think in other to
improve
> the bandwidth) so Oracle can't stablish the connection
> My question is if there's any parameter or way to say Oracle that it
must
> open just one port or some well-known ports when connecting from
internet so
> we
> can configure the firewall correctly
>
> thanks a lot
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 13 1999 - 13:41:00 CDT

Original text of this message

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