Migration Utility: (download the Migration Utility from MOS)
Prerequisites for the Migration Utility:
Before running the migration utility, ensure the following:
- Java Version: Java 1.8 JRE or higher, as provided by Oracle GoldenGate.
- GoldenGate Version: GoldenGate 19.1 with Bundle Patch 200714 or later (for OGG MA).
- MA Deployment: A new Microservices Architecture (MA) deployment must be created, and all services must be running.
- Classic Deployment: All processes in the Classic deployment must be stopped. Any abended processes should be restarted and then properly shutdown.
- Deployment Location: The Classic deployment must either be on the same server as the MA deployment or have its file system accessible on that server.
- Environment Setup: The migration utility must be run from a shell or command prompt where the environmental variable is set for the MA deployment.
Migration Utility Restrictions:
The migration utility cannot handle processes with the following limitations:
- PUMP Processes: Cannot migrate if they perform transformations or use
dblogin
. - Classic Extract: Deprecated in GoldenGate 19c and unsupported in versions 21c and above for MA targets greater than 19.1.
- Unsupported Parameters: Processes using any of the following parameters:
MACRO
OBEY
MACROCHAR
- Remote Configurations: Does not support remote trail files, remote tasks, or initial load operations.
- Trail File Location: Trail files must be in
./dirdat
or its subdirectories. If located elsewhere, they must be moved to./dirdat
, and you need to use the “convchk” utility to update the checkpoint for Extract and adjust any Replicat parameters accordingly. - INCLUDE Restrictions:
- Nested
INCLUDE
statements are not supported. INCLUDE
can only be used in Extract and Replicat, not in Pump Extract.
- Nested