Re: Connection oracle over internet

dave mausner wrote:

> hduchenne_at_fr.perenco.com (Hervé DUCHENNE CRETIER) wrote in
> <84sn31$h9t$1_at_jaydee.iway.fr>:
>
> >Hello all and happy new year
> >
> >I'm trying to connect my oracle database from the internet.
> >I use a router with NAT feature to access inside our network.
> >
> >I map the ip/1525 of my router to the ip/1525 of my oracle listner in my
> >network.
> >
> >When I make a telnet to this port, it seems to connect, but when I make a
> >sqlplus nothing happen.
> >May be there is another port to use ? which I forgot in the mapping ?
> >
>
> check your TNSNAMES.ORA and be sure that it uses the same port number as
> the server.
> --
> dave mausner

The listener listens for new connections on port 1525. Incoming connection requests
are then mapped to an arbitrary other port; could it be this is what happens? Consequently, the router can block this connection. There is an option (which I can't recall right now - sorry) to force sql*net to use one and only one port, you'll need to check the doc.

BTW the "standard" port for oracle is 1521, the 1521/1525 combination is from the times net V1 and V2 were used concurrently - V1 listening on 1521, V2 on 1525.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle