1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Managing the DDL Replication Environment
  6. Applying Database Patches and Upgrades when DDL Support is Enabled

Applying Database Patches and Upgrades when DDL Support is Enabled

Database patches and upgrades usually invalidate the Oracle GoldenGate DDL trigger and other Oracle GoldenGate DDL objects.

Before applying a database patch, do the following.

  1. Log in to SQL*Plus as a user that has SYSDBA privileges.
  2. Disable the Oracle GoldenGate DDL trigger by running the ddl_disable script in SQL*Plus.
  3. Apply the patch.
  4. Enable the DDL trigger by running the ddl_enable script in SQL*Plus.

Note:

Database upgrades and patches generally operate on Oracle objects. Because Oracle GoldenGate filters out those objects automatically, DDL from those procedures is not replicated when replication starts again.

To avoid recompile errors after the patch or upgrade, which are caused if the trigger is not disabled before the procedure, consider adding calls to @ddl_disable and @ddl_enable at the appropriate locations within your scripts.