本文共 2095 字，大约阅读时间需要 6 分钟。

Add HeartBeatTable Is Failing With OGG-14036: Schema Is Required For Heartbeattable : gg_heartbeat. (Doc ID 2096088.1)

Oracle GoldenGate - Version 12.2.0.1.0 and later

Information in this document applies to any platform.

SYMPTOMS

Add HEARTBEATTABLE in 12.2 is failing with

GGSCI () > add HEARTBEATTABLE 2016-01-07 04:28:56 ERROR OGG-14036 Schema is required for heartbeattable : gg_heartbeat.

CAUSE

Configuration issue

 

SOLUTION

Please follow below steps to fix the issue.

1) Speciify the GGSCHEMA in GLOBALS GGSCHEMA <GGSOWNER>  Once done, exit and re-login the GGSCI prompt. 2) Log into the database GGSCI > dblogin userid ggs12owner, password ggsowner Successfully logged into database. 3) GGSCI > add heartbeattable

This should display the HeartBeat tables creation like below

2016-01-07 18:45:38 INFO OGG-14001 Successfully created heartbeat seed table ["GG_HEARTBEAT_SEED"]. 2016-01-07 18:45:38 INFO OGG-14032 Successfully added supplemental logging for heartbeat seed table ["GG_HEARTBEAT_SEED"]. 2016-01-07 18:45:38 INFO OGG-14000 Successfully created heartbeat table ["GG_HEARTBEAT"]. 2016-01-07 18:45:38 INFO OGG-14033 Successfully added supplemental logging for heartbeat table ["GG_HEARTBEAT"]. 2016-01-07 18:45:38 INFO OGG-14016 Successfully created heartbeat history table ["GG_HEARTBEAT_HISTORY"]. 2016-01-07 18:45:39 INFO OGG-14023 Successfully created heartbeat lag view ["GG_LAG"]. 2016-01-07 18:45:39 INFO OGG-14024 Successfully created heartbeat lag history view ["GG_LAG_HISTORY"]. 2016-01-07 18:45:39 INFO OGG-14003 Successfully populated heartbeat seed table with [ORA1]. 2016-01-07 18:45:39 INFO OGG-14004 Successfully created procedure ["GG_UPDATE_HB_TAB"] to update the heartbeat tables. 2016-01-07 18:45:39 INFO OGG-14017 Successfully created procedure ["GG_PURGE_HB_TAB"] to purge the heartbeat history table. 2016-01-07 18:45:39 INFO OGG-14005 Successfully created scheduler job ["GG_UPDATE_HEARTBEATS"] to update the heartbeat tables. 2016-01-07 18:45:39 INFO OGG-14018 Successfully created scheduler job ["GG_PURGE_HEARTBEATS"] to purge the heartbeat history table.  

转载地址：http://qzsof.baihongyu.com/