Re: s...port's - problem

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Tue, 28 Jun 2005 18:32:20 GMT
Message-ID: <UIgwe.11294$h5.683419@news3.tin.it>

Frank van Bortel wrote:

> Netstat -a does show the listener:
> SQL> !netstat -a
> Active Internet connections (servers and established)
> Proto Recv-Q Send-Q Local Address Foreign Address
> State
> tcp 0 0 *:32768 *:*
> LISTEN
> tcp 0 0 localhost.localdomain:32769 *:*
> LISTEN
> tcp 0 0 *:netbios-ssn *:*
> LISTEN
> tcp 0 0 *:sunrpc *:*
> LISTEN
> tcp 0 0 *:10000 *:*
> LISTEN
> tcp 0 0 *:1522 *:*
> LISTEN
> tcp 0 0 *:2484 *:*
> LISTEN
> tcp 0 0 *:microsoft-ds *:*
> LISTEN
> tcp 0 0 csdb01.cs.nl:1522 csdb01.cs.nl:6041
> ESTABLISHED
> tcp 0 0 csdb01.cs.nl:6041 csdb01.cs.nl:1522
> ESTABLISHED
> (sorry - this wraps)
>

tcp        0      0 *:1522                      *:*

is the listener.

tcp        0      0 csdb01.cs.nl:1522           csdb01.cs.nl:6041
      ESTABLISHED
  tcp        0      0 csdb01.cs.nl:6041           csdb01.cs.nl:1522
      ESTABLISHED

Is showing only one connection: second line from client to server while the first line the opposite: from server to client.

> So I think you may be put on the wrong feet by my netstat *-e*,
> not using *-a*.
> What you see in the listing is both sides of the connection;
> Local Address Foreign Address State
> csdb01.cs.nl:1522 csdb01.cs.nl:6041 ESTABLISHED
> csdb01.cs.nl:6041 csdb01.cs.nl:1522 ESTABLISHED
>
> The first entry is the listener->client, the second client->listener.
> Even your listener log will show it:
> 28-JUN-2005 19:27:57 *
> (CONNECT_DATA=(SID=o10gR1)(CID=(PROGRAM=sqlplus)(HOST=csdb01.cs.nl)(USER=oracle10)))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.199)(PORT=6037)) * establish *
> o10gR1 * 0
> 28-JUN-2005 19:28:35 *
> (CONNECT_DATA=(SID=o10gR1)(CID=(PROGRAM=sqlplus)(HOST=csdb01.cs.nl)(USER=oracle10)))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.199)(PORT=6041)) * establish *
> o10gR1 * 0
>
> And so on...

This log show the client side connection. The 6037 and 6041 are on the client side.

The server side 8as showed in your netstat) is always the 1522.

You can see it better by using lsof or opening the connection from a client not on the server machine.

What you have to demostrate, if you want to prove that I'm wrong, is that the server process is communicating on a port different from 1522.

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Tue Jun 28 2005 - 13:32:20 CDT