[oracle@node1 ogg12c]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:25:11 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect /as sysDBA
Connected.
SQL> alter system set enable_goldengate_replication=true;
System altered.
SQL> grant set container to c##ggadmin;
Grant succeeded.
SQL> grant dba to c##ggadmin;
Grant succeeded.
SQL> select privilege from dba_sys_privs where grantee = 'C##GGADMIN';
PRIVILEGE
----------------------------------------
DROP ANY EDITION
CREATE JOB
ALTER ANY TABLE
UNLIMITED TABLESPACE
ALTER SESSION
CREATE RULE SET
LOGMINING
SET CONTAINER
FLASHBACK ANY TABLE
CREATE ANY EDITION
CREATE RULE
PRIVILEGE
----------------------------------------
EXECUTE ANY RULE SET
CREATE EVALUATION CONTEXT
SELECT ANY TABLE
CREATE SESSION
DEQUEUE ANY QUEUE
UNLIMITED TABLESPACE
17 rows selected.
SQL> exec dbms_goldengate_auth.grant_admin_privilege('c##ggadmin','capture',container=>'all');
PL/SQL procedure successfully completed.
SQL> grant create session to c##ggadmin;
Grant succeeded.
SQL> grant alter session to c##ggadmin;
Grant succeeded.
SQL> grant set container to c##ggadmin;
Grant succeeded.
SQL> select privilege from dba_sys_privs where grantee = 'C##GGADMIN';
PRIVILEGE
----------------------------------------
CREATE JOB
ALTER ANY TABLE
UNLIMITED TABLESPACE
ALTER SESSION
CREATE RULE SET
LOGMINING
SET CONTAINER
FLASHBACK ANY TABLE
CREATE RULE
EXECUTE ANY RULE SET
CREATE EVALUATION CONTEXT
PRIVILEGE
----------------------------------------
SELECT ANY TABLE
CREATE SESSION
DEQUEUE ANY QUEUE
UNLIMITED TABLESPACE
15 rows selected.
SQL> alter user c##ggadmin default tablespace users;
User altered.
SQL> alter user c##ggadmin quota unlimited on users;
User altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (node1) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (node1) 3> dblogin userid c#ggadmin,password oracle
ERROR: Unable to connect to database using user c#ggadmin. Please check privileges.
Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied.
GGSCI (node1) 4> dblogin userid c#ggadmin ,password oracle
ERROR: Unable to connect to database using user c#ggadmin. Please check privileges.
Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied.
GGSCI (node1) 5> dblogins userid c##ggadmin,password oracle
ERROR: Invalid command.
GGSCI (node1) 6> dblogin userid c##ggadmin,password oracle
Successfully logged into database CDB$ROOT.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7>
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7>
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7>
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7> add extract ext1, integrated tranlog, begin now
EXTRACT (Integrated) added.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 8> register extract ext1 database container(pdb1)
2016-10-07 07:32:08 INFO OGG-02003 Extract EXT1 successfully registered with database at SCN 1879420.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 9> add schematrandata pdb1.source
2016-10-07 07:32:40 ERROR OGG-01789 Failed to ADD SCHEMATRANDATA on schema source, because schema does not exist.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 10> add schematrandata pdb1.test
2016-10-07 07:32:59 INFO OGG-01788 SCHEMATRANDATA has been added on schema test.
2016-10-07 07:32:59 INFO OGG-01976 SCHEMATRANDATA for scheduling columns has been added on schema test.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 11> add exttrail ./dirdat/ex, extract ext1
EXTTRAIL added.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 12> add checkpointtable pdb1.c##ggadmin.checkpoint
Successfully created checkpoint table pdb1.c##ggadmin.checkpoint.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 13> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:04:29
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 14> exit
[oracle@node1 ogg12c]$ sqlplus c##ggadmin/pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:36:14 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: ^C
[oracle@node1 ogg12c]$
[oracle@node1 ogg12c]$ sqlplus c##ggadmin/oracle@pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:36:33 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@node1 ogg12c]$ cd
[oracle@node1 ~]$ cd $ORACLE_HOME/network/admin
[oracle@node1 admin]$ ls
listener.ora samples shrept.lst sqlnet.ora tnsnames.ora
[oracle@node1 admin]$ vi tnsnames.ora
[oracle@node1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DEV12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dev12c)
)
)
PDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb1)
)
)
PDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb2)
)
)
[oracle@node1 admin]$
[oracle@node1 admin]$
[oracle@node1 admin]$ sqlplus c##ggadmin/oracle@pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:37:53 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Fri Oct 07 2016 07:31:11 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> create user test identified by oracle account unlock;
User created.
SQL> alter user test quota unlimited on users;
User altered.
SQL> grant connect,resource,create session to test;
Grant succeeded.
SQL> connect test/oracle
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> connect test/oracle@pdb2
Connected.
SQL> create table source(id int primary key);
Table created.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@node1 admin]$ cd $GGHOME
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:07:58
GGSCI (node1) 2> view params ext1
ERROR: PARAMS file ext1 does not exist.
GGSCI (node1) 3> edit params ext1
GGSCI (node1) 4> viewparams ext1
ERROR: Invalid command.
GGSCI (node1) 5> view params ext1
EXTRACT ext1
USERID c##ggadmin, PASSWORD oracle
EXTTRAIL ./dirdat/ex
SOURCECATALOG pdb1
TABLE TEST.*;
GGSCI (node1) 6>
GGSCI (node1) 6> edit params rep1
GGSCI (node1) 7> view params rep1
REPLICAT rep1
USERID c##ggadmin@pdb2, password oracle
ASSUMETARGETDEFS
MAP pdb1.test.*, TARGET pdb2.test.*;
GGSCI (node1) 8>
GGSCI (node1) 8>
GGSCI (node1) 8> add replicat rep1, exttrail ./dirdat/ex, checkpointtable p002.c##ggadmin.checkpoint^[[D^[[1;5D^[[1;5D^[[1;5D^[[1;5D
ERROR: Invalid parameter specified for ADD REPLICAT.
GGSCI (node1) 9> add replicat rep1, exttrail ./dirdat/ex, checkpointtable pdb2.c##ggadmin.checkpoint
REPLICAT added.
GGSCI (node1) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:10:45
REPLICAT STOPPED REP1 00:00:00 00:00:02
GGSCI (node1) 11> exit
[oracle@node1 ogg12c]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:42:53 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> exec dbms_goldengate_auth.grant_admin_privilege('c##ggadmin','apply',container=>'pdb2');
PL/SQL procedure successfully completed.
SQL> select privilege from dba_sys_privs where grantee = 'C##ggadmin';
no rows selected
SQL> select privilege from dba_sys_privs where grantee = 'C##GGADMIN';
PRIVILEGE
----------------------------------------
CREATE JOB
ALTER ANY TABLE
UNLIMITED TABLESPACE
ALTER SESSION
CREATE RULE SET
LOGMINING
SET CONTAINER
FLASHBACK ANY TABLE
CREATE RULE
EXECUTE ANY RULE SET
CREATE EVALUATION CONTEXT
PRIVILEGE
----------------------------------------
SELECT ANY TABLE
CREATE SESSION
DEQUEUE ANY QUEUE
UNLIMITED TABLESPACE
15 rows selected.
SQL> EXIT
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@node1 ogg12c]$ GGSCI
-bash: GGSCI: command not found
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:12:39
REPLICAT STOPPED REP1 00:00:00 00:01:56
GGSCI (node1) 2> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (node1) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:12:44
REPLICAT STOPPED REP1 00:00:00 00:02:02
GGSCI (node1) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:12:47
REPLICAT STOPPED REP1 00:00:00 00:02:04
GGSCI (node1) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:12:50
REPLICAT STOPPED REP1 00:00:00 00:02:08
GGSCI (node1) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:12:51 00:00:01
REPLICAT STOPPED REP1 00:00:00 00:02:09
GGSCI (node1) 7> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (node1) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:12:51 00:00:06
REPLICAT STOPPED REP1 00:00:00 00:02:15
GGSCI (node1) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:12:51 00:00:09
REPLICAT STOPPED REP1 00:00:00 00:02:17
GGSCI (node1) 10> shell tail -10 ggserr.log
2016-10-07 07:44:26 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rep1.prm: Triggers will be suppressed by default.
2016-10-07 07:44:26 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:44:27 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rep1.prm: Checkpoint table pdb2.c##ggadmin.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command in GGSCI.
2016-10-07 07:44:27 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
2016-10-07 07:44:28 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:30 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
GGSCI (node1) 11> add checkpointtable pdb2.c##ggadmin.checkpoint
ERROR: Not logged into database, use DBLOGIN.
GGSCI (node1) 12> dblogin userid c##ggadmin,password oracle
Successfully logged into database CDB$ROOT.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 13> add checkpointtable pdb2.c##ggadmin.checkpoint
Successfully created checkpoint table pdb2.c##ggadmin.checkpoint.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:06 00:00:09
REPLICAT STOPPED REP1 00:00:00 00:05:28
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 15> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:10 00:00:02
REPLICAT RUNNING REP1 00:00:00 00:00:01
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 17> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:05 00:00:02
REPLICAT RUNNING REP1 00:00:00 00:00:00
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 18> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:05 00:00:03
REPLICAT RUNNING REP1 00:00:00 00:00:02
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 19> exit
[oracle@node1 ogg12c]$ sqlplus test1/oracle@pdb1
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:48:06 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@node1 ogg12c]$
[oracle@node1 ogg12c]$ sqlplus test/oracle@pdb1
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:48:23 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Fri Oct 07 2016 07:20:59 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select count(*) from source;
COUNT(*)
----------
0
SQL> begin
2 for i in 1..100
3 loop
4 insert into source values(i);
5 commit;
6 end loop;
7 end;
8 /
PL/SQL procedure successfully completed.
SQL> select count(*) from source;
COUNT(*)
----------
100
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:06 00:00:08
REPLICAT RUNNING REP1 00:00:00 00:00:00
GGSCI (node1) 2> stats ext1
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2016-10-07 07:49:15.
Output to ./dirdat/ex:
Extracting from PDB1.TEST.SOURCE to PDB1.TEST.SOURCE:
*** Total statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Daily statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Hourly statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Latest statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
End of Statistics.
GGSCI (node1) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:09 00:00:00
REPLICAT RUNNING REP1 00:00:00 00:00:03
GGSCI (node1) 4> stats rep1
Sending STATS request to REPLICAT REP1 ...
Start of Statistics at 2016-10-07 07:49:27.
Replicating from PDB1.TEST.SOURCE to PDB2.TEST.SOURCE:
*** Total statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Daily statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Hourly statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Latest statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
End of Statistics.
GGSCI (node1) 5> exit
[oracle@node1 ogg12c]$ sqlplus test/oracle@pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:49:43 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Fri Oct 07 2016 07:38:41 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select tname from tab;
TNAME
--------------------------------------------------------------------------------
SOURCE
SQL> select count(*) from source;
COUNT(*)
----------
100
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@node1 ogg12c]$ cat ggserr.log
2016-10-06 08:49:19 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): CREATE SUBDIRS.
2016-10-06 08:49:20 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): START MGR.
2016-10-06 08:49:20 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server collector.
2016-10-06 08:49:20 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #8).
2016-10-06 08:49:20 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-06 08:49:21 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): CREATE DATASTORE.
2016-10-06 08:49:50 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-06 08:50:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info mgr detail.
2016-10-06 08:50:22 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): create subdirs.
2016-10-06 08:54:01 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-06 09:14:18 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-06 09:14:23 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): create wallet.
2016-10-06 09:14:23 INFO OGG-02096 Oracle GoldenGate Command Interpreter for Oracle: Created wallet at location 'dirwlt'.
2016-10-06 09:14:23 INFO OGG-02096 Oracle GoldenGate Command Interpreter for Oracle: Opened wallet at location 'dirwlt'.
2016-10-06 09:14:46 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add credentialstore.
2016-10-06 09:14:46 INFO OGG-02096 Oracle GoldenGate Command Interpreter for Oracle: Credential store created in ./dircrd/.
2016-10-06 09:15:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add credentialstore add user C##GGADMIN@PDB1 ALIAS srcdb DOMAIN admin.
2016-10-06 09:15:43 INFO OGG-02096 Oracle GoldenGate Command Interpreter for Oracle: ERROR: Invalid argument 'add'.
2016-10-06 09:15:58 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): alter credentialstore add user C##GGADMIN@PDB1 ALIAS srcdb DOMAIN admin.
2016-10-06 09:16:00 INFO OGG-02096 Oracle GoldenGate Command Interpreter for Oracle: Credential store in ./dircrd/ altered.
2016-10-06 09:16:19 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info credentialstore domain admin.
2016-10-06 09:16:19 INFO OGG-02096 Oracle GoldenGate Command Interpreter for Oracle: Reading from ./dircrd/:.
2016-10-06 09:22:51 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-06 09:23:18 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin useridalias ALIAS srcdb DOMAIN admin.
2016-10-06 09:23:55 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid C##GGADMIN@PDB1 PASSWORD ***.
2016-10-06 09:24:17 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata source.
2016-10-06 09:24:49 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata sys.source.
2016-10-06 09:25:20 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata pdb1.source.
2016-10-06 09:48:55 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin useridalias srcdb.
2016-10-06 09:49:30 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin useridalias SRCDB.
2016-10-06 09:51:08 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin useridalias srcdb DOMAIN admin.
2016-10-06 09:51:22 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata test.source.
2016-10-06 09:54:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-06 11:57:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:21:33 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all;.
2016-10-07 07:21:35 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:21:38 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mr.
2016-10-07 07:21:40 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-10-07 07:21:40 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server collector.
2016-10-07 07:21:40 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #8).
2016-10-07 07:21:40 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-07 07:29:41 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:29:44 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:30:01 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid c#ggadmin password ***.
2016-10-07 07:30:18 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid c#ggadmin password ***.
2016-10-07 07:31:11 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid c##ggadmin password ***.
2016-10-07 07:31:30 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add extract ext1 integrated tranlog, begin now.
2016-10-07 07:31:46 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): register extract ext1 database container(pdb1).
2016-10-07 07:32:08 INFO OGG-02003 Oracle GoldenGate Command Interpreter for Oracle: Extract EXT1 successfully registered with database at SCN 1879420.
2016-10-07 07:32:40 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add schematrandata pdb1.source.
2016-10-07 07:32:40 ERROR OGG-01789 Oracle GoldenGate Command Interpreter for Oracle: Failed to ADD SCHEMATRANDATA on schema source, because schema does not exist.
2016-10-07 07:32:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add schematrandata pdb1.test.
2016-10-07 07:32:59 INFO OGG-01788 Oracle GoldenGate Command Interpreter for Oracle: SCHEMATRANDATA has been added on schema test.
2016-10-07 07:32:59 INFO OGG-01976 Oracle GoldenGate Command Interpreter for Oracle: SCHEMATRANDATA for scheduling columns has been added on schema test.
2016-10-07 07:33:12 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add exttrail ./dirdat/ex extract ext1.
2016-10-07 07:34:51 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtable pdb1.c##ggadmin.checkpoint.
2016-10-07 07:36:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:39:28 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:39:36 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2016-10-07 07:40:27 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params rep1.
2016-10-07 07:41:47 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add replicat rep1 exttrail ./dirdat/ex, checkpointtable p002.c##ggadmin.check.oint
2016-10-07 07:42:13 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add replicat rep1 exttrail ./dirdat/ex, checkpointtable pdb2.c##ggadmin.checkpoint.
2016-10-07 07:42:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:09 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:13 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2016-10-07 07:44:13 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.25]:63789 (START EXTRACT EXT1 ).
2016-10-07 07:44:13 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-07 07:44:13 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2016-10-07 07:44:13 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2016-10-07 07:44:13 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as UTF-8.
2016-10-07 07:44:13 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2016-10-07 07:44:14 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2016-10-07 07:44:14 INFO OGG-02623 Oracle GoldenGate Capture for Oracle, ext1.prm: Default source catalog name pdb1 will be used for source table name TEST.* mapping.
2016-10-07 07:44:14 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2016-10-07 07:44:14 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/BR/EXT1.
2016-10-07 07:44:14 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 140043626657536.
2016-10-07 07:44:14 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:44:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:18 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:19 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, ext1.prm: Database does not have streams_pool_size initialization parameter configured.
2016-10-07 07:44:19 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server DDL filtering enabled.
2016-10-07 07:44:21 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:21 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2016-10-07 07:44:21 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 12.1.0.2.0.
2016-10-07 07:44:21 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated Dictionary will be used.
2016-10-07 07:44:21 WARNING OGG-02905 Oracle GoldenGate Capture for Oracle, ext1.prm: Replication of OID column in object tables may diverge.
2016-10-07 07:44:21 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2016-10-07 07:44:21 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file ./dirdat/ex000000000, at RBA 0 (file not opened).
2016-10-07 07:44:21 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file ./dirdat/ex is using format RELEASE 12.2.
2016-10-07 07:44:22 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:25 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep1.
2016-10-07 07:44:25 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.25]:63790 (START REPLICAT REP1 ).
2016-10-07 07:44:25 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-07 07:44:25 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP1 starting.
2016-10-07 07:44:25 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 starting.
2016-10-07 07:44:26 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep1.prm: Operating system character set identified as UTF-8.
2016-10-07 07:44:26 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2016-10-07 07:44:26 INFO OGG-02679 Oracle GoldenGate Delivery for Oracle, rep1.prm: The Replicat process logged on to database PDB2 and can only apply to that database.
2016-10-07 07:44:26 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rep1.prm: Triggers will be suppressed by default.
2016-10-07 07:44:26 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:44:27 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rep1.prm: Checkpoint table pdb2.c##ggadmin.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command in GGSCI.
2016-10-07 07:44:27 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
2016-10-07 07:44:28 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:44:30 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:47:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtable pdb2.c##ggadmin.checkpoint.
2016-10-07 07:47:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid c##ggadmin password ***.
2016-10-07 07:47:35 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtable pdb2.c##ggadmin.checkpoint.
2016-10-07 07:47:41 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:47:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep1.
2016-10-07 07:47:43 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.25]:63806 (START REPLICAT REP1 ).
2016-10-07 07:47:43 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-07 07:47:43 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP1 starting.
2016-10-07 07:47:43 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 starting.
2016-10-07 07:47:43 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep1.prm: Operating system character set identified as UTF-8.
2016-10-07 07:47:43 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2016-10-07 07:47:43 INFO OGG-02679 Oracle GoldenGate Delivery for Oracle, rep1.prm: The Replicat process logged on to database PDB2 and can only apply to that database.
2016-10-07 07:47:43 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rep1.prm: Triggers will be suppressed by default.
2016-10-07 07:47:43 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:47:43 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2016-10-07 07:47:43 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, rep1.prm: Opened trail file ./dirdat/ex000000000 at 2016-10-07 07:47:43.698711.
2016-10-07 07:47:43 WARNING OGG-02760 Oracle GoldenGate Delivery for Oracle, rep1.prm: ASSUMETARGETDEFS is ignored because trail file ./dirdat/ex000000000 contains table definitions.
2016-10-07 07:47:43 INFO OGG-03522 Oracle GoldenGate Delivery for Oracle, rep1.prm: Setting session time zone to source database time zone 'GMT'.
2016-10-07 07:47:44 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:47:54 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:47:55 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:48:57 INFO OGG-06508 Oracle GoldenGate Capture for Oracle, ext1.prm: Wildcard MAP (TABLE) resolved (entry pdb1.TEST.*): TABLE "PDB1"."TEST"."SOURCE".
2016-10-07 07:48:57 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, ext1.prm: Using the following key columns for source table PDB1.TEST.SOURCE: ID.
2016-10-07 07:48:58 INFO OGG-03506 Oracle GoldenGate Delivery for Oracle, rep1.prm: The source database character set, as determined from the trail file, is UTF-8.
2016-10-07 07:48:58 INFO OGG-06506 Oracle GoldenGate Delivery for Oracle, rep1.prm: Wildcard MAP resolved (entry pdb1.test.*): MAP "PDB1"."TEST"."SOURCE", TARGET pdb2.test."SOURCE".
2016-10-07 07:49:00 INFO OGG-02756 Oracle GoldenGate Delivery for Oracle, rep1.prm: The definition for table PDB1.TEST.SOURCE is obtained from the trail file.
2016-10-07 07:49:00 INFO OGG-06511 Oracle GoldenGate Delivery for Oracle, rep1.prm: Using following columns in default map by name: ID.
2016-10-07 07:49:00 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, rep1.prm: Using the following key columns for target table PDB2.TEST.SOURCE: ID.
2016-10-07 07:49:11 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:49:15 INFO OGG-01021 Oracle GoldenGate Capture for Oracle, ext1.prm: Command received from GGSCI: STATS.
2016-10-07 07:49:23 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-07 07:49:27 INFO OGG-01021 Oracle GoldenGate Delivery for Oracle, rep1.prm: Command received from GGSCI: STATS.
[oracle@node1 ogg12c]$