Replication
Date: Mon, 7 May 2001 18:17:40 +0200
Message-ID: <9d6htr$a1f$1_at_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.
Regards
Kenneth
www.trafsys.no
Received on Mon May 07 2001 - 18:17:40 CEST