Re: tns trivia question on a Friday afternoon
Date: Fri, 8 Apr 2016 15:57:23 -0600
Message-ID: <57082943.2000808_at_gmail.com>
The Oracle 7 doc
(http://www.oracle.com/technetwork/documentation/oracle7-091910.html) pretty much only refers to 1521 with an occasional second reference to 1526 in the Windows server manual..
I do know that Oracle 7 docs talk about SQL*Net version 2. 1575 was used for Oracle Names. SQL*Net v1 (Oracle 6 and possibly early Oracle 7??) used 1525. So the switch to 1521 might have been to allow concurrent access to the two protocols. Grey cells not functioning, and I no longer have my 7.0.32 docs.
Back in those days, each UNIX Oracle instance usually had it's own listener to allow the DBA to do 'fine grained access' - if the db was down, bring the listener down as well so new connections would fail and user would get a message. Each listener needed it's own port. IIRC, we would configure a dedicated server listener on one port and possibly a shared (multi-threaded server) on a separate port.
Things have changed with self-registering services. I still hear of people using the "one database - one listener" rule, but that is obsolete. The new rule should be "one purpose - one listener", where "purpose" is generally one of 'standard connection to any database, including PDB'; 'high connection rate load balancing', 'data guard and HA', 'VIP', 'SCAN'. /Hans
On 08/04/2016 12:40 PM, Patrice sur GMail wrote:
> In Oracle 7.3 the listener used to listen on ports 1523 and 1521, then
> in Net 8.0 only 1521 (If I remember it right).
>
> What's the deal with 1523?
> Was that the original port used by Oracle SQL*Net in the older versions?
> Was it introduced in Oracle 6 perhaps?
> Why the switch to 1521.
>
>
> Are there any old fogies on this list? :-)
>
> Searching for Oracle 7.3 items in Google turns up nothing. Google
> used to only provide us with what we asked but now... it's fudging and
> obfuscating.
>
>
>
> -- Patrice
>
> My profiles: Facebook
> <http://www.facebook.com/home.php?#%21/profile.php?id=100000206805521>LinkedIn
> <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>Twitter
> <http://www.twitter.com/PatriceBoivin>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 08 2016 - 23:57:23 CEST