GoldenGate: relative or absolute path for trail files?
When implementing GoldeGate solutions, something as simple as path to trail files can create havoc. What is the correct path for trail format? It depends. There is one important factor to consider.
You can change any of the attributes specified with the ADD EXTRACT command, except for the following: Altering an Extract specified with the EXTTRAILSOURCE option. Altering the number of RAC threads specified with the THREADS option.Reference: Oracle® GoldenGate Reference for Oracle GoldenGate for Windows and UNIX (ALTER EXTRACT) The above restriction could be an influencing factor when deciding to use absolute path. Using relative path for trail files:
- Need to create symbolic link originally if not residing from GoldenGate Home.
- No need to recreate symbolic link when relocating trail.
- No need to recreate extract when relocating trail.
- No need to modify parameter for GoldenGate extracts/replicats/manager when relocating trail.
- Need to create multiple symbolic links for GoldenGate on RAC.
- Need to create new symbolic links for trail using out-of-place GoldenGate upgrade.
- No need to create symbolic link originally.
- No need to recreate symbolic link when relocating trail.
- Need to recreate extract when relocating trail.
- Need to modify parameter for GoldenGate extracts/replicats/manager when relocating trail.
- No need to create multiple symbolic links for GoldenGate on RAC.
- No need to create new symbolic links for trail using out of place GoldenGate upgrade.
Share this
You May Also Like
These Related Stories
GoldenGate 12.2 big data adapters: part 5 - MongoDB
GoldenGate 12.2 big data adapters: part 5 - MongoDB
Sep 8, 2016
14
min read
GoldenGate 12.2 big data adapters: part 3 - Kafka
GoldenGate 12.2 big data adapters: part 3 - Kafka
Mar 31, 2016
16
min read
GoldenGate 12.2 big data adapters: part 4 - HBASE
GoldenGate 12.2 big data adapters: part 4 - HBASE
May 11, 2016
13
min read
No Comments Yet
Let us know what you think