Re: TCP Ports for listener

From: Van Messner <vmessner_at_netaxis.com>
Date: Mon, 18 Oct 1999 19:08:20 -0400
Message-ID: <_LNO3.15652$E_1.905356_at_typ11.nn.bcandid.com>


Unless you have multiple listeners on one server or some specific problem, there is nothing to worry about if your tnsnames.ora aliases each reference 1521 and 1526. Actually 1522, 1523, 1524, 1525 and many other ports will work as well.

Van

Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message news:380B2148.5C228471_at_Unforgettable.com...
> Just learned something else about this.
>
> I have been using SQLNET Easy Configuration on my pc to create alias's. It
> was automatically creating both 1521 and 1526 entries. I did a bit of
> searching and experimenting and discovered that this was occurring because
> of the file:
>
> $ORACLE_HOME/network/cfg/tnsnamed.tcp
>
> which had template entries for both ports. I backed up this file and then
> modified it to get rid of the 1526 entry. I then went back into Easy
> Configuration and created a new alias for one of the databases that I work
> with all the time and saw that after I was done tnsnames.ora had only the
> 1526 entry. What was even more amazing is that the 1521 entries for all of
> the other aliases disappeared as well.
>
> What I am not sure of is whether this is a safe thing to do. There are
some
> systems I work with that I do not have control over what port is used in
> the listener.ora. If I only have 1521 defined in tnsnames.ora and I
connect
> to a system that only has 1526 in the listener.ora I'm going to guess that
> I'll never get the connection.
>
> I wish I had known about this at the beginning of this year when I set up
> about six new databases. I could have enforced the 1521 all across the
> application - now it is too late.
>
>
> Sybrand Bakker wrote:
> >
> > The official port for Oracle is 1521. When sqlnet 2 came into existence
1526
> > was promoted to make sure net 1 and net 2 coexisted. With net8 into
> > existence the story repeats...
> > Note: If you have defined two ports in listener.ora, it will use the
first
> > one. So if you defined both 1521 and 1526 and have 1521 as first in rank
,
> > 1526 will not be used. This means clients with 1526 only, can NOT
connect.
> > Unless you are using two sqlnet products at the same time, you should
use
> > only one port.
> >
> > Hth,
> >
> > --
> > Sybrand Bakker, Oracle DBA
> > Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message
> > news:380B0CE6.C7381518_at_Unforgettable.com...
> > > On some system I work with port 1521 has been mapped to tcp for the
> > > listener while on other system port 1526 is used. On still others,
both
> > > ports are listed in the listener.ora. Is there any historical basis
for
> > > this? Is there any reason to prefer one over the other?
> > >
Received on Tue Oct 19 1999 - 01:08:20 CEST

Original text of this message