1. Oracle GoldenGate Classic Architecture Documentation
  2. Upgrade
  3. Upgrading Oracle GoldenGate for Non-Oracle Databases
  4. Oracle GoldenGate Upgrade Considerations
  5. Extract Upgrade Considerations

Extract Upgrade Considerations

Running Extract in classic mode (non-integrated Extract) with the Oracle database has been desupported. Before upgrading Extracts running in classic mode (non-integrated Extract) with the Oracle database, you need to upgrade the Extracts to run in integrated mode.

Upgrading Classic Extract to Integrated Extract for Oracle

As classic Extract is desupported, you must upgrade the classic Extract to an integrated Extract. Stop the classic Extract, which were configured with DDL capture, and remove the DDL triggers prior to upgrading to an integrated Extract.

Remove the DDL triggers:

  • ddl_disable

  • ddl_remove

  • marker_remove

To upgrade to Extract, use the following command:
ALTER EXTRACT group_name to UPGRADE INTEGRATED TRANLOG

Also, see Switching Extract from Classic Mode to Integrated Mode in Administering Oracle GoldenGate.