1 Reply Latest reply: Apr 16, 2013 2:00 AM by Sachin Kumar Kansal RSS

    replicat process abending with no error in logfile

    993159
      Hi,

      I m trying to replication from 11g to 10g on the same physical host. Below the replicat abending but unable to find the source of error in view GGSEVT logfile.

      GGSCI (rhel5.4_prod) 8> info all
      
      Program     Status      Group       Lag at Chkpt  Time Since Chkpt
      
      MANAGER     RUNNING                                           
      EXTRACT     RUNNING     EXTLOCAL    00:00:00      00:00:07    
      REPLICAT    ABENDED     REPLOCAL    00:00:00      18:12:27 
      
      2013-04-16 09:58:40  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
      2013-04-16 09:58:41  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
      2013-04-16 09:58:45  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start extract extlocal.
      2013-04-16 09:58:45  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host rhel5.4_prod (START EXTRACT EXTLOCAL ).
      2013-04-16 09:58:45  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EXTLOCAL starting.
      2013-04-16 09:58:45  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, extlocal.prm:  EXTRACT EXTLOCAL starting.
      2013-04-16 09:58:45  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
      2013-04-16 09:58:46  INFO    OGG-03500  Oracle GoldenGate Capture for Oracle, extlocal.prm:  WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database
       character set value of US7ASCII.
      2013-04-16 09:58:46  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Virtual Memory Facilities for: BR
          anon alloc: mmap(MAP_ANON)  anon free: munmap
          file alloc: mmap(MAP_SHARED)  file free: munmap
          target directories:
          /u05/GG/BR/EXTLOCAL.
      2013-04-16 09:58:46  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Virtual Memory Facilities for: COM
          anon alloc: mmap(MAP_ANON)  anon free: munmap
          file alloc: mmap(MAP_SHARED)  file free: munmap
          target directories:
          /u05/GG/dirtmp.
      2013-04-16 09:58:46  INFO    OGG-01513  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Positioning to Sequence 22, RBA 18459664, SCN 0.1177097.
      2013-04-16 09:58:46  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Positioned to Sequence 22, RBA 18459664, SCN 0.1177097, Apr 15, 2013 4:21:50 PM.
      2013-04-16 09:58:46  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, extlocal.prm:  EXTRACT EXTLOCAL started.
      2013-04-16 09:58:46  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host rhel5.4_prod (START SERVER CPU -1 PRI -1  TIMEOUT 300 PARAMS ).
      2013-04-16 09:58:46  INFO    OGG-01677  Oracle GoldenGate Collector for Oracle:  Waiting for connection (started dynamically).
      2013-04-16 09:58:46  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from SERVER on host localhost.localdomain (REPORT 4714 7819).
      2013-04-16 09:58:46  INFO    OGG-00974  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started collector process (Port 7819).
      2013-04-16 09:58:46  INFO    OGG-01228  Oracle GoldenGate Collector for Oracle:  Timeout in 300 seconds.
      2013-04-16 09:58:51  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Socket buffer size set to 27985 (flush size 27985).
      2013-04-16 09:58:51  INFO    OGG-01229  Oracle GoldenGate Collector for Oracle:  Connected to rhel5.4_prod:11890.
      2013-04-16 09:58:51  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening /u05/GG/dirdat/aa000000 (byte -1, current EOF 1145).
      2013-04-16 09:58:51  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing /u05/GG/dirdat/aa000000.
      2013-04-16 09:58:51  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Recovery initialization completed for target file /u05/GG/dirdat/aa000000, at RBA 1145.
      2013-04-16 09:58:51  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Output file /u05/GG/dirdat/aa is using format RELEASE 11.2.
      2013-04-16 09:58:51  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening /u05/GG/dirdat/aa000000 (byte 1145, current EOF 1145).
      2013-04-16 09:58:51  INFO    OGG-01735  Oracle GoldenGate Collector for Oracle:  Synchronizing /u05/GG/dirdat/aa000000 to disk.
      2013-04-16 09:58:51  INFO    OGG-01735  Oracle GoldenGate Collector for Oracle:  Synchronizing /u05/GG/dirdat/aa000000 to disk.
      2013-04-16 09:58:51  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing /u05/GG/dirdat/aa000000.
      2013-04-16 09:58:51  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Rolling over remote file /u05/GG/dirdat/aa000001.
      2013-04-16 09:58:51  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening /u05/GG/dirdat/aa000001 (byte -1, current EOF 0).
      2013-04-16 09:58:51  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Recovery completed for target file /u05/GG/dirdat/aa000001, at RBA 1018.
      2013-04-16 09:58:51  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Recovery completed for all targets.
      2013-04-16 09:58:51  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Position of first record processed Sequence 22, RBA 18459664, SCN 0.1177097, Apr 15, 2013 4:21:50 PM.
      2013-04-16 09:58:51  INFO    OGG-00732  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Found crash recovery marker from thread #1 on sequence 23 at RBA 1040. Aborting uncommitted transactions
      .
      2013-04-16 09:58:56  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start replicat replocal.
      2013-04-16 09:58:56  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host rhel5.4_prod (START REPLICAT REPLOCAL ).
      2013-04-16 09:58:56  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REPLOCAL starting.
      2013-04-16 09:58:56  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, replocal.prm:  REPLICAT REPLOCAL starting.
      2013-04-16 09:58:56  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, replocal.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
      2013-04-16 09:58:56  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, replocal.prm:  Virtual Memory Facilities for: COM
          anon alloc: mmap(MAP_ANON)  anon free: munmap
          file alloc: mmap(MAP_SHARED)  file free: munmap
          target directories:
          /u05/GG/dirtmp.
      2013-04-16 09:58:56  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, replocal.prm:  REPLICAT REPLOCAL started.
      Configuration
      GGSCI (rhel5.4_prod) 9> view params mgr
      
      PORT 7809
      USERID ggs_owner, PASSWORD ggs_owner
      PURGEOLDEXTRACTS /u05/GG/dirdat/ex, USECHECKPOINTS
      
      
      GGSCI (rhel5.4_prod) 10> view params extlocal
      
      extract extlocal
      userid ggs_owner, password ggs_owner
      setenv (ORACLE_HOME="/u03/app/oracle/product/11.2.0/db_1")
      setenv (ORACLE_SID="PROD11G")
      rmthost 192.168.1.9, mgrport 7809
      rmttrail /u05/GG/dirdat/aa 
      TABLE TESTUSER.*;
      
      
      GGSCI (rhel5.4_prod) 11> view params replocal
      
      REPLICAT replocal
      SETENV (ORACLE_HOME="/u02/app10g/oracle10g/product/10.2.0/db_1")
      SETENV (ORACLE_SID="PROD10G")
      SETENV (NLS_LANG="AMERICAN_AMERICA.US7ASCII")
      ASSUMETARGETDEFS
      USERID ggs_owner, PASSWORD ggs_owner
      MAP TESTUSER.*, TARGET TESTUSER.*;
        • 1. Re: replicat process abending with no error in logfile
          Sachin Kumar Kansal
          Hi,

          Not sure if you have created a definition file. Try if your source and target has a mismatch. Also, find below some additional parameters which will help in sorting out the issue:

          DISCARDFILE :
          Valid for Extract and Replicat
          Use the DISCARDFILE parameter to generate a discard file to which GoldenGate can log records that it cannot process. Records can be discarded for several reasons. For example,
          a record is discarded if the underlying table structure changed since the record was written to the trail. You can use the discard file to help you identify the cause of processing errors. Each entry in the discard file contains the discarded record buffer and an error code indicating the reason. GoldenGate creates the specified discard file in the dirrpt subdirectory of the GoldenGate installation directory. You can view it with a text editor or by using the following command in GGSCI.

          VIEW REPORT
          Where: is the fully qualified name of the discard file.
          To prevent having to perform manual maintenance of discard files, use either the PURGE or APPEND option. Otherwise, you must specify a different discard file name before starting
          each process run, because GoldenGate will not write to an existing discard file. To set an upper limit for the size of the file, use either the MAXBYTES or MEGABYTES option. If
          the specified size is exceeded, the process will abend. Default By default, GoldenGate does not generate a discard file.

          DISCARDROLLOVER:
          Valid for Extract and Replicat
          Use the DISCARDROLLOVER parameter to set a schedule for aging discard files. For long or continuous runs, setting an aging schedule prevents the discard file from filling up and
          causing the process to abend, and it provides a predictable set of archives that can be included in your archiving routine.
          When the DISCARDROLLOVER age point is reached, a new discard file is created, and old files are renamed in the format of ., where:
          ? is the name of the Extract or Replicat group
          ? is a number that gets incremented by one each time a new file is created, for
          example: myext0.dsc, myext1.dsc, myext2.dsc, and so forth.
          You can specify a time of day, a day of the week, or both. Specifying just a time of day (AT option) without a day of the week (ON option) generates a discard file at the specified time every day.
          Default Disabled. No rules specified.

          REPERROR:
          Use REPERROR to specify an error and a response that together control how Replicat responds to the error when executing the MAP statement. You can use REPERROR at the MAP level to override and supplement global error handling rules set with the REPERROR parameter. Multiple REPERROR statements can be applied to the same MAP statement to
          enable automatic, comprehensive management of errors and interruption-free replication processing.
          DEFAULT Sets a global response to all errors except those for which explicit REPERROR statements are specified.

          GETDELETES | IGNOREDELETES:
          Valid for Extract and Replicat
          Use the GETDELETES and IGNOREDELETES parameters to control whether or not GoldenGate processes delete operations. These parameters are table-specific. One parameter remains in effect for all subsequent TABLE or MAP statements, until the other parameter is encountered.

          GETUPDATES | IGNOREUPDATES:
          Valid for Extract and Replicat
          Use the GETUPDATES and IGNOREUPDATES parameters to control whether or not GoldenGate processes update operations. The parameters are table-specific. One parameter remains in effect for all subsequent TABLE or MAP statements, until the other parameter is encountered.

          GETINSERTS | IGNOREINSERTS:
          Valid for Extract and Replicat
          Use the GETINSERTS and IGNOREINSERTS parameters to control whether or not insert operations are processed by GoldenGate. The parameters are table-specific. One parameter remains in effect for all subsequent TABLE or MAP statements, until the other parameter is encountered.

          Update the parameter file on target as
          edit params <TARGET PARAM FILE>
          REPLICAT rcreator
          SOURCEDEFS /u01/app/oracle/product/goldengate/dirdat/defecreator
          DISCARDFILE /u01/app/oracle/product/goldengate/dirdat/creator_err, purge
          DISCARDROLLOVER ON saturday
          USERID goldengate, PASSWORD AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCRYPTKEY default
          REPERROR (DEFAULT, DISCARD)
          IGNOREDELETES
          IGNOREUPDATES
          GETINSERTS
          MAP meditate.life, TARGET CONSCIOUSNESS.tenure, &
          COLMAP (PERSON_ID=HUMAN_ID, &
          INITIALNAME=FIRSTNAME, &
          ENDNAME=LASTNAME, &
          BIRTH_DATE=DATE_OF_BITH, &
          AGE_AT_DEATH=AGE_AT_TIME_OF_DEATH, &
          DEED_ID_AT_DEATH=DEED_ID_AT_TIME_OF_DEATH), &
          KEYCOLS (PERSON_ID, INITIALNAME,ENDNAME);

          Now stop and start the replicat on target as:

          GGSCI (goldengate) 9> stop replicat RCREATOR

          Sending STOP request to REPLICAT RCREATOR ...
          Request processed.
          GGSCI (goldengate) 10> info all