2 Replies Latest reply: Aug 12, 2013 6:40 AM by onkar.nath RSS

    Not Replicating in goldengate

    1023935

      Hi all,

      I  have installed and configured Goldengate and trying to do schema replication of some tables.Somehow i am not able to see the replication happening o  another host the, logs say that replication is started but it is not happening here is the output of the logfile(host1)

       

      2013-07-10 15:38:11  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, psalesab.prm:  EXTRACT PSALESAB started.

      2013-07-10 15:38:11  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.

      2013-07-10 15:38:11  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  Virtual Memory Facilities for: BR

          anon alloc: mmap(MAP_ANON)  anon free: munmap

          file alloc: mmap(MAP_SHARED)  file free: munmap

          target directories:

          /home/oracle/bharat/BR/ESALESAA.

      2013-07-10 15:38:11  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  Virtual Memory Facilities for: COM

          anon alloc: mmap(MAP_ANON)  anon free: munmap

          file alloc: mmap(MAP_SHARED)  file free: munmap

          target directories:

          /home/oracle/bharat/dirtmp.

      2013-07-10 15:38:11  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  Positioning to begin time Jul 10, 2013 3:32:00 PM.

      2013-07-10 15:38:11  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  Positioned to Sequence 195, RBA 20414464, SCN 0.0, Jul 10, 2013 3:32:00 PM.

      2013-07-10 15:38:11  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  EXTRACT ESALESAA started.

      2013-07-10 15:38:11  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  No recovery is required for target file ./dirdat/aa000000, at RBA 0 (file not opened).

      2013-07-10 15:38:11  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  Output file ./dirdat/aa is using format RELEASE 11.2.

      2013-07-10 15:38:12  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  Position of first record processed Sequence 195, RBA 20414480, SCN 0.7509475, Jul 10, 2013 3:32:04 PM.

      2013-07-10 15:38:16  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, psalesab.prm:  Socket buffer size set to 27985 (flush size 27985).

      2013-07-10 15:38:16  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, psalesab.prm:  No recovery is required for target file ./dirdat/ab000000, at RBA 0 (file not opened).

      2013-07-10 15:38:16  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, psalesab.prm:  Output file ./dirdat/ab is using format RELEASE 11.2.

      2013-07-10 19:38:14  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p16505_extr: start=SeqNo: 196, RBA: 17296400, SCN: 0.7530217 (7530217), Timestamp: 2013-07-10 19:38:05.000000, Thread: 1, end=SeqNo: 196, RBA: 17296896, SCN: 0.7530217 (7530217), Timestamp: 2013-07-10 19:38:05.000000, Thread: 1.

      2013-07-10 23:38:22  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p16505_extr: start=SeqNo: 199, RBA: 22544912, SCN: 0.7564997 (7564997), Timestamp: 2013-07-10 23:38:20.000000, Thread: 1, end=SeqNo: 199, RBA: 22545920, SCN: 0.7564997 (7564997), Timestamp: 2013-07-10 23:38:20.000000, Thread: 1.

      2013-07-11 03:38:31  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p16505_extr: start=SeqNo: 200, RBA: 22054416, SCN: 0.7587174 (7587174), Timestamp: 2013-07-11 03:38:23.000000, Thread: 1, end=SeqNo: 200, RBA: 22054912, SCN: 0.7587174 (7587174), Timestamp: 2013-07-11 03:38:23.000000, Thread: 1.

      2013-07-11 07:38:33  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, esalesaa.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p16505_extr: start=SeqNo: 201, RBA: 17974288, SCN: 0.7607602 (7607602), Timestamp: 2013-07-11 07:38:24.000000, Thread: 1, end=SeqNo: 201, RBA: 17974784, SCN: 0.7607602 (7607602), Timestamp: 2013-07-11 07:38:24.000000, Thread: 1.

       

      The output from second host

       

      2013-07-10 06:46:41  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): Edit Param dsalesab.

      2013-07-10 07:04:17  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): Edit Param rsalesab.

      2013-07-10 07:06:11  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): Start Mgr.

      2013-07-10 07:06:21  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): Add Replicat rsalesab  ExtTrail ./dirdat/ab.

      2013-07-10 07:07:01  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host 10.194.180.45 (START SERVER CPU -1 PRI -1  TIMEOUT 300 PARAMS ).

      2013-07-10 07:07:01  INFO    OGG-01677  Oracle GoldenGate Collector for Oracle:  Waiting for connection (started dynamically).

      2013-07-10 07:07:01  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from SERVER on host localhost.localdomain (REPORT 14699 7819).

      2013-07-10 07:07:01  INFO    OGG-00974  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started collector process (Port 7819).

      2013-07-10 07:07:01  INFO    OGG-01228  Oracle GoldenGate Collector for Oracle:  Timeout in 300 seconds.

      2013-07-10 07:07:06  INFO    OGG-01229  Oracle GoldenGate Collector for Oracle:  Connected to 10.194.180.45:36579.

      2013-07-10 07:07:06  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening ./dirdat/ab000000 (byte -1, current EOF 0).

      2013-07-10 07:07:12  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): Start Replicat *.

      2013-07-10 07:07:12  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host standby.dba.com (START REPLICAT RSALESAB ).

      2013-07-10 07:07:12  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT RSALESAB starting.

      2013-07-10 07:07:12  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, rsalesab.prm:  REPLICAT RSALESAB starting.

      2013-07-10 07:07:12  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, rsalesab.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.

      2013-07-10 07:07:12  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, rsalesab.prm:  Virtual Memory Facilities for: COM

          anon alloc: mmap(MAP_ANON)  anon free: munmap

          file alloc: mmap(MAP_SHARED)  file free: munmap

          target directories:

          /home/oracle/goldengate/dirtmp.

      2013-07-10 07:07:13  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rsalesab.prm:  REPLICAT RSALESAB started.

       

      All the process are running please help.