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.