Xref: alice comp.databases.oracle.misc:44566 comp.databases.oracle.tools:33949 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!logbridge.uoregon.edu!den-news-01.qwest.net!qwest!nntphub.cb.lucent.com!news From: Kenneth C Stahl Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc Subject: Re: TCP Ports for listener Date: Mon, 18 Oct 1999 09:31:52 -0400 Organization: xyzzy Lines: 49 Message-ID: <380B2148.5C228471@Unforgettable.com> References: <380B0CE6.C7381518@Unforgettable.com> <940250473.26779.0.pluto.d4ee154e@news.demon.nl> Reply-To: BlueSax@Unforgettable.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.6 [en]C-CCK-MCD EMS-1.4 (Win95; U) X-Accept-Language: en-US,en 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 wrote in message > news:380B0CE6.C7381518@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? > >