Hello and Good Day to Golden Gate Fellows,
I have prepared a test environment to get hands on practice of golden gate integrated extract and integrated replicate with oracle database 12c. every thing setup perfectly all relevant processes are running but replication to target schema is not happening at all.
please have my setup details .
O/S: red-hat linux 6.4 64-bit
oracle database: 12.1.0.2.0
golden gate: 12.1.2.0.0
I am trying to do replication between two different schema's within single database.
Kindly review stats information given below and please suggest.
---------------------------------------------- source
GGSCI (rhel64) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EINTA 00:00:09 00:00:03
EXTRACT RUNNING PINTA 00:00:00 00:00:08
GGSCI (rhel64) 3> stats einta
Sending STATS request to EXTRACT EINTA ...
Start of Statistics at 2014-09-24 01:42:28.
Output to ./dirdat/in:
Extracting from OGGSRC.GDP_BY_YEAR to OGGSRC.GDP_BY_YEAR:
*** Total statistics since 2014-09-24 01:12:56 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
*** Daily statistics since 2014-09-24 01:12:56 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
*** Hourly statistics since 2014-09-24 01:12:56 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
*** Latest statistics since 2014-09-24 01:12:56 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
End of Statistics.
GGSCI (rhel64) 4> stats pinta
Sending STATS request to EXTRACT PINTA ...
Start of Statistics at 2014-09-24 01:42:32.
Output to ./dirdat/pn:
Extracting from OGGSRC.GDP_BY_YEAR to OGGSRC.GDP_BY_YEAR:
*** Total statistics since 2014-09-24 01:13:00 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
*** Daily statistics since 2014-09-24 01:13:00 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
*** Hourly statistics since 2014-09-24 01:13:00 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
*** Latest statistics since 2014-09-24 01:13:00 ***
Total inserts 235.00
Total updates 235.00
Total deletes 235.00
Total discards 0.00
Total operations 705.00
End of Statistics.
---------------------------- TARGET
GGSCI (rhel64) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RINTA 00:00:00 00:00:07
GGSCI (rhel64) 2> stats rinta
Sending STATS request to REPLICAT RINTA ...
No active replication maps
Integrated Replicat Statistics:
Total transactions 0.00
Redirected 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%
.
-Thanks
X