Apply Oracle GoldenGate Patches and Upgrades when DDL support is Enabled

Use the following steps to apply a patch or upgrade to the DDL objects. This section explains how to apply Oracle GoldenGate patches and upgrades when DDL support is enabled.

Note:

If the release notes or upgrade documentation for your Oracle GoldenGate release contain instructions similar to those provided in this section, follow those instructions instead the ones in this section. Do not use this procedure for an upgrade from an Oracle GoldenGate version that does not support DDL statements that are larger than 30K (pre-version 10.4). To upgrade in that case, follow the instructions in Restoring an Existing DDL Environment to a Clean State.

This procedure may or may not preserve the current DDL synchronization configuration, depending on whether the new build requires a clean installation.

Run GGSCI. Keep the session open for the duration of this procedure.
Stop Extract to stop DDL capture.
```
STOP EXTRACT group
```
Stop Replicat to stop DDL replication.
```
STOP REPLICAT group
```
Download or extract the patch or upgrade files according to the instructions provided by Oracle GoldenGate.
Change directories to the Oracle GoldenGate installation directory.
Log in to SQL*Plus as a user that has SYSDBA privileges.
Disconnect all sessions that ever issued DDL, including those of Oracle GoldenGate processes, SQL*Plus, business applications, and any other software that uses Oracle. Otherwise the database might generate an ORA-04021 error.
Run the ddl_disable script to disable the DDL trigger.
Run the ddl_setup script. You are prompted for the name of the Oracle GoldenGate DDL schema. If you changed the schema name, use the new one.
Run the ddl_enable.sql script to enable the DDL trigger.
In GGSCI, start Extract to resume DDL capture.
```
START EXTRACT group
```
Start Replicat to start DDL replication.
```
START REPLICAT group
```