Manager Could not delete rows from gg_admin.GGS_DDL_HIST_ALT, no database specified. (Doc ID 1983130.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Goal

Manager report file shows the below:

2015-02-23 11:28:43 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from gg_admin.GGS_MARKER older than 2015-02-18 10:28:43.499543
: Could not delete rows from gg_admin.GGS_MARKER, no database specified.
2015-02-23 11:28:43 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from gg_admin.GGS_DDL_HIST older than 2015-02-18 10:28:43.4999
55: Could not delete rows from gg_admin.GGS_DDL_HIST, no database specified.
2015-02-23 11:28:43 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from gg_admin.GGS_DDL_HIST_ALT older than 2015-02-18 10:28:43.
500115: Could not delete rows from gg_admin.GGS_DDL_HIST_ALT, no database specified.
2015-02-23 11:58:44 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from gg_admin.GGS_MARKER older than 2015-02-18 10:58:44.144005
: Could not delete rows from gg_admin.GGS_MARKER, no database specified.
2015-02-23 11:58:44 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from gg_admin.GGS_DDL_HIST older than 2015-02-18 10:58:44.1547
86: Could not delete rows from gg_admin.GGS_DDL_HIST, no database specified.
2015-02-23 11:58:44 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from gg_admin.GGS_DDL_HIST_ALT older than 2015-02-18 10:58:44.
154955: Could not delete rows from gg_admin.GGS_DDL_HIST_ALT, no database specified.
 

Solution

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