Golden Gate Maintenance: known errors

From Robs_Wiki
Jump to: navigation, search

WARNING OGG-01151 Error mapping from source_schema.TBL1 to target_schema.TBL1

One of the reasons for this error can be that supplemental logging is not enabled for the table. In that case no mappings can be made. Check as follows:

-- at the schema level
GGSCI (rob01db01.localdomain as ggadmin@prd12c) 8> info schematrandata orabup0

2017-08-14 10:01:39  INFO    OGG-06480  Schema level supplemental logging, excluding non-validated keys, is enabled on schema ORABUP0.

2017-08-14 10:01:39  INFO    OGG-01980  Schema level supplemental logging is enabled on schema ORABUP0 for all scheduling columns.

2017-08-14 10:01:39  INFO    OGG-10462  Schema ORABUP0 have 2 prepared tables for instantiation.
-- at the table level
GGSCI (rob01db01.localdomain as ggadmin@prd12c) 9> info trandata orabup0.gg_tbl_custom_heartbeat
2017-08-14 10:02:36  INFO    OGG-06480  Schema level supplemental logging, excluding non-validated keys, is enabled on schema ORABUP0.

2017-08-14 10:02:36  INFO    OGG-01980  Schema level supplemental logging is enabled on schema ORABUP0 for all scheduling columns.

Logging of supplemental redo log data is enabled for table ORABUP0.GG_TBL_CUSTOM_HEARTBEAT.

Columns supplementally logged for table ORABUP0.GG_TBL_CUSTOM_HEARTBEAT: ID.

Prepared CSN for table ORABUP0.GG_TBL_CUSTOM_HEARTBEAT: 2014519

ERROR OGG-01224 Address already in use OGG-01668 PROCESS ABENDING

This error can be encountered on a consolidated platform, where you have multiple Golden Gate instances up and running. The manager of one instance can't start because the port is used by the replicat of another Golden Gate instance.

How to check: First look into the manager report file to review the error. Then check to see if the address is in use:

[root@cdf-dm1dbadm02 ~]# netstat -nap | grep 7840
tcp        0      0 :::7840                     :::*                        LISTEN      321096/replicat
unix  3      [ ]         STREAM     CONNECTED     1378402 114214/ora_lmon_psy
unix  3      [ ]         STREAM     CONNECTED     1278406 107944/crsd.bin     /var/tmp/.oracle/sprocr_local_conn_0_PROC

-- note: 7840 is the manager port

How to solve:

  • stop the replicat that uses the 7840 address
  • start the manager that experienced the error
  • restart the replicat