Re: Ports used by Oracle

From: Andrei <andreyNSPAM_at_bookexchange.net>
Date: Wed, 25 Apr 2001 21:31:37 GMT
Message-ID: <3ae74314.1227804900@news.earthlink.net>

listener listens on port 1521, or any other port u ask it to listen to.
the actual connection uses a port above that 25-APR-2001 17:30:39 *
(CONNECT_DATA=(SID=HOOP)(CID=(PROGRAM=)(HOST=canal)(USER=prod) )) * (ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=46514)) * establish * HOOP * 0 check your listener.log file.

On Wed, 25 Apr 2001 12:59:37 +0100, "Jason Bowsher" <jason.bowsher_at_remoteapps.com> wrote:

>We are currently using an application which is told to connect to an Oracle
>database on port 1521 via a Oracles JDBC thin driver.
>
>I have noticed that when this application queries an Oracle 8.1.6 database
>on an x86 LINUX RH6.2 server a snoop shows that communication takes place at
>port 1521 on the Oracle server. As illustraded below:
>
>client -> database TCP D=1521 S=51940 Ack=3872836040 Seq=1737507242 Len=745
>Win=24820
>
>database -> client TCP D=51940 S=1521 Ack=1737507987 Seq=3872836040 Len=43
>Win=32780
>
>client -> database TCP D=1521 S=51940 Ack=3872836083 Seq=1737507987 Len=22
>Win=24820
>
>database -> client TCP D=51940 S=1521 Ack=1737508009 Seq=3872836083 Len=655
>Win=32780
>
>
>
>However when the same host and application query an Oracle 8.1.6 database on
>a SPARC Solaris8 server a snoop shows that communication takes place on
>various high numbered ports. As illustrated below;
>
>
>
>client -> database TCP D=54710 S=51938 Ack=2435930103 Seq=1701721649 Len=746
>Win=24840
>
>database -> client TCP D=51938 S=54710 Ack=1701722395 Seq=2435930103 Len=51
>Win=24840
>
>client -> database TCP D=54710 S=51938 Ack=2435930154 Seq=1701722395 Len=22
>Win=24840
>
>database -> client TCP D=51938 S=54710 Ack=1701722417 Seq=2435930154 Len=663
>Win=24840
>
>
>
>Can anyone tell me if there is some Oracle configuration parameter which
>would result in the server not using port 1521. I believe that the
>listeners on the oracle server are configured to use port 1521.
>
>
>
>
>
>Jason
>
>
>

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Wed Apr 25 2001 - 16:31:37 CDT