Replication

From: Kenneth Herskedal <kenneth.herskedal_at_NOSPAMtrafsys.no>
Date: Fri, 4 May 2001 10:49:26 +0200
Message-ID: <9ctqgk$79q$1@oslo-nntp.eunet.no>

I have replication between two Oracle 8 databases. The replication works, but i slow.

When i check the listener.log, it houndreds of lines telling that a connection is established between the databases. This connections are done 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 *
(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=3520)) * establish * ORCL * 0
04-MAI-01 10:34:17 *
(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=3545)) * establish * ORCL * 0
04-MAI-01 10:35:23 *
(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=3556)) * establish * ORCL * 0
04-MAI-01 10:36:23 *
(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=3580)) * establish * ORCL * 0
04-MAI-01 10:37:29 *
(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=3592)) * establish * ORCL * 0
04-MAI-01 10:38:31 *
(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=3616)) * establish * ORCL * 0
04-MAI-01 10:39:36 *
(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=3629)) * establish * ORCL * 0
04-MAI-01 10:40:38 *
(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=3651)) * establish * ORCL * 0
04-MAI-01 10:41:44 *
(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=3663)) * establish * ORCL * 0
04-MAI-01 10:42:45 *
(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=3686)) * establish * ORCL * 0
04-MAI-01 10:43:51 *
(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=3700)) * establish * ORCL * 0

Thanks for any tip. Received on Fri May 04 2001 - 03:49:26 CDT