2 Replies Latest reply: Apr 30, 2014 6:03 AM by omari RSS

    Integrated replicat abended

    927981

      Hello All,

       

      To implement "Integrated replicate", following steps were used which created the process successfully. After creation while I try to start the process it fails with error (OGG-00870).

       

      1. Database & goldengate version

            Oracle database 12c standard edition one.

            Oracle golden-gate 12.1.2.0

           

      2. Command that was used to create Integrated replicat.

       

      ADD REPLICAT cinvd_rp, INTEGRATED, EXTTRAIL /u01/app/gg/product/12.1.0/dirdat/site1_investigator_d/rt

       

      3. Content of replicat process parameter file.

      REPLICAT cinvd_rp

      setenv (ORACLE_SID=site1)

      USERID ggs_admin, PASSWORD ggs_admin

      DBOPTIONS SETTAG 00

      ASSUMETARGETDEFS

      BATCHSQL

      DISCARDFILE /u01/app/gg/product/12.1.0/dirdat/site3_investigator_d/discard/cinvd_rp.log, PURGE, APPEND Megabytes 500

      DISCARDROLLOVER AT 00:01

      REPORTROLLOVER AT 00:01

      DDLERROR DEFAULT IGNORE

      REPERROR (DEFAULT, DISCARD)

      MAP investigator_d.*, TARGET investigator_d.*;

       

      4. Following is the error message while trying to start the process.

      GGSCI>start cinvd_rp

       

      2014-04-17 15:17:32  INFO OGG-02545  Oracle GoldenGate Delivery for Oracle, ainvd_rp.prm:  Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.
      2014-04-17 15:17:32  INFO OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
      2014-04-17 15:17:45  INFO OGG-02528  Oracle GoldenGate Delivery for Oracle, ainvd_rp.prm:  REPLICAT AINVD_RP successfully registered with database as inbound server OGG$AINVD_RP.

      2014-04-17 15:17:45  ERROR   OGG-00870  Oracle GoldenGate Delivery for Oracle, ainvd_rp.prm:  Database error 23605 (ORA-23605: invalid value "30" for GoldenGate parameter MAX_PARALLELISM

      ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 547

      ORA-06512: at "SYS.DBMS_APPLY_ADM", line 100

      ORA-06512: at line 1 SQL BEGIN dbms_apply_adm.set_parameter(apply_name=>:xin_name, parameter=> :param, value => :value); END;).

      2014-04-17 15:17:45  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, ainvd_rp.prm:  PROCESS ABENDING.

      2014-04-17 15:18:21  INFO OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

       

       

       

      Thanks in advance for your suggestion.

        • 1. Re: Integrated replicat abended
          Mackbell-Oracle

          Try this in the Replicat parameter file:

          DBOPTIONS INTEGRATEDPARAMS (PARALLELISM 1, MAX_PARALLELISM 1)

           

          If that works, shut Replicat back down and then change the max_parrallelism value slowly up and see if Replicat can run with an incrementally higher value.  There may be a min/max limit for Standard Edition.

          • 2. Re: Integrated replicat abended
            omari

            For standard edition the only supported PARALLELISM and MAX_PARALLELISM value is "1". Anyway, even if you set the correct integrated parameters with parallelism '1', the integrated apply is still not working and showing the error "ERROR   OGG-00870  Oracle GoldenGate Delivery for Oracle Database error 23605 (ORA-23605: invalid value "30" for GoldenGate parameter MAX_PARALLELISM" . Although oracle says "it's supported" ??!! that's wired?? i can't find anything related to this. it seems it's a bug.

             

            BR,

            Omari