Oracle 19C OGG basic operation and maintenance-04DML synchronization FAQ

Oracle 19C OGG basic operation and maintenance-04DML synchronization FAQ

One: failed to add checkpoints on the source side

Error: No checkpoint table specified. Using GLOBALS specification c##ogg.ggschkpt...

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 2 > ADD CHECKPOINTTABLE

No checkpoint table specified. Using GLOBALS specification c##ogg.ggschkpt...

ERROR: Catalog name is missing from checkpoint table specification c##ogg.ggschkpt.

Solution: specify the database name before the user

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 2 > ADD CHECKPOINTTABLE CDB$ROOT.c##ogg.ggschkpt

Two: failed to start the crawl process ext_01

Error: Classic Extract does not support multitenant container databases.

[oracle@cjcos01 ogg] $tail-f ggserr.log

.

2020-04-09T13:29:22.503+0800 ERROR OGG-06220 Oracle GoldenGate Capture for Oracle, ext_01.prm: Classic Extract does not support multitenant container databases.

2020-04-09T13:29:22.582+0800 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext_01.prm: PROCESS ABENDING.

Solution: add ext_ 01:00 specify INTEGRATED

Add extraction process

-add extract ext_01,tranlog,begin now

-delete extract ext_01

ADD EXTRACT ext_01,INTEGRATED TRANLOG,BEGIN NOW

Three: failed to add pump process

Error: ERROR: Invalid group name (must be at most 8 characters).

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 10 > add extract extpump_01,exttrailsource / ogg/dirdat/rt

ERROR: Invalid group name (must be at most 8 characters).

Solution: the process name cannot be more than 8 characters. Change extpump_01 to pump_01.

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 10 > add extract pump_01,exttrailsource / ogg/dirdat/rt

4: failed to start the application process rep_01

Error: Checkpoint table chenpdb.ogg.checkpoint does not exist

2020-04-09T13:49:54.378+0800 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rep_01.prm: Checkpoint table chenpdb.ogg.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command.

Solution:

Check that when setting. / GLOBALS, the table name is chenpdb.ogg.ggschkpt, and when adding the rep_01 process, it is mistakenly written as chenpdb.ogg.ggschkpt, which leads to the failure of starting rep_01 later. Delete rep_01 and add again.

Add replicat rep_01,exttrail / ogg/dirdat/mb, CHECKPOINTTABLE chenpdb.ogg.ggschkpt

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!