Re: ORACLE TCP port usage

You'll have to search dejanews but there was a detailed posting a month or so ago. The gist was that while you can specify which port to use (1521 and 1526 are the most common), going through the firewall may involve a random assignment of ports so that you can't just list them in tnsnames.ora. Find the post cause it has the solution.

Van

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in message news:8cd30c$j4o$1_at_soap.pipex.net...
> IIRC and it has been a long day
>
> 1521 (and maybe 1526) are required for the listener to receive requests
for
> a connection from a client. the actual connection is then handed off to a
> free tcp port. To use thru a firewall i believe you need to look at using
> connection manager. Otherwise it might be worth sqlplussing to internet
> databases with system/manager to see what people are exposing!
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Patrick van Zuilen" <pzuilen_at_capgemini.nl> wrote in message
> news:8ccnl9$9l7$1_at_news1.xs4all.nl...
> > Look in TNSNAMES.ORA file.
> > Here is port the port number default 1521
> >
> > Dmitry Yakimenkov <ericfdha_at_mail.od.ua> wrote in message
> > news:8cbu9p$13s$1_at_toster.Te.NeT.UA...
> > > Hello!
> > > Can somebody help me to know, what ports does Oracle use for it
> connection
> > > between client and server, and how to control ports reservation. I
have
> to
> > > do this because of firewall.
> > > Thanks!
> >
>
> --------------------------------------------------------------------------
> > --
> > > Dmitry Yakimenkov
> > >
> > >
> > >
> >
> >
>
>
Received on Tue Apr 04 2000 - 18:54:26 CDT