GoldenGate Configuring DDL Replication - one Way (Doc ID 1950942.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Goal

On : 11.2.1.0.1 version, 1 - Oracle DB backend ( 11.2.0.3 ) version.

Problem in setting up DDL replication -one way

Problem Description --

Due to database corruption, Source database has been refreshed from rman and after that  entire GG setup (disabled ddl and removed extract,pump and replicat ) were removed.

After that when you rebuild the GG  and setup the DDL , hit an error

sys@user> @ddl_setup
DDL IGNORE TABLE
-----------------------------------
FAILED: Table does not exist
DDLAUX PACKAGE BODY STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/25 PLS-00304: cannot compile body of 'DDLAUX' without its
  specification
1/25 PLS-00905: object GGADMIN.DDLAUX is invalid
DDL TRIGGER CODE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
657/18 PLS-00905: object GGADMIN.DDLAUX is invalid
657/5 PL/SQL: Statement ignored
STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
ERRORS detected in installation of DDL Replication software components (6.1)

we tried to run these grants and that also failed, request your help as how to fix this.
sys@user> grant create any table to ggadmin;
grant create any table to ggadmin
*
ERROR at line 1:
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation

This was an existing setup which we had never had issues before.

--> ggs_ddl_trace file

014-11-18 23:34:43  ERROR   OGG-00529  Oracle GoldenGate Capture for Oracle, Extract.prm:  DDL Replication is enabled but table GGADMIN.GGS_DDL_HIST is not found. Please check DDL installation in the database. 2014-11-18 23:34:43  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, Extract.prm:  PROCESS ABENDING

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.