ALLOWOUTPUTDIR – Fix OGG-25127 XXXX not in any allowed output directories.

Symptoms: Pump report: 2020-11-20 19:05:58 ERROR OGG-25127 Received an error reply requesting a graceful shutdown. (Reply received is ‘GSOutput file /u01/app/ogg/dirdat/target/TT000000 is not in any allowed output directories.’.). Cause: With this parameter, we can authorize GoldenGate to use a different location than its home to store trail files. If you need different directories for your […]

Use OPatch to check Oracle GoldenGate version

Use OPatch to check Oracle GoldenGate version Recently on I was strolling the OTN message boards and came across a question about identifying the version of Oracle GoldenGate using OPatch. This was the second time I came across this question; with that I decided to take a look and see if Oracle GoldenGate information could […]

OGG Manager could not purge old trail file

OGG Manager could not purge old trail file Symptom: manager could not purge old trail files while not extract or replicat is existing in this ogg, because this ogg is only receiving trail from source and cascade data to target. GGSCI (OGGVM01) 2> edit param mgr PURGEOLDEXTRACTS /u01/app/ogg/dirdat/DD*, USECHECKPOINTS, MINKEEPDAYS 30 Solution: GGSCI (OGGVM01) 2> […]