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>