Replicating from MYSQL slave DB using Oracle GoldenGate (Doc ID 2039325.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

2015-07-14 12:34:48 WARNING OGG-06439 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table CARDMANAGE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2015-07-14 12:34:48 ERROR OGG-00423 Oracle GoldenGate Delivery for Oracle, rep1.prm: Could not find definition for p2p_hb.cardmanage.
2015-07-14 12:34:48 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
2015-07-14 12:37:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.




2015-07-14 12:42:54 WARNING OGG-06439 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table USER_LIST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2015-07-14 12:42:54 ERROR OGG-00423 Oracle GoldenGate Delivery for Oracle, rep1.prm: Could not find definition for p2p_hb.user_list.
2015-07-14 12:42:54 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
2015-07-14 12:45:47 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.




2015-07-14 12:48:33 WARNING OGG-06439 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table AWE_JSP_RUNTIME. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2015-07-14 12:48:33 ERROR OGG-00423 Oracle GoldenGate Delivery for Oracle, rep1.prm: Could not find definition for p2p_hb.awe_jsp_runtime.
2015-07-14 12:48:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.


2015-07-14 13:46:00 WARNING OGG-06439 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table USER_ACCOUNT. All viable columns will be used to represent the key, but ma

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms