RE: ye olde 1521

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <hporas@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Feb 2005 10:12:24 -0500


        Just checked one of my HP-UX servers and while port 1521 is
certainly busy, it's not the only one by far.=20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Henry Poras [mailto:hporas@xxxxxxxxxxx]=20
Sent: Friday, February 04, 2005 10:01 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: ye olde 1521

Just wondering if one of my strongly held untested assumptions is wrong.
I always thought that when you connected to Oracle via the listener in
dedicated server mode, you would come in via the listener port (i.e.
1521, 1526). The listener would then validate, spawn off a shadow
oracleSID process using some arbitrary port, and the client would then
be passed to this process with the listener butting out at that point.
The client would then be connected to the database through that
arbitrary port.
Last week a developer and myself checked this out. He sniffed the coming
and going of packets, and everything used only port 1521. I looked at
netstat (I think the parameters were asp (RedHat AS3 OS) but I'm not
sure. That info is at work but I'm not at the moment) and the only
active Oracle ports were also 1521. Are other ports used? Is this
dependent on load? I searched metalink and found the question asked, but
no answers were ever posted.




Other related posts: