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: TCP Ports for listener

Re: TCP Ports for listener

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Mon, 18 Oct 1999 09:31:52 -0400
Message-ID: <380B2148.5C228471@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 Mon Oct 18 1999 - 08:31:52 CDT

Original text of this message

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