- Use GGSCI commands to view: Processing Status, Events, Errors and Checkpoints
- View Oracle GoldenGate reports and logs: Process Reports, Error Log, Discard File and System Logs
Event (Error) Log
Oracle GoldenGate Event Log lists show:
– A history of GGSCI commands
– Processes that started and stopped
– Errors that occurred
– Informational messages
The Event Log also shows events leading to an error.
For Example, you might discover one of the following:
– Someone stopped a process.
– A process failed to make a TCP/IP or database connection.
– A process could not open a file.
Use one of the following to view the Event Log:
– A standard text editor or a shell command
– The GGSCI command View GGSEVT (GoldenGate Software Event)
– Oracle GoldenGate Monitor or Director
Note: Error messages can have different numbers and layouts for different platforms and versions.
Discard File (Created for each Group)
A discard file:
– Is created if the DiscardFile <filename> parameter is used in the Extract or Replicat parameter file
– Is created when Extract or Replicat has a problem with the record that it is processing
– Contains column-level details for operations that the process cannot handle
– Is usually used for Replicat to log operations that cannot be reconstructed or applied
– Can help you resolve data-mapping issues
- Oracle GoldenGate writes operating system level errors to the Event Viewer (in Windows) or to the syslog (in Unix).
- Windows: Use the ADDEVENTS option of the INSTALL program to add generic GoldenGate events to the Event Manager. – Shell> install addevents.
- UNIX: System log is enabled by default. For more specific messages, copy category.dll and ggsmsg.dll from the Oracle GoldenGate directory to the SYSTEM32 directory
These errors also appear in the Event Log.