Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: listener.log
Kenneth Herskedal wrote:
> When i check the listener.log, it houndreds of lines telling that a
> connection is established between the two replicated databases. These
> connections are on many different ports?
> Why all these connections on all TCP/IP ports?
> Is it possible to configure the replication to connect only once?
> Cut from listener.log:
> 04-MAI-01 10:31:06 *
> (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=d:\orant\bin\oracle80.exe)(HOST=G2-DAT
> ABA)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.33.0.10)(PORT=3484)) *
> establish * ORCL * 0
> 04-MAI-01 10:32:10 *
> (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=d:\orant\bin\oracle80.exe)(HOST=G2-DAT
> ABA)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.33.0.10)(PORT=3507)) *
> establish * ORCL * 0
> 04-MAI-01 10:33:16 *
> [snip]
Kenneth,
The port numbers you see in this logfile are the port numbers from the
client
side of the connection. If is a property of the TCP/IP networking
protocol
(in any implementation) that the port number is a more or less random
number.
I can't tell you why it reconnects every time, I'll leave that to someone else.
Erwin Received on Thu May 10 2001 - 15:09:02 CDT