Hi all.
I'm still trying to turn on my simple GoldenGate replication on my local Oracle 12c(version 12.1.0.2) with GoldenGate package version 12.2.0.1. I've turned on primary extract, datapump and replicat on local machine. Further are my properties file for all processes:
For replication I've created common user named GGADMIN:
sqlplus / as sysdba
SQL> create user C##GGADMIN identified by 1234;
SQL> exec dbms_goldengate_auth.grant_admin_privilege('C##GGADMIN',container=>'ALL');
SQL> grant dba to c##ggadmin container=all;
Then I created two schemas in PDBORCL(REPSCHEMA and TARGETSCHEMA). One for source and one for target table(SOURCE_TABLE and TARGET_TABLE). Both tables definition absolutely the same.
---This is primary extract from pluggable database PDBORCL
EXTRACT test_ext
USERID C##GGADMIN@orcl, PASSWORD 1234
LOGALLSUPCOLS
EXTTRAIL .\dirdat\tf
TABLE PDBORCL.REPSCHEMA.SOURCE_TABLE;
---This is datapump extract
EXTRACT test_pm
USERID C##GGADMIN@orcl, PASSWORD 1234
RMTHOST localhost, MGRPORT 7809
RMTTRAIL .\dirdat\pm
TABLE PDBORCL.REPSCHEMA.SOURCE_TABLE;
---This is primary replicat properties
REPLICAT test_rep
USERID C##GGADMIN@pdborcl, PASSWORD 1234
DISCARDFILE ./dirrpt/test_rep.dsc, PURGE
ASSUMETARGETDEFS
MAP PDBORCL.REPSCHEMA.SOURCE_TABLE, TARGET PDBORCL.TARGETSCHEMA.TARGET_TABLE;
---This is simple property for OGG Manager
PORT 7809
Also I created configs for initial extract and replicat:
---This is initial extract config
EXTRACT init_ext
USERID C##GGADMIN@orcl, PASSWORD 1234
RmtHost localhost, mgrport 7809
RmtTask Replicat, Group init_rep
TABLE PDBORCL.REPSCHEMA.SOURCE_TABLE;
---This is initial extract config
REPLICAT init_rep
USERID C##GGADMIN@pdborcl, PASSWORD 1234
ASSUMETARGETDEFS
MAP PDBORCL.REPSCHEMA.SOURCE_TABLE, TARGET PDBORCL.TARGETSCHEMA.TARGET_TABLE;
Then I prepared databases and tables for replication:
sqlplus / as sysdba
SQL> shutdown abort
SQL> startup nomount
SQL> alter database mount;
SQL> alter database open;
SQL> alter pluggable database all open;
GGSCI 1> dblogin userid C##GGADMIN@PDBORCL, PASSWORD 1234
GGSCI (C##GGADMIN@orcl/PDBORCL) 2> add schematrandata pdborcl.REPSCHEMA
GGSCI (C##GGADMIN@orcl/PDBORCL) 3> add trandata pdborcl.REPSCHEMA.SOURCE_TABLE
Then I registered and added primary extract process:
GGSCI > dblogin userid c##ggadmin, password 1234
GGSCI(C##GGADMIN@orcl) > REGISTER EXTRACT test_ext DATABASE CONTAINER(PDBORCL)
GGSCI (C##GGADMIN@orcl) > ADD EXTRACT test_ext , INTEGRATED TRANLOG, BEGIN NOW
Added remote trail
GGSCI (C##GGADMIN@orcl) > ADD RMTTRAIL .\dirdat\pm, EXTRACT test_ext
Added primary replicat
GGSCI (C##GGADMIN@orcl)> ADD REPLICAT test_rep, INTEGRATED, EXTTRAIL .\dirdat\tf
Added initial extract and replicat
GGSCI (C##GGADMIN@orcl) > ADD EXTRACT init_ext, SOURCEISTABLE
GGSCI (C##GGADMIN@orcl) > ADD REPLICAT init_rep, SPECIALRUN
And started manager, extracts and replicats
GGSCI (C##GGADMIN@orcl) > START MGR
GGSCI (C##GGADMIN@orcl) > START EXTRACT init_ext
GGSCI (C##GGADMIN@orcl) > START EXTRACT test_ext
GGSCI (C##GGADMIN@orcl) > START REPLICAT test_rep
All processes are running, no errors in logs but trail files are empty and no any rows and DML changes transferred to target table.