Oracle goldengate configuration best practices.
Oracle golden gate configuration file.
In a basic oracle goldengate configuration with only a trail on the target system there is nowhere on the source system to store the data operations that extract continuously extracts into memory.
To avoid issues caused by character set incompatibilities.
Oracle goldengate basic configuration.
Oracle goldengate creates parameter files in the default character set of the local operating system.
You can edit this file at any point before starting processing by using the edit params command in ggsci.
If the network or the target system becomes unavailable extract could run out of memory and abend.
Ensuring the availability of the checkpoint files is essential to ensure that after a failure occurs the extract process can continue.
It is intended for research and or training purposes and is not intended to be a production configuration.
Protection against network and target failures.
In the event that the local platform does not support a required character set as the default in the operating system you can use the charset parameter either globally or per process to specify a character set for parameter files.
Once the basic configuration has been tested new features can be added incrementally simplifying any troubleshooting.
The following procedure describes a minimal oracle golden gate configuration.
Enter any optional replicat parameters that are recommended for your configuration.
For more information see the reference for oracle goldengate and optional parameters for integrated modes for additional configuration considerations.