Upgrading a Configuration That Includes DDL Support

This section contains considerations and steps you should take when DDL support is active in the Oracle GoldenGate environment.

DDL support in Oracle GoldenGate offers two options:

• The Integrated mode supports two DDL capture methods:

  • If the source database is Oracle 11.2.0.4 or later, DDL capture support is integrated into the database logmining server and does not require the use of the Oracle GoldenGate DDL trigger and supporting objects, as long as the database COMPATIBLE parameter is set to 11.2.0.4 or higher.

  • If the source database is earlier than Oracle 11.2.0.4, the Oracle GoldenGate trigger and supporting DDL objects must be used when Extract is in integrated mode.

• Classic capture requires the use of the Oracle GoldenGate DDL trigger and supporting objects regardless of the release number of the source Oracle database. (Source system) If you plan to use trigger-based DDL support for Oracle Database, use the following sub-steps to rebuild the Oracle GoldenGate DDL trigger environment to a clean state:

  1. Run SQL*Plus and log in as a user that has sysdba privileges.

  2. Run the marker_setup script to reinstall the Oracle GoldenGate marker support system and provide the name of the Oracle GoldenGate schema.

  3. Run the ddl_setup script and provide the name of the Oracle GoldenGate DDL schema.

  4. Run the role_setup script to recreate the Oracle GoldenGate DDL role.

  5. Grant the role that you created to all Oracle GoldenGate users under which the following Oracle GoldenGate processes run: Extract, Replicat, GGSCI, and Manager. You may need to make multiple grants if the processes have different user names.

  6. Run the ddl_enable.sql script to enable the Oracle GoldenGate DDL trigger.

Table -2 shows possible DDL upgrade paths and guidelines.

Table -2 Possible Upgrade Paths to Oracle GoldenGate and Requirements for DDL Support

Upgrade from:	To: Classic capture using trigger method	To: Integrated capture, no trigger(1)
Classic capture using trigger method (all 11.2.1 database versions)	Cannot be used for a container database. Upgrade Oracle GoldenGate per these upgrade instructions.	Can be used for a container database. Source database must be 11.2.0.4 or higher. Source database COMPATIBLE setting must be 11.2.0.4 or higher. Upgrade Oracle GoldenGate per these upgrade instructions.
Integrated capture using trigger method (all 11.2.1 database versions)	Cannot be used for a container database. No DDL upgrade path.	Can be used for a container database. Source database must be 11.2.0.4 or higher. Source database COMPATIBLE setting must be 11.2.0.4 or higher. Upgrade Oracle GoldenGate per these upgrade instructions.

^Footnote 1 An upgrade of the database to 11.2.0.4 or 12.1 automatically takes a data dictionary snapshot in the redo stream as part of the patch set upgrade.